Skip to content

Instantly share code, notes, and snippets.

@DataSic

DataSic/dm_audit_actions.sql

Created June 3, 2018 14:37
Show Gist options
  • Save DataSic/dd2bdaa2577a169b7858b7e3e9d0c4ec to your computer and use it in GitHub Desktop.
Save DataSic/dd2bdaa2577a169b7858b7e3e9d0c4ec to your computer and use it in GitHub Desktop.
Download ZIP
dm_audit_actions
Raw
dm_audit_actions.sql
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