Technical FAQs

Ask a Question

How to quickly determine what measurements are being logged for a source in PME

Issue:
A customer would like to quickly determine which measurements are being logged for a source in PME. 

Product Line:
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x / 8.0

Environment:
SQL Server Management Studio

Resolution:

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

1) The following query can be run in SQL Server Management Studio. This will return a list of all measurements logged for the given source, as well as the Min and Max timestamps of the data in the ION_Data database. 

USE ION_Data
Select * From dbo.vSourceQuantityName
Where SourceName = 'Group.Meter'
Order by QuantityName

*Note: Replace 'Group.Meter' with the name of the source you are trying to query (leave the single quotes). 
Was this helpful?
What can we do to improve the information ?