Issue
User wants to display specific system log event information in Vista

Product Line

Power Monitoring Expert 7.2.x

Power Monitoring Expert 8.x

Power Monitoring Expert 9.0

Power Monitoring Expert 2020

Power Monitoring Expert 2021

Power Monitoring Expert 2022

Power Monitoring Expert 2023

Power Monitoring Expert 2024

Environment
Events in Vista

Cause
Global Event log viewer in Vista does not display information from the SystemLog Database

Resolution
1. Launch Designer and open the Query Server (QUERYSERVER.<Computer Name>).


2. Open the folder QUERYServer.<Computer Name>


3. Drag and drop a new Query module.


4. Right click on the module to open the Module Setup and click Modify to edit the connection string. Change the Initial Catalog to ION_SystemLog.


5. Change the module name to SystemLog and Output Register if desired.


6. Click Ok to close the Module Setup. Save changes then close the node window and Designer.

7. Open Vista and open new diagram or edit an existing diagram.

8. Drag and drop a new Data Log Viewer.


9. Right click on the icon to open the Data Log Viewer Configuration.

10. Under the Query Server tab, select Custom Query Server and click the 'Edit Link" button.


11. Select the new Query Module created and click OK.


12. Under the Query tab, click the "Edit SQL..." button

13. In the notepad add the desired query to retrieve information from the system log.
For Example:
Select Timestamp as TimestampUTC, Description as Description
From Event
Where Description like '%user%'
Order By Timestamp DESC OPTION (FAST 50)

14. Save the query and click "Ok "close the Data Log Viewer Configuration.

15. Open the Datalog viewer and confirm the desired information is present.

Note: the timestamp displayed will be in UTC time zone.

Released for:Schneider Electric India