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 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 (--) 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 ?