How to Query a PME System's Database to retrieve device firmware versions

Issue
Users would like to see the firmware versions of some or all of the devices in the PME system in one table.

Product
Power Monitoring Expert 7.2.x
Power Monitoring Expert 8.x
Power Monitoring Expert 9.x
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
QL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 2014, SQL Server 2016

Cause
There is no central location to easily view device firmware information that can be exported

Resolution

*Warning: Irreparable database damage can occur. This procedure should only be performed by users familiar with SQL Server Management Studio. Databases should be backed up before performing this procedure.*

1) Open SQL Server Management Studio and connect to the SQL instance used by PME, typically ION.

2) Open a new query window and copy the text below

/* Below is a query to list all of the device types in the system and their firmware/template information. ExceptionType  {5u void "} indicates an issue retrieving firmware/template information.
For PM or CM devices, the major and minor releases are not separated by '.'
10430 = Firmware 10.43
*/
Use ION_Network
Select s.displayname, di.deviceType, di.Revision, di.SerialNumber, g.address,  p.Address as port, d.Address as DeviceID
from device d
join IRM_DeviceInfo di on d.Name = di.Name 
join SRC_Source s on s.name = d.name
join Port p on d.PortID = p.ID
join gate g on p.GateID = g.ID
--Following filter
where DeviceType not like 'VIP'
-- and not (di.Revision = 'V1.0.0' or di.Revision = 'V1.1.4' or di.Revision = 'V1.1.1' or di.Revision like '1.0.0.0') --uncomment if you want to exclude modbus
--devices with drivers not providing firmware version.
-- and DeviceType like 'PM8%'  --Uncomment if you want to filter search by device type
order by s.displayname  -- could also order by Revision or DeviceType

3) Remove the comment (--) before any existing filters you may want to add. Additional files can be added

4) Execute the query and copy the result to the desired report

** See attachment containing the SQL script text

Released for:Schneider Electric Saudi Arabia