Ask a Question

How to Generate a List of Default Diagrams for Devices

Issue
How to generate a list of devices in Power Monitoring Expert, and for each device the URL to the device diagram in WebReach.

Product Line
Power Monitoring Expert, PME

Environment
A browser such as Internet Explorer or Chrome.

Cause
Easily creating the links that could be used to access device diagrams in a browser.

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

To generate the list of default diagrams:

Log into SQL Server Management Studio (SSMS)

Click on New Query

Paste the following query into the new query pane:

Use ION_Network
SELECT
'http://<server_name>/default.aspx?dgm=OPEN_TEMPLATE_DIAGRAM&node='+ Name
FROM dbo.device
ORDER BY Name

Where <server_name> should be replaced with SQL Server instance name which has the ION databases. In this case HPBTM631/ION is used.