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.