How to add a Global Event Viewer to PME 9.0 and Up

How can we help you today?

Issue
The Global Event Viewer option is no longer available under the Edit menu in Vista for PME versions 9.0 and up. There may be a need to create a Vista alarm view on some workstations that have web ports blocked or with no web browser capability.

Product Line
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023

Environment
Vista

Cause
The Global Event Viewer feature has been removed as of PME 9.0, and replaced with the Alarms tab of the Web Applications.

Resolution
It is highly recommended to instead use the Alarms tab of the Web Applications as it provides more features and customizations that will be supported going forward. However, if necessary the Global Event Viewer can be added manually using an Event Log Viewer object.

1. Open Vista and select File > New to create a new diagram
2. Select Options > Show Toolbox if the toolbox is not currently shown
3. Click and drag an Event Log Viewer object onto the diagram

screenshot0

4. Right-Click the Event Log Viewer to edit it
5. Go to Query Server > Custom Query Server > Edit Link...
6. Select the Query Server, there should only be one option

Screenshot1

7. Click OK
8. Go to Query > Edit SQL
9. A Notepad window should open, copy and paste in the following query (also attached below):

SELECT dbo.DateAsUnix(TimestampUTC) AS timestamp, (SELECT DisplayName From Source WITH (NOLOCK) WHERE ID=SourceID) AS node, Priority AS priority, (SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=CauseID) AS cause_ion, (SELECT String From EventString WITH (NOLOCK) WHERE ID=CauseValueID) AS cause_value, (SELECT COALESCE(CAST(QuantityID as NVARCHAR(5)), String) From EventString WITH (NOLOCK) WHERE ID=EffectID) AS effect_ion, (SELECT String From EventString WITH (NOLOCK) WHERE ID=EffectValueID) AS effect_value, dbo.DateAsUnix(AckTimeUTC) AS ack_time, UserName AS user_name, ID AS recordID, NULL AS replacement, Remark AS remark
FROM dbo.EventLog2 WITH (NOLOCK) LEFT JOIN dbo.EventAcknowledgement WITH (NOLOCK) ON EventLogID=ID
WHERE Priority >= '128'
ORDER BY TimestampUTC DESC OPTION (FAST 50)

10. Select File > Save, then close the Notepad window

Screenshot2

11. Click OK to close the settings window for the Event Log Viewer
12. Double-click the Event Log Viewer to open the Global Event Viewer
13. Select File > Save As... and name the diagram "Global Event Viewer"
14. You can now open the Global Event Viewer by going to File > Open and selecting the "Global Event Viewer" diagram, and it will automatically open the configured Event Log Viewer.

Note: If it is preferred to have the Event Log Viewer closed upon opening the diagram (for example if the Event Log Viewer object was added to a network diagram), then close the Event Log Viewer to show the desired screen and select File > Save the diagram.

Screenshot3

Note: The functionality is similar to the original Global Event Viewer:

The window will flash when there are unacknowledged alarms
Clicking on the ALARM value for an event under the Ack Time column will give an option to acknowledge the alarm
Clicking on the Ack Time column header will give an option to acknowledge all alarms
Clicking on a value in any other column will open the corresponding device diagram (if available)

Screenshot4