Technical FAQs

Ask a Question

How to quickly determine what measurements have been logged for a source in PME

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

SQL Server Management Studio


*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. It will return a list of all measurements that have been logged (at least once) for the given source, as well as the Min and Max timestamps of the data in the ION_Data database. 

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 ?