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
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.