Implementing Fastpath’s Audit Trail: Select tables to audit

FastpathThis post is part of the series on Implementing Fastpath's Audit Trail and is part of the parent Implementing Fastpath's Assure Suite series.

Audit Trails tracks changes by creating triggers on SQL Server. When you create the triggers you do so by selecting a table, choosing the events to track and which fields to be audited:

Audit Trails

You can separately choose to track inserts, updates and deletes by marking the relevant boxes, although in most cases you would want to track all three.

Next you can select any of the fields on the table for auditing; I’d recommend against tracking everything as this can make the audit data very large and if there are fields you don’t populate or aren’t important, then there is no point auditing them.

Likewise, you can audit as many tables as you want, but I’d recommend against auditing all tables as this can have an impact on performance. I’d also recommend against auditing transaction tables due to the volume of data which would pass through them.

In the next post, I’ll show how to apply the triggers for the selected tables and fields.

Implementing Fastpath's Audit Trail

Implementing Fastpath's Assure Suite

Implementing Fastpath’s Assure Suite
Implementing Fastpath's Assure Suite: Who are Fastpath?
Implementing Fastpath's Assure Suite: What is Assure Suite?
Implementing Fastpath's Assure Suite: Pre-installation steps
Implementing Fastpath's Assure Suite: Sign Into Support Portal
Implementing Fastpath's Assure Suite: Download Assure Suite
Implementing Fastpath's Audit Trail: Configuration
Implementing Fastpath's Identity Manager: Configure AD Settings
Implementing Fastpath's Assure Suite: Run minimum permissions script
Implementing Fastpath's Assure Suite: Install the Hybrid Connection Manager
Implementing Fastpath's Assure Suite: Configure Hybrid Connection Manager
Implementing Fastpath's Assure Suite: Setup cloud connection
Implementing Fastpath's Assure Suite: Schedule security import
Implementing Fastpath's Assure Suite: Schedule security import
Implementing Fastpath's Assure Suite: Schedule Audit Trails data collection
Implementing Fastpath's Audit Trail: Grant AT Access
Implementing Fastpath's Audit Trail: Select company to audit
Implementing Fastpath's Audit Trail: Select tables to audit
Implementing Fastpath's Audit Trail: Create Triggers
Implementing Fastpath's Audit Trail: Apply templates
Implementing Fastpath's Audit Trail: Apply triggers to other companies
Implementing Fastpath's Audit Trail: Transfer between systems
Implementing Fastpath's Assure Suite: Create new portal user
Implementing Fastpath's Assure Suite: Assign Permissions
Implementing Fastpath's Audit Trail: Ad hoc data collect
Implementing Fastpath's Audit Trail: Review data changes
Implementing Fastpath's Audit Trail: View reports