5 Replies Latest reply on Oct 22, 2015 11:03 AM by jamesp001

    Exporting IPAM excel sheets

    naeemfirdous

      Is it possible to schedule a process in solarwinds to export all the IPAM subnet excel sheets on weekly/monthly basis.

        • Re: Exporting IPAM excel sheets
          michal.hrncirik

          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"

            • Re: Exporting IPAM excel sheets
              foonly

              I would like this feature as well.

               

              Plus, I would like it to export everything that import can import. That way we can update many settings much more easily than with the Web page.

               

              =foon=

                • Re: Exporting IPAM excel sheets
                  michal.hrncirik

                  hi foonly,

                   

                  can you quickly summarize operations which are painful to do via web (you referring to update operations - I assume "bulk" ones). thanks for sharing.

                    • Re: Exporting IPAM excel sheets
                      foonly

                      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=

                        • Re: Exporting IPAM excel sheets
                          jamesp001

                          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.