Search table audit events in the Universal Audit

1. Access the Universal Audit associated with a CCLAS 6 instance.
2. Select the Table Search tab.

3. Select a table in the connected CCLAS 6 instance.

4. Optionally select one or more fields in Field Changed to only search for audit records where the denoted fields were changed, and to only show the denoted fields in the results grid.

5. To configure the first group which is the parent group:
   1. Select the parent group's operator to denote how the parent group's rules and child groups are conditioned.
   2. To configure parent group rules:

      1. Click +Rule to add a rule to the parent group, then select the job field, operator and value. Remember that the first group's rules are overarching rules.

         Note: It can be misleading if rules are added to the parent group and they appear at the end. Although it looks like they belong to the last group, they are still parent group rules.

      2. Click on a rule to create a clone of the rule.

      3. Click on a rule to delete the rule.

6. Click +Group to add a child group.
7. To configure a child group:
   1. Select the child group's operator to denote how the child group's rules are conditioned.
   2. To configure child group rules:
      1. Click +Rule to add a rule to the child group, then select the job field, operator and value.
      2. Click on a rule to create a clone of the rule.
      3. Click on a rule to delete the rule.
   3. Click on a group header to create a clone of the group.
   4. Click on a group header to delete the group.

8. Click SEARCH to apply the search criteria and return audit events for the table from the audit log to the grid. Only the fields entered in Field Changed are displayed.

   Note: If an event date range is not defined, then the audit events from the last three months are returned, by default.

9. Click or to expand or collapse an audit record to show or hide the fields.

10. Click Download Current Page to save the contents of the search results grid to an Excel™ spreadsheet named JobAudit.xlsx in your Downloads folder.

11. Click or to sort the column data in descending or ascending order, or click to return the sorting to natural order as in the result set.

12. Click and:

    1. Select Reset to reset the column display.

    2. Select or clear a column to make it locked or unlocked.

    3. For any column, select to pin the column to the left, to pin the column to the right, or to unpin the column and display the column in the denoted order.

    4. For any column, select the (dots next to the field) and drag-and-drop the column to the desired position.

    Settings are preserved only for the current login session.

13. Click and select Larger, Middle, Compact or Smaller to adjust the row height of the search results grid. Row height is reset to Compact for a new login session.

14. Click RESET to reset the search criteria, apply the default search, and return audit events for the table from the audit log to the grid.