ISA in SBS - yes, it's secure

A central location for SBS ISA specific configuration information relevant to small consulting practices and others smart enough to use the best technology in the world.

Lingo - The Talk of Broadband

Thursday, January 11, 2007

Creating a Visited Websites Report by User

Many admins learned how to create reports by opening up the log files in ISA 2000 and using Excel features to organize the data in a meaningful way. Contrary to popular opinion, you can use Excel to generate a report using ISA 2004 with MSDE logging much easier than in ISA 2000 flat files.

Start by trimming out what you don't want to see, right in ISA.

In the monitoring tab create a query with the information you want to view.

Logging last 7 days
Protocol HTTP
Action Allowed Connection
Rule SBS Internet Access Rule
Client Username Not Equal Annonymous

This will display in the monitoring viewer a list of packets going to websites. Press the Copy to Clipboard and then paste into Excel to start organizating the data into a report.

2 Comments:

At 10:06 PM, Blogger Brian Blake said...

thank you thank you thank you!

 
At 7:55 PM, Anonymous Tech-Mentor said...

You may want to download my freeware utility done specifically for
this specific need.

http://www2.tech-mentor.com/uwr

 

Post a Comment

<< Home