Review changes with the Audit Trail utility

Only users given administrator privileges to the AF Server can use the Audit Trail utility.

Use the Audit Trail utility to track changes to one or more PI AF objects.

1. Choose from the following actions:

   To ...	Do this ...
   Review changes to PI AF objects in all databases	Click Tools > Audit Trail.
   Review changes to a single PI AFobject	Open the database that contains the object you want to audit. In the navigator, click the object type you want to audit. For example, to audit a table, click Library. In the browser, expand the tree until the object you want to audit is displayed in either the browser tree or listed in the viewer. Right-click the object and click Audit Trail Events.
   Review changes to the UOM database	In the navigator, click Units of Measure. Click File > Audit Trail Events.

2. In the table displayed in the AF Audit Trail window, review changes made to PI AF data. The following columns are displayed:

   Column	Description
   Date	The date and time of the change.
   Action	The type of change ( Insert, Update, or Delete).
   Type	The type of object that changed.
   Database	The PI AF database containing the changed object.
   Path	The hierarchical path to the changed object (when the object is a child of a parent object, the path shows the parent object).
   Name	The name of the changed object.
   User	The user who made the change, in the form of domain\user.

   You can filter the results shown in the AF Audit Trail window by changing the start and end times:

   To ...	Do this ...
   Adjust the time period	Change Start Time and End Time to adjust the time period. You can choose from the following actions: Click to choose or enter a new date and/or time. Click to construct a relative time expression. Click (or press Enter) to display the updated table.
   View changes for a subsequent time period	Click .
   View changes for a previous time period	Click .
   Adjust the number of change rows for current time period	In the Maximum field, enter the number of records you want returned in the results list. Click (or press Enter) to refresh the results in the list. If there are additional records that are not displayed in the results list, the Next button appears active. Click Next to display the next page of records in the query results. Note: You can also display additional records by increasing the value in the Maximum field and then pressing Enter.
   Filter the returned results	Click to select a filter type. Enter text in the Filter field. If necessary, click . The table displays only those rows that contain your filter criteria.

3. Optional. To view details for a specific row, double-click it.

   1. In the AF Audit Trail Details window, review the details of the row you selected. In addition to Path\Name, Indentity and Date, the following information is displayed:

      Column	Description
      Action	Type of change (Insert, Update, or Delete) and the PI AF object sub-object (such as an attribute or attribute value).
      Name	The PI AF sub-object; can be blank.
      Id	The identity of the object referenced in the detail record. The value is either a GUID or an integer. The identity can be useful in situations where an object is renamed, since the underlying identity does not change.
      Property Name	The column name from the SQL table in PI AF SQL Database (PIFD) for the changed sub-object. This name provides a specific reference to the data within the record that has been changed.
      Old Value	The value before the change.
      New Value	The value after the change.

   2. Click Close to return to the AF Audit Trail window.

4. Optional. You can export selected data grid rows or all the rows from the time range (if no rows are selected) in CSV format:

   1. In the Export to File field, enter a name for the export file.

   2. Click to open the Save As window and navigate to a specific directory.

   3. If you want to export the data from Audit Trail Details window for each selected row, select the Detailed check box.

   4. Click Export All or Export Selected, depending on whether you selected specific rows. (A tooltip indicates the number of rows selected.)

      The status bar initially indicates the total number of rows and then appends the time when the export completed. Note that while the export is executing, you can cancel it by clicking Cancel Export. The status bar indicates the time when the export was canceled.

5. To exit the Audit Trail utility, click Close.