Audit Collection Services: number of events per day

If you ever wanted to know how many events per day are collected and stored within the Audit Collection Services database of your Operations Manager infrastructure, you can run the following SQL query against the OperationsManagerAC database:

SELECT
 CASE
 WHEN(GROUPING(CONVERT(VARCHAR(20), CollectionTime, 102)) = 1) THEN 'All Days' 
 ELSE CONVERT(VARCHAR(20), CollectionTime, 102)
 END AS DayAdded, 
 COUNT(*) AS EventsPerDay 
FROM AdtServer.dvAll5
GROUP BY CONVERT(VARCHAR(20), CollectionTime, 102) WITH ROLLUP 
ORDER BY DayAdded DESC

Advertisements
Audit Collection Services: number of events per day

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s