{}

Våra varumärken

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

Välkommen till Schneider Electrics webbplats

Välkommen till vår webbplats.
Hur kan vi hjälpa dig idag?
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 Sverige

Utforska mer
Produkt:
Artiklar som kan vara till nytta
Utforska mer
Produkt: