Event Log

Introduction

The Event Log is an audit of significant events in the Fernhill SCADA Server. Significant events stored in the Event Log include:

When users login or log out.
Configuration changes made by users.
Actions by operators.
Changes of state of equipment.
When alarms are set, cleared or acknowledged.

Example of the event log displayed in the Configuration Tool:

To show the above Event Log in the Configuration Tool:

In the Tag Window, right-click the database root tag.
Select Show Events followed by All.

Event Types

The Event Log stores three event types:

Event Type	Description
Simple	Indicates a change of state of equipment, for example: Pump Start, Pump Stop.
Tracking	Records the action of a user. For example: A user login, or a write command to equipment.
Condition	Records the state of alarms. When the alarm is set, cleared or acknowledged.

SQL Query to Display the Event Log

Use this SQL command to display the event log:

SELECT
	Severity,EventTime,Message,EventType,UserName
FROM
	AlarmEvent.EventLog
WHERE
	EventTime >= Current_Timestamp - Interval '1' Day
ORDER BY
	EventTime Desc, FileOffset Desc
FETCH FIRST 250 ROWS ONLY

Further Information

Fernhill SCADA Concepts

To learn about other Fernhill SCADA Concepts.

Configuration Tool

To learn about the tool to configure Fernhill SCADA.

Drivers

To learn about the different drivers available in Fernhill SCADA.

Fernhill SCADA Server

To learn about the SCADA Server.

Data Access

To learn about integrating data into third party applications.

Glossary

For the meaning of terms used in Fernhill SCADA.