Siebel Applications Administration Guide > Audit Trail >

Viewing Audit Trail Records

After you have set up the fields, operations, responsibilities, positions, and employees to be audited, you can read the results of the audit trails in the Audit Trail view and the Audit Trail Items view.

This task is a step in Process of Configuring and Using Audit Trail.

Querying Audit Trail Information

After recording or importing Audit Trail records into the 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 > Audit Trail Items view.
2. Query the list for Audit Trail items of interest.

   Some fields are described in the following table.

   Field	Description
   Base Table	Displays the name of the primary database table where the database change occurred.
   Business Component	Displays the business component for the record where the database change occurred.
   Child Business Component	Displays the child business component for the record where the database change occurred, if any.
   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.
   Date	Displays the timestamp of the change.
   Employee ID	Displays the unique identifier of the user who changed the record.
   Employee Login	Displays the username of the user who changed the record.
   Field	Displays the name of the field where 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.
   New Value	Displays the value in the field after the database change occurred.
   Old Value	Displays the value in the field before the database change occurred.
   Operation	Displays the type of operation that was performed, for example, New Record, Delete, and so on.
   Record ID	Displays the unique identifier of the record that was changed.
   Row ID	Displays the unique identifier of the row in which the change occurred.
   Table	Displays the name of table to which the selected field belongs in the Siebel database.

Querying Export Audit Trail Records

You can set up Export Audit Trail for a business component to monitor the export activities for the business component. You can view the results of export audit in the Export Audit Trail view. See Specifying Business Components and Business Component Fields for Audit for details on setting up export audit trail.

To query export audit trail information:

1. Navigate to the Audit Trail screen > Export Audit Items view.
2. Select the Audit Trail item required.

   Some fields are described in the following table.

   Field	Description
   Business Component	Displays the business component on which the export operation was performed.
   Date	Displays the timestamp of the export activity.
   Employee ID	Displays the unique identifier for the user who initiated the export.
   Employee Login	Displays the username of the user who initiated the export.
   Record Count	Displays the number of records that were exported.
   Records IDs	Displays the unique identifier for each record that was exported.

Querying Read Audit Trail Records

You can use the Read Audit feature to monitor the reading of sensitive information.

To query read audit trail information

1. Navigate to the Audit Trail screen > Read Audit Items view.
2. Select the Audit Trail item required.

   Some fields are described in the following table.

   Field	Description
   Business Component	Displays the business component for the record that was read.
   Date	Displays the timestamp of the read operation.
   Employee ID	Displays the unique identifier of the user who read the record.
   Employee Login	Displays the username of the user who read the record.
   Field Name	Displays the name of the field that was read.
   Field Value	Displays the value that was in the field at the time that the field was read.
   Record ID	Displays the unique identifier of the record that was read.

   NOTE:  To audit record field values, you must select Read Field Value in the Field view of the Administration - Audit Trail screen. For more information, see Specifying Business Components and Business Component Fields for Audit.