How to check events that are being written in the ApexSQL Audit Central for your reports? (4373206)

How to check events that are being written in the ApexSQL Audit Central for your reports?

If there is a suspicion that something is wrong with the SQL auditing reports, what is the simplest way to check if all its events/data is collected the specific query needs to be performed?



 

To check events that are being written in the ApexSQL Audit Central just run the following query in the SSMS and this will ensure the insight into all those events:

SELECT [Id]
      ,[ServerName]
      ,[StartTime]
      ,[RowVersion]
      ,[Duration]
      ,[ApplicationName]
      ,[ClientHostName]
      ,[LoginName]
      ,[DatabaseName]
      ,[DatabaseId]
      ,[Success]
      ,[ObjectId]
      ,[SchemaName]
      ,[ObjectName]
      ,[TransactionId]
      ,[TextData]
      ,[Operation]
      ,[AccessedObjectsList]
      ,[Error]
      ,[EventSource]
      ,[EventTypeId]
      ,[BeforeValue]
      ,[AfterValue]
      ,[ColumnName]
      ,[SensitiveColumnName]
  FROM [ApexSQLCrd].[ApexSQL].[EventView]
 ORDER BY StartTime DESC