Technical FAQs

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:
  1. Log into SQL Server Management Studio (SSMS)
  2. Click on New Query
  3. 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.


Here is an example of the result set:
 
http://HPBTM631/ION/default.aspx?dgm=OPEN_TEMPLATE_DIAGRAM&node=ION.a7650
http://HPBTM631/ION/default.aspx?dgm=OPEN_TEMPLATE_DIAGRAM&node=OFF.off8650A
http://HPBTM631/ION/default.aspx?dgm=OPEN_TEMPLATE_DIAGRAM&node=PL.BCPM_1
http://HPBTM631/ION/default.aspx?dgm=OPEN_TEMPLATE_DIAGRAM&node=PL.CM4
http://HPBTM631/ION/default.aspx?dgm=OPEN_TEMPLATE_DIAGRAM&node=TN.b8000

Each URL (link) can be copied in a browser to get to the device diagram easily.
 
Was this helpful?
What can we do to improve the information ?