Technical FAQs

Ask a Question

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:
ION Enterprise / Struxureware Power Monitoring / Power Monitoring Expert

Environment:
ION-E / SPM / PME software

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

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.
Was this helpful?
What can we do to improve the information ?