Network Management

How to disable auto-update of comments field in IPAM

This article provides a short description and a simple query on how to disable auto-update of "comments" every subnet scanning.

First published date

11/26/2018 6:37 PM

Last published date

11/26/2018 6:37 PM

Overview

This article provides steps on how to disable auto-update of comments every time IPAM scans the subnet.

Product section

IP Address Manager

Resolution

  1. On the Manage Subnets and IP addresses page, click the subnet that you want to disable auto-update of comments.
  2. Click Edit on the upper-left corner of the page. An Edit Subnet Properties window prompts after this.
  3. Scroll down to get to the Automatic Scanning section then choose Update but not erase manually entered data. See attached image for reference.

Choosing this option prevents the application from deleting any data filled out in the Comment field. However, the difficulty lies when there are thousand of subnets to be updated with the same scenario above. Use this query below to update the database setting of all 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.

USE [SolarWindsOrion];

UPDATE IPAM_Group
SET RetainUserData = 1 
WHERE GroupType = 8

Note: Replace [SolarWindsOrion] with the name of your Orion database.

 

****PLEASE NOTE****

Please note that the updating of this setting does not in any way protect any data within the IP fields if the IP is placed into an Available state. The Available status will always wipe clean any and all comments and information manually inserted into an IP. This is intended and by design for the product for licensing purposes.