Skip to content

Instantly share code, notes, and snippets.

@DataSic
Created June 3, 2018 14:37
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save DataSic/dd2bdaa2577a169b7858b7e3e9d0c4ec to your computer and use it in GitHub Desktop.
dm_audit_actions
SELECT *
FROM sys.dm_audit_actions
WHERE containing_group_name IN ('SUCCESSFUL_DATABASE_AUTHENTICATION_GROUP',
'FAILED_DATABASE_AUTHENTICATION_GROUP',
'BATCH_COMPLETED_GROUP')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment