Events and Actions count check

Last updated
Save as PDF

SELECT
   (select count(*) from CMO.dbo.Audit) AS [CMO DB Events], -- Replace 'CMO' with CMO DB name
   (select count(*) from CMO_Replication.dbo.Audit) AS [Replication DB Events], -- Replace 'CMO_Replication' with Replication DB name
   (select count(*) from CMO__Staging.dbo.Event) AS [Staging DB Events], -- Replace 'CMO_Staging' with Staging DB name
   (select count(*) from CMO_DW.dbo.DimEvent) AS [DWH DB Events] -- Replace 'CMO_DWH' with Data Warehouse DB name

SELECT
   (select count(*) from CMO.dbo.Action) AS [CMO DB Actions], -- Replace 'CMO' with CMO DB name
   (select count(*) from CMO_Replication.dbo.Action) [Replication DB Actions], -- Replace 'CMO_Replication' with Replication DB name
   (select count(*) from CMO_Staging.dbo.Action) AS [Staging DB Actions], -- Replace 'CMO_Staging' with Staging DB name
   (select count(*) from CMO_DW.dbo.DimAction) AS [DWH DB Actions] -- Replace 'CMO_DWH' with Data Warehouse DB name

Example given below -