Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
Goals and Symptoms
When running a Event History Report in IONE 6, the results are not sorted properly, and they may show up similar to the report below.
Facts and Changes
ION Enterprise 6.0
Causes and Fixes
The data in the database does not always get entered in the same timestamp order as the meter data.
There is no stored procedure for the sorting of the Event History Report. Below is a sql script that will update the stored procedure to organize the report by timestamp.
Note: It is best practice to take a backup of the ION databases before running a SQL query which will modify them.
This needs to be run on the database machine. If Management Console is installed, double-clicking the file will automatically open it. Alternately, a new query can be run in SQL Management Studio and the contents of the .sql file can be copied into the query window.
After executing the sql script the report should look more like the pictures below.
Sign up for all the latest solutions, offers and best practices straight to your inbox.
We are excited that you have joined the group. You will receive your welcome email soon describing the program and what to expect in the upcoming weeks. Enjoy!