Use PI AF Audit Trail
- Last UpdatedSep 29, 2025
- 1 minute read
- PI System
- PI Server 2018
- PI Server
You can use PI AF Audit Trail in a SQL Server availability group.
-
Enable Audit Trail on the Primary/Principal machine.
-
Force a failover to cause a secondary machine to become the new Primary/Principal machine.
-
Enable Audit Trail on that secondary machine, now the new Primary/Principal machine.
-
Run the following stored procedure on the SQL Server for the new Primary/Principal machine: EXEC dbo.usp_audit_verify_monitor_job_exists N'PIFD';
The command will create the OSIsoft Monitor CDC (PIFD) SQL job.
-
Repeat for each secondary machine.
-
Test Audit Trail for each secondary machine by modifying an AF object using PI System Explorer and viewing the audit data.