Generating an audit report

  1. On the sidebar, select Auditing > Audit Report.
  2. On the Search Profile tab, specify this information:
    Entity
    Specify an entity name on which to conduct the audit. You can also click the search icon to select an existing entity. If you leave this field blank, then all entities are covered in the report.
    Action
    Specify an action to only include created, updated, deleted, or all reports based on the action in the report.
    Note: If an update process is run through the batch system, the node (workstation) is not added to the audit record even if it is available. The node is not included in the report because the machine used to request and run the batch process is not the same.
    Date Range
    Specify a valid date range using a valid format or click the calendar icon to select the date range. For example, specify 1/1/98, 010198, 01-Jan-1998, or 01/01/1998 in these fields. If no dates are specified, then all dates are included. You can also specify the user ID for the selected entity.
    Detail for Foreign Keys
    Specify the amount of detail to be printed in the report. For example, select the 9 fields option to display 9 fields from the foreign entity after a foreign key.
    Submission options
    Specify or provide information for these options:
    • Description
    • Run type, date/time
    • Job queue details
    • Printer details
    E-mail Report
    Select this check box to display the User E-mail Recipients and External E-mail Recipients grids. You can use these grids to send an email of the report to the specified recipients.
  3. To specify a query, click the Query tab.
    To be included in the reporting process, the query must contain one or more entities. If you specify the search profile and query details, then the search profile details are overridden.
  4. Specify this information:
    Dynamic Query
    Specify a record to be processed or click the search icon to select an existing record. When the same Dynamic Query job is run multiple times, a different set of records is processed.
    Note: Specifying a value in this field disables the Query Result field and vice versa.
    Query Result
    Specify a record to be processed or click the search icon to select an existing record. When the same Query Result job is run multiple times, the same set of records are processed.
    Retain Query Result
    Select this check box to retain the result stored in the database after the job is completed.
  5. Click Submit.