Browse FAQs

Video: PME - GetNativeSQL - How to use Vista to create SQL Queries

Published date: 01 June 2020

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. 

Product Line
ION Enterprise 
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x
EcoStruxure™ 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 or video below for details. 

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.