Browse FAQs

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

Published date: 20 December 2018

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

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

Replace 'Group.Meter' with the name of the source you are trying to query (leave the single quotes). 

*Note: The above query will work in Power Monitoring Expert 9.0, however the new Manual Data Editor can also be used to quickly determine what measurements have data for a particular source. 

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.