Event Log Handling

4.8. Event Log Handling

The Event Log records significant events that occur in the system, for example, user login and logout, objects written to the database and changes made to the database. It is used, when necessary, to review the activities of users in the system.

Icon Contents Description
inset_7.jpg Event Log icon When you double-click the Event Log icon, you see the Find: Events Log Records window.

1_Event_Log_Records_window_new.png

Find Event Logs Records, Properties Tab #

This tab allows you to filter the find so that only certain records are displayed.

Dates From and To: Entering dates here allows the selection of only those records whose date falls within the specified date range.

Activity: Retrieves only those records relating to the specified activity. Valid activities include:

  • Create: A create event occurs when an object is initially written to the database.
  • Update: An update event occurs when an object’s information is updated on the database.
  • Delete: A delete event occurs when an object is deleted from the database.
  • Login: A login event occurs when a user logs into the SICS system.
  • Logout: A logout event occurs when a user logs off the SICS system.
  • Message: A message event occurs when an important system message is logged and the transaction is committed to the database. (The message object’s attributes must indicate that the message should be logged as an event. See the System Messages section.)
  • Find: A find event occurs when a user uses one of the Find functions that are listed in the “Participating Find Functions” (see menu choice “Logging control”) - provided logging is enabled for Find functions.
  • Database Patch: A Database Patch event will occur during execution of the “Update Database Definition” function in System Administration. Each event represents one or more modifications on the table on the database underlying SICS done by a database patch.
  • The prefix of the “Target Identifier” will show the type of patch (“re” for common patches, “pc” for P&C patches, and “lf” for Life patches). Each database patch consists of one more parts. The execution of each part is written to the event log using its database patch number and part number.
  • Update Write Lock: An Update Write Lock event will occur when a database object is committed to the database. The referred object will be the top-level object being modified. Target Class: Retrieves event records for system objects of the specified target class.

These options control the order in which records are presented.

  • Login Options Menu
  • Event Log Control, opens the Event Log Administration window.
  • Event Log Maintenance, opens the Event Log Maintenance window.
  • System Messages, opens the System Messages window.

Event Log Administration #

You can open the Event Log Administration window by clicking the Logging Options menu and selecting Event Log Control. This window lets you set options affecting the operation of the event log. It is initially displayed as a viewer. Clicking the Edit button opens the window in edit mode where options can be changed.

2_Event_Log_Administration_new.png

Enable Event Logging: Activates or deactivates the entire event logging facility. When deactivated, the user exit is not called and no records are written to the database.

Miscellaneous options #

Call User Exit: Controls whether the user exit should be called each time an event is generated.

Log System Messages: Controls whether directed messages should be logged. A directed message is a system-defined event like login, logout.

Database Update Logging #

Log Database Update Transactions: Controls whether events are generated whenever database activity on certain classes in the system occurs.

Benchmark Database Update Transactions: When selected, loads the time the system uses to perform the logging transaction. The time is recorded in seconds, and appears in the Benchmark column in the Find Event Log Records window.

Available Classes/Participating Classes: Allows the selection of classes that participate in event logging. The available classes are system-defined and cannot be changed by the user.

Find Query Logging #

Log and Benchmark Find Queries: When this is selected, the system logs each time a user performs one of the selected functions and how long it took. The purpose of this is to monitor response time.

Note! Log and Benchmark Find Queries is not intended to be turned on all the time. It is used in instances when you need to monitor a period of time to gain specific information.

Read Query Logging #

Log and Benchmark Read Queries: When this is selected, the system logs each time a user access an Insurable Object. The purpose of this is to monitor who and when a insurable object was accessed.

Delete Event Log Records #

This window lets you delete all or some of the event log records from the database.