%3CLINGO-SUB%20id%3D%22lingo-sub-365738%22%20slang%3D%22en-US%22%3EACS%20%E2%80%9CEvent%20Count%E2%80%9D%20reports%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-365738%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20TECHNET%20on%20Apr%2018%2C%202013%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CP%3EHere%20are%20a%20couple%20of%20ACS%20reports%20to%20show%20the%20event%20count%20by%20User%2C%20Forwarder%2C%20and%20Event%20ID.%26nbsp%3B%20Just%20import%20the%20.rdl%20files%20into%20a%20folder%20in%20SQL%20Server%20Reporting%20Services.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EThe%20first%20report%20%E2%80%9CEvent%20Count%20Overview%E2%80%9D%20shows%20the%20top%2010%20Events%2C%20Forwarders%2C%20and%20User%20Names%20for%20the%20specified%20date%20range%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86927i8A635EAE6BB2BBF3%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EClick%20on%20any%20of%20the%20bars%20in%20the%20chart%20or%20the%20chart%20titles%20to%20launch%20the%20%E2%80%9CEvent%20Count%20Details%E2%80%9D%20report.%26nbsp%3B%20This%20report%20shows%20more%20detail%20about%20the%20item%20that%20you%20clicked%20on.%26nbsp%3B%20For%20example%2C%20if%20you%20click%20on%20the%20bar%20for%20a%20specific%20event%20Id%20in%20the%20%E2%80%9CTop%2010%20Events%E2%80%9D%20section%2C%20it%20will%20show%20the%20top%2010%20User%20Names%20and%20Forwarders%20for%20this%20event%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86928i6D81AD9C067563AC%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EIf%20you%20click%20on%20the%20bar%20for%20a%20specific%20Forwarder%20in%20the%20%E2%80%9CTop%2010%20Forwarders%E2%80%9D%20section%2C%20it%20will%20show%20the%20top%2010%20User%20Names%20and%20Events%20IDs%20for%20this%20forwarder%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86930i2F5D56DEA9A9D158%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EIf%20you%20click%20on%20one%20of%20the%20chart%20titles%20it%20will%20show%20details%20for%20all%20events%20in%20the%20chart.%26nbsp%3B%20For%20example%2C%20clicking%20on%20%E2%80%9CTop%2010%20Events%E2%80%9D%20shows%20the%20top%2010%20User%20Names%20and%20Forwarders%20for%20each%20of%20the%20top%2010%20events%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86932i6AB6E5F3FFE3E534%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EYou%20can%20also%20run%20the%20%E2%80%9CEvent%20Count%20Details%E2%80%9D%20report%20on%20its%20own%20to%20show%20the%20Top%20N%20User%20Name%2C%20Event%20or%20Forwarder%20based%20on%20a%20User%2C%20Event%2C%20or%20Computer%20Name%20filter%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F86934iB01B8204D5FEEBE7%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmsdnshared.blob.core.windows.net%2Fmedia%2FTNBlogsFS%2Fprod.evol.blogs.technet.com%2Ftelligent.evolution.components.attachments%2F01%2F6699%2F00%2F00%2F03%2F56%2F76%2F47%2FEventCountACSReport.zip%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20EventCountACSReport.zip%20%3C%2FA%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-365738%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Apr%2018%2C%202013%20Here%20are%20a%20couple%20of%20ACS%20reports%20to%20show%20the%20event%20count%20by%20User%2C%20Forwarder%2C%20and%20Event%20ID.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-365738%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eacs%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eacs%20report%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EReport%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft

First published on TECHNET on Apr 18, 2013

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:

 

 

 

 

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:

 

 

 

 

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:

 

 

 

 

 

 

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:

 

 

 

 

 

 

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:

 

 

EventCountACSReport.zip