SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
We currently have no auditing settings turned on in our SharePoint Farm.
In future the intention is that some auditing will be turned on. For example, recording when permissions are edited.
A confirmation has been requested by parts of our business to confirm that no auditing information can be retrieved directly from SQL even with auditing turned off for a site.
Is this correct?
SharePoint databases should never be accessed directly for read or write operations per KB841057. That said, if you need to look at it, you can run:
SELECT * FROM AuditData (NoLock)
No audit logging will be produced with auditing disabled, but audit data will be preserved (given you didn't turn on trimming) if auditing was enabled and then subsequently disabled.