谢谢老土，我做了这个audit,但是

谢谢老土，我做了这个Audit, 但是Audit 结果放在application log里面，而且所有信息是在一个message里， 怎样能输出这些信息，生成我需要的报表。

 

CREATE SERVER AUDIT [My-SQLAgent Audit]

TO APPLICATION_LOG

WITH

(     QUEUE_DELAY = 1000

      ,ON_FAILURE = CONTINUE

      ,AUDIT_GUID = 'af42e922-6b3b-4b4e-a633-4d314addcefe'

)

GO

 

USE[msdb]

 

GO

 

alter DATABASE AUDIT SPECIFICATION [my sample]

FOR SERVER AUDIT [My-SQLAgent Audit]

ADD (UPDATE ON OBJECT::[dbo].[sp_update_job] BY [dbo]),

ADD (UPDATE ON OBJECT::[dbo].[sp_update_job] BY [SQLAgentUserRole]),

ADD (EXECUTE ON OBJECT::[dbo].[sp_delete_job] BY [dbo]),

ADD (EXECUTE ON OBJECT::[dbo].[sp_delete_job] BY [SQLAgentUserRole]),

ADD (EXECUTE ON OBJECT::[dbo].[sp_add_job] BY [dbo]), 

ADD (EXECUTE ON OBJECT::[dbo].[sp_add_job] BY [SQLAgentUserRole])

 

 

 

所有跟帖： 

• query sys.dm_audit_actions for every audit action that can be r -美国老土- ♂ (1112 bytes) () 08/08/2011 postreply 22:46:25