{}

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric corporate Website

Search FAQs
Is it possible to tell when a device was first added into a PME system?

Issue:
A PME user would like to know when a device was first added into the PME system.

Product Line:

Power Monitoring Expert 7.2.x

Power Monitoring Expert 8.x

Power Monitoring Expert 9.0

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024



Environment:
Power Monitoring Expert with SQL Server

Resolution:
** The procedure below requires familiarity with SQL Server Management Studio (SSMS).  Please ensure that recent database back ups are available before working inside the ION databases **

1) The source ID for the device will need to be identified from the "ION_Network.dbo.SRC_Source" table. Right click on the dbo.SRC_Source table and chose the "Select Top 100 Rows" option then locate the device within the list.  Note the number in the ID column for this particular device.

2) Using the source ID identified in step 1 we will want to run the SQL query below:

SELECT * FROM ION_Network.dbo.IAS_MeasurementAddress
WHERE SourceID = <ID from step 1>

Example:

SELECT * FROM ION_Network.dbo.IAS_MeasurementAddress
WHERE SourceID = 5

The ION_Network database table 'dbo.IAS_MeasurementAddress' contains a column labeled 'TimeResolvedUTC'.  This timestamp represents when each measurement was first pulled into the system for that device.  The earliest timestamp should closely approximate when the meter was added into the Management Console.

Schneider Electric Global

Explore more
Product:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Product: