MBLogic
for an open world in automation
Event Query
Date:
| Time | Event |
|---|
Alarm Query
Date:
| Time | Time OK | Alarm | Client | Count |
|---|
Help
Overview
The event and alarm history query system allows the event and alarm history database to be queried for historical data.
Event Query
The event database can be queried for events by date, by event name, or by a combination of the two. Select the query method you wish to use by selecting the appropriate check box.
Querying Events by Date
To query events by date, enter the desired date range in the date form. The resulting query will fetch events which occured between (and including) those two dates. Pressing the "reset" button will reset the date range to the default values.
Querying Events by Event Name
To query events by event name, select the desire events from the drop down selection widget. Each time you select an event, it will be added to the query and you will see it listed below the selection widget. To clear the current selection, press the "reset" button.
When you select multiple events, the request is "OR"ed together. That is, the query match record which contain any of the events requested.
Querying by Both Date and Event Name
You can query by a combination of both date and event name by selecting both options at once. This will select records which are both within the requested date range and which contain the requested events.
Starting the Query
Once you have specified the search criteria, press the "Get Events" button. This will send the request to the system and display the results when they are returned. The results will be displayed in the table beneath the "Get Events" button. The results will show the date at which the event occured, and the name of the event.
Alarm History Query
The alarm history database can be queried for events by date, by alarm name, by count, or by a combination of any two or three these. Select the query method you wish to use by selecting the appropriate check box.
Querying Alarm History by Date
To query alarm history by date, enter the desired date range in the date form. The resulting query will fetch alarms which occured between (and including) those two dates. Pressing the "reset" button will reset the date range to the default values.
Querying Alarm History by Alarm Name
To query alarm history by alarm name, select the desire alarms from the drop down selection widget. Each time you select an alarm, it will be added to the query and you will see it listed below the selection widget. To clear the current selection, press the "reset" button.
When you select multiple alarms, the request is "OR"ed together. That is, the query match record which contain any of the alarms requested.
Querying Alarm History by Count
To query alarm history by count (the number of times the alarm occurred before being sent to the history), enter the desired count range in the count form. The resulting query will fetch alarms which occured between (and including) those two count ranges.
Querying by Multiple Criteria
You can query by any combination of date, alarm name, and count by selecting multiple options at once. This will select records which meet all the selected criteria. Criteria which are not selected will not factor in the search.
Starting the Query
Once you have specified the search criteria, press the "Get Alarms" button. This will send the request to the system and display the results when they are returned. The results will be displayed in the table beneath the "Get Alarms" button. The results will show the following:
- The date at which the alarm originally occurred.
- The date at which the alarm became "ok".
- The name of the alarm.
- The name of the client which acknowldged the alarm.
- The number of times the alarm occurred before being sent to history.
Display Limits
There is a fixed limit to the number of rows (a maximum of 100) which will be displayed by the history web client to avoid overloading the web page. This is intended to prevent errors in queries from generating massive responses. This does not however limit the number of records which can actually be requested from the server, just the number which are actually displayed.