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.0

SQL 2008, 2008 R2, 2012

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


*********Only Users that are familiar with executing queries in SQL Server Management Studio should perform this task**********

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 d.Name, di.deviceType, di.Revision, di.SerialNumber
from device d
join IRM_DeviceInfo di on d.Name = di.Name

--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  -- could also order by Revision or DeviceType

3) Remove the comment (--) any filters you may want to add.

4) Execute the query and copy the result to desired report
Was this helpful?
What can we do to improve the information ?