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.
Released for: Schneider Electric Canada
Need help?
Product Selector
Quickly and easily find the right products and accessories for your applications.
Get a Quote
Start your sales inquiry online and en expert will connect with you.
Where to buy?
Easily find the nearest Schneider Electric distributor in your location.
Help Center
Find support resources for all your needs, in one place.