Technical FAQs

Ask a Question

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

Issue:
User 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.0

Environment:
SQL 2008, 2008 R2, 2012

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

Resolution:

*********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 '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 d.name  -- 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 ?