Technical FAQs

Ask a Question

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

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
Power Monitoring Expert 8.x

SQL 2008, 2008 R2, 2012

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
Was this helpful?
What can we do to improve the information ?