Share via


ACS Database Dashboard Report

 

Here’s a little report that I put together to get a look at what is going on in the ACS Database.  The report will show:

  • Number of Events in the DB
  • Number of days represented in the DB
  • Max Events Per Day
  • Average Events Per Day
  • Partition Count
  • DB Size
  • DB Free Space
  • Top 10 Events
  • Event Count By Day

 

Here’s a screenshot of the report….no parameters, just run it (it may take a while to run on a large ACS database)

image

 

I’ve also included another report that will show the general ACS configuration settings, details of each partition, and a list of forwarders…not super useful, but could help in troubleshooting/verifying database grooming.

image

ACS Database Dashboard.zip

Comments

  • Anonymous
    January 01, 2003
    Can you log on to the report server and run the report?  That should give you a more detailed error message....otherwise you'll need to look at the report server logs to see the error.

  • Anonymous
    January 01, 2003
    why don’t you also use my partitions query with the SIZE or partitions www.muscetta.com/.../audit-collection-services-database-partitions-size-report ?

  • Anonymous
    March 05, 2012
    The comment has been removed