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

Search FAQs

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
SQL Server 2008

SQL Server 2008 R2

SQL Server 2012

SQL Server 2014

SQL Server 2016

SQL Server 2017

SQL Server 2019

SQL Server 2022

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