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?

  • 2
    If you are on SharePoint Online, you cannot query the database directly, as you will not have access to it.
    – wjervis
    Feb 15, 2016 at 17:33

1 Answer 1


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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.