Search Audit Records

Security Note: You need the Allow the user to view audit trails security right in the Options user group security rights group for this activity.

Activity Steps

  1. Open the Audit Explorer.
  2. Enter the following search criteria as required.
    • Start Date—Default: Yesterday at 00:00:00. If you clear the Start Date, the search starts from the earliest record in the database.
    • End Date—Default: Today at 23:59:59. If you clear the End Date, the search continues to the latest record in the database.
    • Object Type—Required. Select from all MineMarket object types. Enter text to filter the list.
    • Object IDs—Optional. Separate multiple values with commas or semicolons.
    • Name—Optional. Text searches are case-sensitive with SQL databases with a case-sensitive collation and with all Oracle databases.

      Note: The Object Type and Object IDs are read-only if the Audit Explorer. is opened via the Solution Explorer or Property Window. See View the Audit History for a MineMarket Object. The object ID is a unique identifier and may not match the Alias1 or Alias2 value.

  3. Click Search.

    By default, the audit records are sorted by Change Date in descending order. You can filter the data displayed in this table. See Sort, Filter and Group Data in Tables. Alternatively, you can enter Search Text to search all data fields of the audit records and all metadata (who did what and when). You can enter partial text strings, and the search is case-insensitive.

    New objects start at version 0 and the Version is incremented for each subsequent change. Deleted objects have a version of -1.

    Possible values for the Action are Insert, Update, Delete and Merge.

    In addition to the configured users in the system, there is also a User called the 'SYSTEM USER' that is responsible for audited changes made by the MineMarket Server.

  4. To view related audit records, select the audit record in the Audit Records table.

    For example, if a user changed the status of a despatch order, you could search for the despatch order audit record. The status change displays among the related audit records.

    The most recent related record of each property displays, even if the related record is outside the date range of the search criteria.

    A tooltip on the Property Name displays the object type of the related record. Hover the mouse pointer over the field to display the tooltip.

  5. To change the search criteria to the object type of a related audit record, right-click the audit record in the Related Audit Records table and select Search For This Object Type from the menu.
  6. To view the audit record details, select the audit record in the Audit Records or Related Audit Records table.

    Note: For insertions and deletions, the full object details display. For updates, only the differences between the current and the previous version display.