Windows Support Tools

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Tuesday, 23 March 2010

ISA Firewall Quick Tip : Creating Detailed Reports Using ISA Server 2006 and Excel

Posted on 21:10 by Unknown

Ever wanted to create your own Reports ??? Are you wondering how to create a detailed report for a specific amount of time ,user, URL, Protocol ,etc...

Open ISA Management Console

Under the Monitoring node, click on Logging

Example will create a report with the following filters ( you can customize your reports as needed)
a. Logging Last 7 Days
b. Action Allowed Connection
c. Protocol HTTP
d. Client Username Not Equal to Anonymous ( Here you can choose a specific user for example )
e. Specify on which Firewall Policy we want to run the logging for.

# Click on Edit Filter, to start editing and adding our filters.

# Click on Log Time, then under the Condition drop down list, choose Last 7 Days, and click on Update

Click on Action, then under the Condition drop down list, choose Equals, and under the Value drop down list choose Allow Connection and click on Update

Under the Filter By choose Protocol, under the Condition choose Equals, and under the Value choose HTTP then click on Add To List

Under the Filter By choose Client Username, under the Condition choose Not Equals, and under the Value write Anonymous then click on Add To List ( we want to monitor all authenticated users by username )

Under the Filter By choose Rule, under the Condition choose Equals, and under the Value choose the Firewall Policy you want to run the report for, in this article we have a rule called Allow Internet For All then click on Add To List

# Click on the Start Query

# The Results will be fetched and displayed . Note that a pop up windows will state that a maximum of 10,000 records can be displayed only. Click OK

If you clicked on Help, you will know the reason why a maximum of 10,000 resulted can be displayed.

Now, to copy the results to Excel, on the Right Side Pane, under Tasks, click on Copy All Result to Clipboard.
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in ISA Firewall, ISA Server 2006, Quick Tips, Reports, Tips | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Receiving Error 'ORA-01041: internal error. hostdef extension doesn't exist.' on re-establishing a connection to Oracle.
    You can receive the error message 'Error ORA-01041: internal error. hostdef extension doesn't exist' when attempting to re-esta...
  • Google Sinks Cash into Undersea Cable
    Google has joined the Unity consortium, which will build a $300 million fiber optic cable linking the US and Japan. The 7.68 Tbps, 10,000 ki...
  • Battle Progress Map
  • C Traps and Pitfalls (Addison Wesley, 1989, English)
    C Traps and Pitfalls teaches how the peculiarities of the C language make it easy for the intended behavior of a program and the actual beha...
  • Troubleshooting the Microsoft Exchange Transport Service When It Fails to Start on an Exchange 2007 Hub Transport Server with Event ID 1032 or 1036
    Event ID: 1032 Socket Access Denied. Binding: 0.0.0.0:25. Event ID: 1036 Failed to open one or more bindings. The service will be stopped....
  • Alcohol 120% v5 Blu-ray Burner Free Download with Registration Unlock Code
    Alcohol 120% is a CD and DVD burning, copying, backup, recording, duplication, emulation and creation software for Windows. In addition to c...
  • ORA-01991: invalid password file
    Oracle Version: 10gr1 OS: Windows 2003 Server In development db i was getting below error message during database startup in mount stage. SQ...
  • Working with Time Zones in the Exchange Web Services GetUserAvailability Operation
    Time zones can be tricky, as any developer who has tried to create a calendaring application for clients on opposite ends of the world can t...
  • SlySoft CloneDVD 2.9.1.6
    CloneDVD 2 copies movies to create unparalleled picture quality DVD backups, whether it’s the main title you’re copying or the complete DVD....
  • Free Download PDF Password Remover 1.5.2 with Crack
      Wondershare PDF Password Remover software is perfect tool for removing the password restrictions of PDF files. PDF files are typically com...

Categories

  • ISA Firewall
  • ISA Server 2006
  • Quick Tips
  • Reports
  • Tips

Blog Archive

  • ►  2013 (7)
    • ►  October (6)
    • ►  February (1)
  • ►  2012 (10)
    • ►  September (3)
    • ►  August (3)
    • ►  July (3)
    • ►  June (1)
  • ►  2011 (16)
    • ►  August (2)
    • ►  July (4)
    • ►  June (3)
    • ►  May (1)
    • ►  April (1)
    • ►  March (4)
    • ►  January (1)
  • ▼  2010 (12)
    • ►  December (3)
    • ►  October (4)
    • ▼  March (1)
      • ISA Firewall Quick Tip : Creating Detailed Reports...
    • ►  January (4)
  • ►  2009 (67)
    • ►  August (2)
    • ►  July (18)
    • ►  June (23)
    • ►  April (3)
    • ►  March (6)
    • ►  February (7)
    • ►  January (8)
  • ►  2008 (319)
    • ►  December (30)
    • ►  November (43)
    • ►  October (45)
    • ►  September (12)
    • ►  August (18)
    • ►  July (27)
    • ►  June (15)
    • ►  May (7)
    • ►  April (55)
    • ►  March (65)
    • ►  January (2)
  • ►  2007 (10)
    • ►  December (2)
    • ►  November (8)
Powered by Blogger.

About Me

Unknown
View my complete profile