Technical FAQs

Ask a Question

How to determine when a device was added to ION Enterprise or SPM 7.0

Issue
User wants to know when a device was added to ION Enterprise 6.0, SPM 7.0 or PME 7.2.x, 8.x

Product
ION Enterprise 6.0
StruxureWare Power Monitoring 7.0

Environment
SQL Server management Studio

Cause
User wants to know when a device was added to ION Enterprise 6.0 or SPM 7.0

Resolution
1. Open SQL Server Management Studio and connect to the ION instance. (Make use the user connecting to the instance can read tables in ION_network Database)
2. Start a new query against the ION_Network database
3. Execute the following command
Select Name, dateAdd from SRC_Source
Order by Name


A list of devices and the date the device was added to the system will display.
Note: This query will not work with PME 7.2 and later
Was this helpful?
What can we do to improve the information ?