Is it possible to schedule a process in solarwinds to export all the IPAM subnet excel sheets on weekly/monthly basis.
Is it possible to schedule a process in solarwinds to export all the IPAM subnet excel sheets on weekly/monthly basis.
Hi,
not directly in the IPAM itself. but you can certainly use our API/SDK and schedule the Windows Schedueld task to do that. Here is a post I wrote about using IPAM API and how to get FreeIP address, it could be modified to export all IP addresses and subnets into spreadsheet: How to use the IPAM API and get "Free IP Address"
Currently, export does not export all the same fields as import. It should.
It also does not export everything that is displayed.
Note that, since there are 2 kinds of Import and Display, there should probably 2 kinds of Export (lists of addresses and lists of subnets).
I would be happiest if export would export everything that import imports, plus all other displayed fields. This would allow easier auditing against other databases used by many customers, such as asset tracking, helpdesk, security appliances, etc. In general, we need more consistent naming - or maybe a guide for mapping field names - for display, export, and import. As you can see below, it's hard sometimes to figure out what corresponds with what.
Finally, there should be a choice between exporting in individual subnet files, and all 1 file.
Export | Import | Displayed |
Address | Address | |
Address (IPv6) | ||
Alias | Alias | Alias |
CIDR | ||
Comments | Comments | Comments |
Contact | Contact | System Contact |
Custom_1 | ||
Description | ||
DHCP Client Name | DHCP Client Name | |
DHCP Reservation | ||
Display Name | ||
DNS Records | ||
Dual Stack IPv6 Address | Dual Stack IPv6 Address | |
Hostname | Hostname | Hostname |
IP Address | IP Address | |
Last Boot Time | Last Boot Time | |
Last Response | ||
Last Synchronization | Last Synchronization | |
Lease Expiration | Lease Expiration | Lease Expiration |
Lease Remaining | ||
MAC Address | MAC Address | MAC |
Machine Type | Machine Type | Machine Type |
Subnet Mask | Mask | |
Response Time | Response Time | Response Time |
Scope Name | ||
Skip Scan | Skip Scan | Skip Scan |
Status | Status | Status |
Subnet Address | ||
Subnet CIDR | ||
System Description | ||
Subnet Display Name | ||
System Location | System Location | System Location |
System Name | System Name | System Name |
System Object ID | System Object ID | |
Type | Type | Type |
URLField | ||
Vendor | Vendor | Vendor |
=Seymour=
I agree. This is a frustrating task when you want to export multiple subnets from one SW server IPAM and import it to another. I find myself having to go through each subnet and add in things like Subnet Address/CIDR, Group Description, VLAN and Location to the CSVs before importing them.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.