Reputation: 93
On one of our test servers the view in Settings -> Auditing -> Audit Log Management says there are no deletable audit logs available, even though a select count (*) from AuditBase
in the database returns nearly 90 million records. The user looking at the view has System Administrator privileges. In our other 2 servers (all using the same version of CRM), the view displays records as expected.
What might we do to get the records to show, or alternately to clean up the audit table without using the view?
Upvotes: 0
Views: 651
Reputation: 3935
Strange that the Audit Logs are not appearing in the view inside Dynamics, despite records existing in the database.
It might make sense to open a Microsoft ticket about it.
Or, since your system is on-prem, here's a discussion about manually deleting data from the AuditBase table, which is of course highly unsupported.
Upvotes: 1