We have an AF Server with multiple AF Databases. One database is the single source of true. It is possible to enable Audit Trail just for this database instead all databases in the AF Server?
The AF Audit trail relies on SQL Server Change Data Capture feature which is enabled on a SQL Database. Since all AF Databases are stored in a single SQL Database, it cannot be configured to only work for a single AF Database.
David is correct, and that causes quite some issues as some applications (quite notably PI Integrator!) use the Configuration AFdatabase for an operational repository causing huge amounts of audit trails which you then need to configure to purge again.
Upvote here to get this changed:
Configurable pruning of the Audit Trail – User Feedback for OSIsoft Products and Services
and for the integrator specifically:
AF Audit Trail is incompatible with the Integrator for BA – User Feedback for OSIsoft Products and Services
Retrieving data ...