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×
A user would like to create a SQL query to obtain data directly from the ION_Data database. SQL Server Management Studio requires users to have advanced knowledge in writing SQL queries where as the Vista application provides a convenient wizard interface to create the query. The Data Log Viewer provides an "Edit SQL" option to view the Vista query, but these commands do no work in SQL.
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
SQL Server Management Studio
The queries created by the Vista Wizard can not be directly run in SQL.
*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up prior to performing this procedure.*
There is a command called 'GetNativeSQL' can be added to the "Edit SQL" in the Vista Wizard that will allow the user to obtain the native SQL commands required to query the ION_Data database directly in SQL Server Management Studio.
See attached document for instructions.
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!