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 / 9.0 / 2020 / 2021 / 2022 / 2023
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. 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.
USE ION_Data
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 and up, however the new Manual Data Editor can also be used to quickly determine what measurements have data for a particular source.
StruxureWare Power Monitoring 7.0.x
Power Monitoring Expert 7.2.x / 8.x / 9.0 / 2020 / 2021 / 2022 / 2023
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. 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.
USE ION_Data
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 and up, however the new Manual Data Editor can also be used to quickly determine what measurements have data for a particular source.