Description

This is a SQL view for on-prem subscribers that pulls information from the audit logs into a view that can be used for auditing & compliance purposes.

This view can also be used to quickly locate errors (internal or within your own procedures) or, as we use it, to export the auditing information for archiving & compliance purposes on a regular schedule to avoid loss when logs must be truncated because you're hitting the 2 billion record maximum in the scriptlogs table.

Examples of how to use the view for locating errors are included.