×

Event Log

 
In this section, you will learn about the Event Log Detail View.   Based on the selected asset, this view shows all the captured event entries.  The event log is an essential component for data integrity and monitoring activities which could impact the records in the database.  It will show each user's activity, such as the creation, modification, and deletion of records, as well as who, when and why the record was modified or deleted, error messages and user logins.  All captured records can be viewed from the Event Log.
 

 
View Event Log Detail View
1. Click on the plus icon    to expand the selected row.
 
Event Log
 
1

Event Log Detail View

 
1. Event Log Detail View
 
The Event Log Detail View shows data in a tabular grid view, similar to Excel.  You can search for keywords using the find panel, edit cells, resize columns, filter and group columns and customise the layout to suit.
 
Column Name
Data Type
Name
Description
 
Row indicator
Indicates which row is focused
 
Close
Closes the detail view and reverts back to the main view
ID
bigint
ID
The unique event log record number
USERNAME
bigint
User Name
Drop-down menu based on the users
EVENT
bigint
Event
The type of captured event; New, Edit, Log, Delete, Checked in and Checked Out
EVENTMESSAGE
varchar(4000)
Event Message
The complete captured event message
STACKTRACE
varchar(50)
Stack Trace
Additional information used for debugging
DATECREATED
varchar(4000)
Date Created
The date and time the record was created in the database
ASSET
varchar(4000)
Asset Number
The unique asset ID number
FORM
varchar(4000)
Form
The name of the form where the event was captured
DATABASENAME
date
Database Name
The name of the database updated by the capture
JOBNUMBER
varchar(4000)
Job Number
The unique work order number used to identify a particular task or a job.  Used in the Board, Calendar, Certificates, Event Log, Overview, Service History, Messages and Shipping.