Browse FAQs

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

Published date: 29 July 2020

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

Power Monitoring Expert 7.2.x, 8.x, 9.x

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

There is not a central location to easily view device firmware information that can be exported


*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 prior to 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 =
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 '') --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 filtes can be added

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

** see attachment containing the SQL script text

Was this helpful?

What can we do to improve the information ?

Can't find what you are looking for?

Reach out to our customer care team to receive information on technical support, assistance for complaints and more.