Siebel Applications Administration Guide > Siebel 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 Siebel Audit Trail.

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.

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. Export activities include selecting Print or Print Preview in the list that appears when you click the cogwheel icon in a view to print a record in that view. You can view the results of export audit in the Export Audit Trail view. For details on setting up Export Audit Trail, see Specifying Business Components and Business Component Fields for Audit.

To query Export Audit Trail information

  1. Navigate to the Audit Trail screen, then the Export Audit Items view.
  2. Select the Audit Trail Item required.

    Some fields are described in the following table.

    Field
    Comments

    Employee Login

    Displays the username of the user who initiated the export.

    Business Component

    Displays the business component on which the export operation was performed.

    Record Count

    Displays the number of records that were exported.

    Date

    Displays the timestamp of the export activity.

    Record IDs

    Displays the unique identifier for each record that was exported.

    Employee ID

    Displays the unique identifier for the user who initiated the export.

Querying Read Audit Trail Records

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

To query Read Audit Trail information

  1. Navigate to the Audit Trail screen, then the Read Audit Items view.
  2. Select the Audit Trail Item required.

    Some fields are described in the following table.

    Field
    Comments

    Employee Login

    Displays the username of the user who read the record.

    Business Component

    Displays the business component for the record that was read.

    Record ID

    Displays the unique identifier of 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.

    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.

    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.

Siebel Applications Administration Guide Copyright © 2018, Oracle and/or its affiliates. All rights reserved. Legal Notices.