Querying Audit Trail Information

After recording or importing audit trail records into the Siebel database, you can query audit trail information in the Audit Trail Items view. For example, you can query Audit Trail Items to determine changes made by team members, dates, or operations performed on a business component.

To query audit trail information

1. Navigate to the Audit Trail screen, then the Audit Trail Items view.

2. Query the list for Audit Trail Items of interest.

   Some fields are described in the following table.

   Field	Comments
   Employee Login	Displays the username of the user who changed the record.
   Business Component	Displays the business component for the record where the database change occurred.
   Field	Displays the name of the field where the change occurred.
   Operation	Displays the type of operation that was performed, for example, New Record, Delete, and so on.
   Old Value	Displays the value in the field before the database change occurred.
   New Value	Displays the value in the field after the database change occurred.
   Date	Displays the timestamp of the change.
   Child Business Component	Displays the child business component for the record where the database change occurred, if any.
   Record ID	Displays the unique identifier of the record that was changed.
   Base Table	Displays the name of the primary database table where the database change occurred.
   Child Table Name	Displays the name of the child table for the record where the database change occurred, if any.
   Column	Displays the name of the column in which the change occurred.
   Group ID	Displays the unique identifier of the group to which the user who changed the record belonged.
   Link	Displays the name of the link that describes the relationship between the child business component and the parent business component. This link is configured in Siebel Tools.
   Table	Displays the name of table to which the selected field belongs in the Siebel database.
   Row ID	Displays the unique identifier of the row in which the change occurred.
   Employee ID	Displays the unique identifier of the user who changed the record.