{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
Search FAQs
Video: How to view System Events in Vista

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>).
Designer QUERYSERVER

2. Open the folder QUERYServer.<Computer Name>
Query Module

3. Drag and drop a new Query module.
ION Modules Selector

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.
Modify Database Connection Properties

5. Change the module name to SystemLog and Output Register if desired.
Query ION Module Setup

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.
Vista Datalog 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.
Data Log Viewer Configuration

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

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.

Schneider Electric Singapore

Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: