The Internet of Things (IIoT) offers unprecedented possibilities for industries. Stay ahead with EcoStruxure™ Plant and Machine.Learn more
...with the EcoStruxure™ Facility Expert (formerly known as 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
The story behind the Shedd Aquarium, a smart, sustainable facility that connects people to animals, with EcoStruxure™.Discover how
Welcome to the Schneider Electric Global Website×
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!