Close Menu
ElMajdal.netElMajdal.net
    Facebook X (Twitter) Instagram YouTube
    Facebook X (Twitter) Instagram YouTube
    ElMajdal.netElMajdal.net
    Contact Us
    • Home
    • Windows
      • Windows 11
      • Windows 10
      • Windows 8
      • Windows 7
    • Servers
      • Windows Server
      • Windows Server 2008
      • Exchange Server
    • MAC OS
    • ISA/TMG
    • About Tarek
    ElMajdal.netElMajdal.net
    Home » ISA Firewall Quick Tip : Creating Detailed Reports Using ISA Server 2006 and Excel
    ISA Server

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

    TarekBy Tarek3 Mins Read
    WhatsApp Facebook Twitter Telegram Reddit Email
    blank
    Share
    WhatsApp Facebook Twitter Telegram Reddit Email

    Introduction

    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…
    We will not use any 3rd party Application or Web Filter to create our reports. All we need is ISA Server 2006 with MSDE logging (or ISA 2004) plus Excel .

    Configuration on ISA Server

    1. Open ISA Management Console

    2. Under the Monitoring node, click on Logging

    3. We 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.

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

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

    6. 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

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

    8. 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 )

    9. 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

    10. The Filter will look like :

    11. Click on the Start Query.

    12. 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.

    13 Now, to copy the results to Excel, on the Right Side Pane, under Tasks, click on Copy All Result to Clipboard

    14. Now open Microsoft Excel , and paste the result. You can remove any column you find it not to be necessary and keep only the columns you want.

    Summary

    In this article, we learned how to created a report without the need for any third party application or web filter. All what we used is ISA
    Server 2006 with MSDE logging and Excel.

    Share. WhatsApp Facebook Twitter Telegram Reddit Email
    Previous ArticleISA Firewall Quick Tip : Assigning the Same Static IP for a VPN Client
    Next Article ISA Firewall Quick Tip : Publishing ULTRA VNC with ISA Server 2006
    Tarek
    • Website
    • Facebook
    • X (Twitter)
    • Instagram

    Tarek Majdalani is an accomplished Windows Expert-IT Pro MVP, honored by Microsoft for eight consecutive years from 2007-2015. Holding a B.E. in Computer Engineering from the Lebanese American University, he pursued further education while working, earning various certificates showcased in his MVP profile. Tarek is currently serving as the Director of Engineering & Technology at Alrai Media Group in Kuwait. Since 2006, he has been actively contributing to the community by writing tutorials featuring tips and tricks, amassing over 300 tutorials on diverse systems.

    Related Article

    ISA 2004, ISA 2006 and TMG Server 2010 Version Numbers

    Enabling HTTPS Inspection With Forefront TMG Server 2010

    Search Feature For TMG 2010 Firewall Policies

    Leave A Reply Cancel Reply

    Latest Posts

    How To Enable Active Directory Recycle Bin On Windows Server

    How To Check The Health Of Your Laptop’s Battery In Windows

    How To Transfer FSMO Roles In Active Directory Using PowerShell

    How To Check Active Directory Forest And Domain Functional Level In Windows Server

    Advertisement

    For any Feedback, click on the Contact Us link

    Facebook X (Twitter) Instagram YouTube
    Quick Links
    • Contact Us
    • About Tarek
    • Windows 11
    • Windows 8
    • Windows 10
    • Windows 7
    • Windows Server
    • Windows Server 2008
    • Exchange Server
    • macOS
    • ISA Server
    • Privacy Policy
    Visitors
    • Contact Us
    • About Tarek
    • Windows 11
    • Windows 8
    • Windows 10
    • Windows 7
    • Windows Server
    • Windows Server 2008
    • Exchange Server
    • macOS
    • ISA Server
    • Privacy Policy
    © ElMajdal 2007-2025

    Type above and press Enter to search. Press Esc to cancel.

    ×