Audit Log

The Audit Log helps you to keep track of changes made to information in a project database. Using the log, you can see who has made changes, what has changed, and when it changed. This is useful for reviewing activity, ensuring accountability, and meeting compliance needs.

Open the Audit Log

To open the Audit Log:

1. In the Security Manager window, select Tools and then Audit Log .

   

   The AVEVA SQL Log Utility window is then displayed.

   

2. In the Login window, enter the name of the SQL server.

3. From the Authentication list, choose how you want to log in:

   • Windows Authentication: Uses your current Windows account to authenticate you.

   • SQL Authentication: Enter your username and password.

4. Select Connect.

Set up and View Audit Log

Assuming you have the required permissions, the Log Information window is now displayed.

Set up Audit Tracking

Use the Preferences window to set up what changes to track and to start and stop tracking:

5. Select Preferences to display the Preferences window.

   

6. From the Select Database and Select Table lists choose the database and table you want to monitor.

7. Select Load Columns to load the list of columns (types of information) from the selected database and table.

8. Select the check boxes next to the Column Names you want to track.

9. Select Save Choices to save your choices for the next time you use the Audit Manager.

10. Select Enable Auditing to start tracking changes as you have defined.

    A new audit table with the prefix “Audit_” followed by the table name is created in database to store the logging data. For example, if the table name you selected is ‘ProjectDirectives’, when auditing is enabled, a new table called "Audit_ProjectDirectives" is created.

11. To stop tracking, select Disable Auditing. Tracking then stops and the audit tables are deleted.

View Changes

Use the Log Information window to view database changes:

12. Select the project database you want to review from the Select Project list.

13. From the Select Audit Table, choose an audit table.

    The window then displays the list of changes, including:

    • What was changed (Description).

    • When it was changed (Timestamp).

    • Who made the change (User Name).

    • The old and new values (Old Value and New Value).

    

14. Select Clear Log to delete all records from the selected audit table (you will be asked to confirm this).

15. Select Refresh to update the window with the latest database changes.

16. Select Export to save the table to an Excel file for sharing or record-keeping.