How do I setup the Audit Trail in MARS?

An audit trail is a chronological record of changes that have been made to a database or file. MARS can be configured to create an audit trail that will be stored in a given database. This is how to set it up.

Options - Audit Trail

  • Go to Options.
MS Access: MARS Home Menu.
  • Select Audit Trail.
MS Access: Audit Trail in Options in MARS.

An audit trail is a chronological record of changes that have been made to a database or file. MARS can be configured to create an audit trail that will be stored in a given database.

Audit information is not stored in MARS and you must create and designate an external ODBC compliant database for storage.

The audit trail will display which users have executed, refreshed, or edited schedules.

This audit trail will show common activities, such as which user executed a given schedule, what the user did, the schedule that was manipulated, and the type of schedule.

Enabling the Audit Trail

To allow MARS to create an audit trail, perform the following:

  • On the Audit Trail tab of the Options window, check the box next to Enable Audit Trail. This will enable the Database Setup fields to be modified.
  • Enter the database name and applicable credentials into the DSN Name, UserID, and Password fields. Then, click Connect.
MS Access: Audit Trail in Options in MARS.
  • If successful, a pop-up will appear:Database connection established. Click OK
MS Access: Database connection established pop-up in MARS.
  • Click Apply then at the bottom of the Options window to save these settings.