Ways to Export ISA Rules to Excel?

Asked By alyss aellaa 10 points N/A Posted on - 04/27/2013

Hi TechyV Friends!

Please help me. I am looking for different ways to export ISA Rules to excel. I would love to hear advices from experienced and advanced users. If possible, please provide a simple tutorial on how to export ISA rules to excel. If you are using different ISA servers such as ISA server 2000, 2003 or 2006, then please advice. Thank you so much.

 

• Status: Open
• Question Views: 4994
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Software

Answered By Banks Utterback 0 points N/A #177348

Ways to Export ISA Rules to Excel?

 

Hello Alyss,

It is common for system administrators to back up ISA rules for reference.

Below is a summarized tutorial using ISA Server 2004, Windows 7  on the client side and Excel 2007. Google and download ISAInfo2XLS.hta (we will need this app later on).

·         On the 2004 server, open the ISA management console, expand the server and select “Firewall policy”.

·         Right-click “firewall policy” and select “Export”

·         Save in a location you are unlikely to forget.

·         Import the files into the ISAInfo2XLS.hta app and expand the firewall policy tab and click “Array Rules.” Then copy all data into a text file.

·         Navigate to MS Excel and select the file type to all, locate your text file and click ok.

·         The text import wizard will run. See below.

 

·         Select others, type “|”

·         Click finish and your file will be generated

You should do the same for all other ISA server policies.

Richard Knight is credited for the development of ISAInfo2XLS.hta

 

About Banks Utterback

Questions
1

Answers
16

Best Answers
7

• Vote Up 0 Vote Down

• Posted on - 05/09/2013
• Question Category: Server Software