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

  • What is Cloud Computing ?
  • Cartoons of the Week
  • 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...
  • Setting up a DHCP server in Windows 2003
    The DHCP server assigns a client an IP address taken from a predefined scope for a given amount of time. If an IP address is required for lo...
  • Manage your home network better with Network Magic 5.0
    Cisco announced on Thursday Network Magic 5.0, a suite of network management software. This is is the first product released by Cisco since ...
  • 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...
  • Battle Progress Map
  • Keyshia Cole - Just Like You (2007)
    1- Let It Go feat Missy Elliot and Lil Kim [03:58] 02- Didn't I Tell You feat Too Short [03:52] 03- Fallin Out [04:27] 04- Give Me More ...
  • Complete Wireless Design (McGraw-Hill, 2008, English)
    ON THE CD-ROM *PUFF RF/Microwave circuit simulation software *Sonnet Lite electromagnetic simulation software *National's PLL Design Pro...
  • Nambara Sanda Wage

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