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.
Gepubliceerd voor: Schneider Electric Belgium
Hulp nodig?
Selecteer zelf het juiste product
Vind snel en eenvoudig de juiste producten en toebehoren voor uw toepassingen.
Offerte aanvragen
Dien uw aanvraag online in en een expert zal contact met u opnemen.
Verkooppunten
Vind eenvoudig de dichtstbijzijnde distributeur van Schneider Electric op uw locatie.
Help Center
Vind de antwoorden die u nodig heeft via bladeren door veelgestelde vragen over onderwerpen.