Shulou(Shulou.com)06/01 Report--

First, create a new table:

Then use SQL to implement the query data insert into the new table:

Insert into test.dbo.tmp_tj001 (server_principal_name,object_name,maxdate)

Select s1.serverillustralplayname as maxdate from s1.objectplayname as maxdate from

(SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_920000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_520000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_450000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_650000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_980000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_730000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_430000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_670000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U'

Union all

SELECT distinct server_principal_name,object_name,event_time

FROM sys.fn_get_audit_file ('\ 10.0.2.116\ Audit\ Audit_380000.sqlaudit', NULL, NULL)

WHERE database_name = 'HR'and action_id='CR' and class_type='U') S1

Group by s1.server_principal_name,s1.object_name

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.