How to add a Global Event Viewer to PME 9.0 and Up
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
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
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
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: 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)
게시 대상: 슈나이더 일렉트릭 Korea
도움이 필요하신가요?
제품 선택기
애플리케이션에 적합한 제품과 액세서리를 빠르고 쉽게 찾을 수 있습니다.
견적 받기
영업 관련하여 온라인으로 문의하시면 전문가가 연락드립니다.
구매처
해당 지역의 가장 가까운 슈나이더 일렉트릭 대리점을 쉽게 찾을 수 있습니다.
지원 센터
한 곳에서 모든 요구 사항에 대한 지원 리소스를 찾아보십시오.