Event Log

Help Contents

Introduction

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

Example of the event log displayed in the Configuration Tool:

The event log displayed in the Configuration Tool.

To show the above Event Log in the Configuration Tool:

Event Types

The Event Log stores three event types:

Event TypeDescription
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.