Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > IP Address Manager (IPAM) > IPAM - Knowledgebase Articles > Export subnets via Database Manager

Export subnets via Database Manager

Table of contents
Created by Alejandro Realo, last modified by Melanie Boyd on Mar 06, 2019

Views: 524 Votes: 10 Revisions: 15

Overview

Exporting subnets via IPAM is not possible as it would export the individual IP address for every subnet instead of just the subnets.

 

You can use the Database Manager to Export those subnets.

Environment

All IPAM versions

Steps

You can ask your DBA to export data from the IPAM_Group Table.

Or, if you want to do it yourself, you can use the Database Manager.

 

  1. Open Database Manager (Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager).
  2. Browse to the IPAM group and right-click it, and then click Query table.
    IPgroup1.png
  3. Edit the query in the Database manager into “Select * FROM [dbo].[IPAM_Group]”.
    IPgroup2.PNG
    Note: If it hangs, then it is possible to use the Database Manager and you will need to use MS SQL Management Studio.
  4. Click Execute Query to display the results.Then click Export to CSV.
    IPgroup3.PNG
  5. Open the CSV file. It will contain a large number of values separated by commas. as shown in the following example.
    IPgroup4.png
  6. To make the information more readable, choose Data > Text To Columns. Then click Next until you see the delimited option.
    IPgroup6.PNG
  7. Select "Comma," and finish the wizard.
    IPgroup7.PNG

 

IPgroup8.PNG

 

IPgroup9.PNG

 

Note: You still might need to fine tune the file because it will contain columns that you don’t need such as GroupID and ParentID.

You should also remove all GroupTypes except 2, 4, and 8 because they represent Group, Supernet and Subnet. Change those values to Group, Supernet ,and Subnet so that the system will accept them:

2 = Group

4 = Supernet

8 = Subnet

 

 

Last modified

Tags

Classifications

Public