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.
Udgivet til: Schneider Electric Danmark
Brug for hjælp?
Produktvælger
Find hurtigt og nemt de rette produkter og det rette tilbehør til dine anvendelser.
Få et tilbud
Start din salgsforespørgsel online, så vil du blive kontaktet af en ekspert.
Find forhandler
Find den nærmeste Schneider Electric-distributør.
Hjælpecenter
Find supportressourcer til alle dine behov på ét sted.