Applies to: All versions of Centrify DirectAudit
Question:
Auditing is enabled and there are no issues with dainfo --diag output, however no audited sessions are seen with Audit Analyzer even after waiting for several hours.
Is there any reason for this?
Answer:
Audited sessions may not make it to the Audit Analyzer if the SQL Express Database becomes full.
The only way to resolve this is:
a) Create a new SQL database and detach the old Database using DirectAudit Administrator Console. The Collector needs to be stopped momentarily. (Recommended method)
b) Using SQL Management studio, go to Centrify's Audit database and clear these entries.The caveat here is the audited data is completely gone and irrecoverable.
- Drill down to Centrify's audited DB table and run the queries:
DELETE FROM session WHERE state=3
DBCC SHRINKDATABASE(0)
(The number 3 in the first command means “Completed Sessions”)