TraceID to Audit Group Map

28 06 2014

I will update this and make it pretty when I get more time but here is the information for those who need or want it regarding the Trace ID’s and their correlation to SQL Auditing groups

 

Trace ID Audit Equivelant SQL Auditing Group
109 Audit Add DB User Event DATABASE_PRINCIPAL_CHANGE_GROUP
108 Audit Add Login to Server Role Event SERVER_ROLE_MEMBER_CHANGE_GROUP
110 Audit Add Member to DB Role Event DATABASE_ROLE_MEMBER_CHANGE_GROUP
111 Audit Add Role Event DATABASE_PRINCIPAL_CHANGE_GROUP
104 Audit Addlogin Event SERVER_PRINCIPAL_CHANGE_GROUP
112 Audit App Role Change Password Event APPLICATION_ROLE_CHANGE_PASSWORD_GROUP
115 Audit Backup/Restore Event BACKUP_RESTORE_GROUP
117 Audit Change Audit Event AUDIT_CHANGE_GROUP
152 Audit Change Database Owner DATABASE_OWNERSHIP_CHANGE_GROUP
128 Audit Database Management Event DATABASE_CHANGE_GROUP
172 Audit Database Object GDR Event DATABASE_OBJECT_PERMISSION_CHANGE_GROUP
129 Audit Database Object Management Event DATABASE_OBJECT_CHANGE_GROUP
135 Audit Database Object Take Ownership Event DATABASE_OBJECT_OWNERSHIP_CHANGE_GROUP
178 Audit Database Operation Event DATABASE_OPERATION_GROUP
133 Audit Database Principal Impersonation Event DATABASE_PRINCIPAL_IMPERSONATION_GROUP
130 Audit Database Principal Management Event DATABASE_PRINCIPAL_CHANGE_GROUP
102 Audit Database Scope GDR Event DATABASE_PERMISSION_CHANGE_GROUP
116 Audit DBCC Event DBCC_GROUP
14 Audit Login SUCCESSFUL_LOGIN_GROUP
107 Audit Login Change Password Event LOGIN_CHANGE_PASSWORD_GROUP
106 Audit Login Change Property Event SERVER_PRINCIPAL_CHANGE_GROUP
20 Audit Login Failed FAILED_LOGIN_GROUP
105 Audit Login GDR Event SERVER_PRINCIPAL_CHANGE_GROUP
15 Audit Logout LOGOUT_GROUP
118 Audit Object Derived Permission Event SCHEMA_OBJECT_CHANGE_GROUP
103 Audit Schema Object GDR Event SCHEMA_OBJECT_PERMISSION_CHANGE_GROUP
131 Audit Schema Object Management Event SCHEMA_OBJECT_CHANGE_GROUP
153 Audit Schema Object Take Ownership Event SCHEMA_OBJECT_OWNERSHIP_CHANGE_GROUP
175 Audit Server Alter Trace Event T RACE_CHANGE_GROUP
171 Audit Server Object GDR Event SERVER_OBJECT_PERMISSION_CHANGE_GROUP
176 Audit Server Object Management Event SERVER_OBJECT_CHANGE_GROUP
134 Audit Server Object Take Ownership Event SERVER_OBJECT_OWNERSHIP_CHANGE_GROUP
173 Audit Server Operation Event SERVER_OPERATION_GROUP
132 Audit Server Principal Impersonation Event SERVER_PRINCIPAL_IMPERSONATION_GROUP
177 Audit Server Principal Management Event SERVER_PRINCIPAL_CHANGE_GROUP
170 Audit Server Scope GDR Event SERVER_PERMISSION_CHANGE_GROUP
18 Audit Server Starts And Stops SERVER_STATE_CHANGE_GROUP
113 Audit Statement Permission Event SCHEMA_OBJECT_CHANGE_GROUP

 

Advertisements

Actions

Information

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: