Network Management

How to delete subnets on console and database in IPAM

Steps for deleting subnets on the console and database in IPAM

First published date

4/26/2019 3:12 PM

Last published date

12/15/2021 1:34 PM

Overview

If customer would like to delete subnets via console or by bulk via database.

Product section

IP Address Manager

Cause

Customers can manually delete subnets via console, or if they would like to do it in bulk or on the database, they can use the below steps.

Resolution

Deleting via Console.
  1. Open the Solarwinds console.
  2. Click MY DashBoards.
  3. Click Manage Subnets and IP Addresses.
  4. Locate the subnets on your left or right pane.
  5. If you'd like to do it in bulk, you can click the checkboxes.
  6. Click Delete.

Deleting via database.
  1. Open database Manager on Solarwinds Server.
  2. Locate IPAM_GroupType
  3. Run the below query to show only subnets (GroupType "8" represent subnets).
-- Scripts are not supported under any SolarWinds support program or service.
-- Scripts are provided AS IS without warranty of any kind. SolarWinds further
-- disclaims all warranties including, without limitation, any implied warranties
-- of merchantability or of fitness for a particular purpose. The risk arising
-- out of the use or performance of the scripts and documentation stays with you.
-- In no event shall SolarWinds or anyone else involved in the creation,
-- production, or delivery of the scripts be liable for any damages whatsoever
-- (including, without limitation, damages for loss of business profits, business
-- interruption, loss of business information, or other pecuniary loss) arising
-- out of the use of or inability to use the scripts or documentation.


SELECT * FROM [dbo].[IPAM_Group]
WHERE GroupType = 8
4. Select and highlight the subnets that you would like to delete.
5. Click Enable table Editing.
6. Right-click the selected rows.
7. Click "Delete the selected row.



Note: This will NOT delete the DHCP server when deleting subnets