Technical FAQs

Ask a Question

Video: Enabling Device Volts Mode via SQL Query in Power Monitoring Expert

Issue
How to find the volts mode setting in devices using PME.

Product Line
Power Monitoring Expert 8.2 (PME 8.2)

Note: Applies to any version which has similar ION_Network database schema as in PME 8.2.

Environment
SQL Server Management Studio (SSMS)

Cause
An easy way to list the volts mode for all devices in the system.

Resolution
*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.*

In SQL Management Studio:
1. Start a new query
2. Copy and paste the following query:
use ion_network
select di.name, vm.name
from irm_deviceinfo as di
join irm_voltsmode as vm
on di.voltsmodeid = vm.id
3. Execute the query

note: The above query is attached.

The following video demonstrates the process:

Was this helpful?
What can we do to improve the information ?