- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
Export all ip addresses to csv
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-08-2016 02:11 PM
We have a 100's of networks defined in IPAM. Is there an easy way to the records for all networks to CSV using the WAPI or PAPI?
Re: Export all ip addresses to csv
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-08-2016 02:28 PM
It can prpbably be done, it will be slow. It al depends on the use case.
Why do you need to export all the addresses ?
Re: Export all ip addresses to csv
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-26-2016
07:18 AM
- last edited on
01-26-2016
09:30 AM
by
EricS
Are you kidding?
we are for example doing a datacenter move, which is definitely a good reason do dump ALL IP addresses in IPAM !!
But I can figure out dozens of other examples where it is (well, would be...) VERY useful !!!
Re: Export all ip addresses to csv
[ Edited ]- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-28-2016 12:31 PM - edited 01-28-2016 12:31 PM
My point was that perhaps you only need to dump a subset of the addresses, or a subset of the DNS data that matches what you are looking for.
Dumping the entire contents of the database just so you can search for something will be slow. Doing a more specific search that returns a reduced dataset will speed things up.
If you are doing a data center move, is there a way to identify only the addresses that are part of the move ? If you did export everything, were you then going to search through it for certain items ? IF so, can you just craft that query as part of your initial call to the API to get the data ?
less is more.
Re: Export all ip addresses to csv
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
04-15-2016 12:23 PM
I have a need to export the entire database to help in reconcilliation efforts because our user base has neglected to update it as required. My network is extremely large with no true way of knowing all subnets defined(nested) within the IPAM database. The only way I currently see of determining everything currently defined in IPAM is to click on every subnet and keep drilling down in each one which will take weeks. If I had an export file I could write some scripts to parse out the needed data and save me a substantial amount of time.
Re: Export all ip addresses to csv
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
05-19-2016 07:57 AM
I had to do something similar for a company that has 1000s of external domains (many defensive domains registered to stop them being hijacked) I was hoping to use the wapi and use fileop and the cvs-export object but could not get this working. Therefore the following via a browser returned the data as XML.
then notepad++ (other text editors are available) and excel allowed me to get the information the guy I am working for wanted that would have taken him days in couple of hours.
This same data could easliy be edited into CSV Import format.