Audit Log

You can access the audit log from the Database menu.

The audit log contains two tabs:

User Sessions

The top section lists all user sessions in the database. Each login creates a session with a recorded login time. When the user logs out, the logout time is added. The IP address for each session is also displayed.

Changes

When you select a user session at the top section of the tab, the lower section shows all related data changes. Each row represents a record inserted, updated or deleted during that session.

The left side of this area contains three columns. Their visibility can be toggled from the Customise toolbar option:

Column

Description

Table Definition

Indicates the table in which the change occurred. This may be:

  • System tables. For example, moving an asset creates a record under Asset Location.

  • User tables, where the name reflects your Asset Information Group, Event or other user-defined structure.

Operation

Shows the type of change:

  • Insert: A new record was added.

  • Update: An existing value was changed.

  • Delete: A record was removed.

Date Changed

Shows the date and time when the operation took place in the database. The list is ordered chronologically by default.

The operation type determines which toolbar options are available and what information appears on the right side of the screen area:

  • Insert and Delete

    The Form toolbar button is available. It allows you to see the name of the user and the values of the inserted or deleted items on the right-side of the screen.

  • Update operation type:

    The following toolbar buttons are available:

    • Original Values - Shows values before the change. A infoblue icon appears next to changed fields; hovering over the icon shows details about the change.

    • Changed Values - Shows values after the change, again with the infoblue icon indicating modified fields.

For all operation types, you can use the Summary toolbar button to display a concise written summary of all changes within the selected record.

Shows details of all failures recorded during a user session, such as login failures. Each entry displays the timestamp, IP address and message associated with the failure.