Jimmy Harper's Operations Manager Blog

Posts in this blog are provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified in the Terms of Use

ACS “Event Count” reports

ACS “Event Count” reports

  • Comments 4
  • Likes

Here are a couple of ACS reports to show the event count by User, Forwarder, and Event ID.  Just import the .rdl files into a folder in SQL Server Reporting Services.

 

The first report “Event Count Overview” shows the top 10 Events, Forwarders, and User Names for the specified date range:

image

 

Click on any of the bars in the chart or the chart titles to launch the “Event Count Details” report.  This report shows more detail about the item that you clicked on.  For example, if you click on the bar for a specific event Id in the “Top 10 Events” section, it will show the top 10 User Names and Forwarders for this event:

image

 

If you click on the bar for a specific Forwarder in the “Top 10 Forwarders” section, it will show the top 10 User Names and Events IDs for this forwarder:

 

image

 

If you click on one of the chart titles it will show details for all events in the chart.  For example, clicking on “Top 10 Events” shows the top 10 User Names and Forwarders for each of the top 10 events:

 

 image

 

You can also run the “Event Count Details” report on its own to show the Top N User Name, Event or Forwarder based on a User, Event, or Computer Name filter:

image

Attachment: EventCountACSReport.zip
Comments
  • Thanks

  • Excellet reports.

    Thanks Jimmy..

  • I want to schedule these reports to be mailed to me for archiving purpose. However when i went to schedule I dont see an option to set the time for yesterday to today , instead it schedules as per date.

    If i schedule the report will it automatically take the next days.

  • Correct....they default to just the last 1 day of data and do not have an option for a relative date....I'll try to update them soon

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment