Hi Anoop,
To view Audit Logs , goto Object Explorer -> Security - > Audits - > right-click on your Audit - > View Audit Logs
SELECT SA.audit_id AuditId,
SA.name AuditName,
SA.create_date CreatedDate,
SAS.status_time LastModifiedDate,
SAS.status_desc CurrentAuditStatus,
SP.name ServerPrincipalName
FROM sys.dm_server_audit_status SAS
JOIN sys.server_audits SA ON SA.audit_id = SAS.audit_id
JOIN sys.server_principals SP ON SP.principal_id = SA.principal_id
--SQL Server Audit related catalog views
SELECT * FROM sys.database_audit_specifications
SELECT * FROM sys.database_audit_specification_details
SELECT * FROM sys.server_audit_specifications
SELECT * FROM sys.server_audit_specification_details
SELECT * FROM sys.server_file_audits
SELECT * FROM sys.dm_server_audit_status
SELECT * FROM sys.server_audits
Thanks & Regards, sathya
