Home Page | Skip to Navigation | Skip to Content | Skip to Search | Skip to Footer

Home >   Check Point Forums >   Security Management >   Multi-Domain Management (Provider-1) & Security Management Server

Thread: Excel Template for Hosts and Networks

Welcome, Guest Help
Login Login
Guest Settings Guest Settings

Permlink Replies: 14 - Pages: 1 - Last Post: Jun 24, 2017 3:53 AM by: Dameon Welch-Ab... Threads: [ Previous | Next ]
Guest
Excel Template for Hosts and Networks
Posted: May 20, 2009 12:17 PM
  Click to reply to this thread Reply

Attached is an Excel template with mappings of hosts and network objects.
This template can be used for visualization or manipulation of the data output by Confwiz.

Follow the following procedure in order to manipulate host or network objects with this template:
1. Download the Excel spreadsheet template from:
http://downloads.checkpoint.com/dc/download.htm?ID=10255
2. Run confwiz export against your management server.
3. Open the attached Excel spreadsheet.
4. From the toolbar, choose Data -> XML -> Import and select the database\network_objects.xml file output by Confwiz.
5. Manipulate the relevant fields, for example, change ip addresses of host objects.
6. Choose Data -> XML -> Export and select the database\network_objects.xml file again.
7. Run confwiz import against your management server.

As you know, Excel is a powerful tool and can be used for many different manipulation methods. For example, you can easily create 200 hosts with consecutive IPs in seconds by just creating the first and then dragging down the name and IP columns of the hosts.

Note that you can map the different objects and fields by using the XML Source Task Pane (reachable via Data -> XML -> XML Source).

This XML functionality is only supported in the Professional Edition of Excel.

Message was edited by: Ofer Israeli

Message was edited by: Ofer Israeli

Karthikeyan Par...

Posts: 3
Registered: 4/10/08
Re: Excel Template for Hosts and Networks
Posted: Jun 23, 2009 5:03 PM   in response to: Guest
  Click to reply to this thread Reply

Hello,

I do not see any attachment here.
Am I missing something?

Regards,
Karthik

Guest
Re: Excel Template for Hosts and Networks
Posted: Jun 23, 2009 5:17 PM   in response to: Karthikeyan Par...
  Click to reply to this thread Reply

Hi Karthik,

This is being taken care of and will be available shortly.


Best Regards,
Ofer

Guest
Re: Excel Template for Hosts and Networks
Posted: Jun 23, 2009 7:06 PM   in response to: Guest
  Click to reply to this thread Reply

You can find the template attached.

Best Regards,
Ofer

Karthikeyan Par...

Posts: 3
Registered: 4/10/08
Re: Excel Template for Hosts and Networks
Posted: Jun 23, 2009 10:37 PM   in response to: Guest
  Click to reply to this thread Reply

Thank!! I was able to import/export objects without any issues in R65. Now I need to figure out how to create templates. Read excel help??. Any pointers of how to import schemas to create these templates?

Regards,
Karthik

Guest
Re: Excel Template for Hosts and Networks
Posted: Jun 24, 2009 12:38 PM   in response to: Karthikeyan Par...
  Click to reply to this thread Reply

You're very welcome. I'm happy to hear about your success in R65.
The way I worked with creating Excel templates is by opening up an XML and choosing to "use the XML Source task pane" when Excel opens up. Excel automatically creates an XML schema for you. Now you need to take different elements from the XML Source task pane and drag them onto your document.
Do note that there are all kinds of issues when you have multiple elements in an example XML. Please refer to the Excel help for more information.

Karthikeyan Par...

Posts: 3
Registered: 4/10/08
Re: Excel Template for Hosts and Networks
Posted: Jun 25, 2009 5:38 PM   in response to: Guest
  Click to reply to this thread Reply

Just did that and able to create our own templates now.
Thanks for all your help with this.
This makes life easy :)

Regards,
Karthik

Guest
Re: Excel Template for Hosts and Networks
Posted: Jun 25, 2009 6:46 PM   in response to: Karthikeyan Par...
  Click to reply to this thread Reply

Great! Happy to hear it worked out for you.

Enjoy,
Ofer

Guest
Re: Excel Template for Hosts and Networks
Posted: Jul 7, 2009 1:31 PM   in response to: Guest
  Click to reply to this thread Reply

SK42302 has been published explaining the procedure of using Confwiz and Excel for mass object creation.

Mike Sleath

Posts: 1
Registered: 7/2/08
Re: Excel Template for Hosts and Networks
Posted: Jul 10, 2009 4:11 PM   in response to: Guest
  Click to reply to this thread Reply

Hi,

Is there a similar template available for the manipulation of the users table? Specifically for the creation of new users and new groups and also adding/deleting existing users to and from existing groups?

cheers,

Mike

Guest
Re: Excel Template for Hosts and Networks
Posted: Jul 12, 2009 2:46 PM   in response to: Mike Sleath
  Click to reply to this thread Reply

Hi Mike,

Currently I am not familiar with any users table template. If anyone has created such a template, I'll be more than happy if you upload it and share with Mike and others.
Basically, you can follow some tutorial on the web on how to map XML files in Excel and usually it can be done pretty easily. If you do go ahead and do so, I'll be happy to hear (or better yet see) your results.


Cheers,
Ofer

Philippe Heeren

Posts: 1
Registered: 10/22/12
Re: Excel Template for Hosts and Networks
Posted: Oct 22, 2012 7:08 PM   in response to: Guest
  Click to reply to this thread Reply

I'm trying to use this method to import export. Couple of questions though.
- Are there any other ways of import/export which might be easier?
- When importing do I need to have all the old data in there as well? Or do you only import the new data?

Thanks

Attila Peter Ko...

Posts: 2
Registered: 6/10/11
Re: Excel Template for Hosts and Networks
Posted: Dec 12, 2013 3:50 PM   in response to: Guest
  Click to reply to this thread Reply

Hello!

I know that confwiz only tested until R75.46, but have somebody used it with R75.47 or R77?

Regards,
Attila

Dominique Puenter

Posts: 1
Registered: 3/16/17
Re: Excel Template for Hosts and Networks
Posted: Mar 20, 2017 11:09 AM   in response to: Philippe Heeren
  Click to reply to this thread Reply

Hi Phillipe,

I have the same question.

Is the bahavior of confiz appandig objects or is tghe DB overwritten if I only Import only the new objects?

Can you help?

Thanks Dominique

Dameon Welch-Ab...

Posts: 142
Registered: 4/16/09
Re: Excel Template for Hosts and Networks
Posted: Jun 24, 2017 3:53 AM   in response to: Guest
  Click to reply to this thread Reply

There are new ways to do this now with R80 and beyond.
Several code samples are available here: https://community.checkpoint.com/community/developers/code-library

Legend
Expert: 751 + pts
Advanced: 301 - 750 pts
Enthusiast: 101 - 300 pts
Novice: 0 - 100 pts
Check Point
Helpful Answer (5 pts)
Correct Answer (10 pts)