How to change bulk IP address in NPM?

How to change bulk IP address in NPM?
Parents
  • If you are looking to update other fields, and not the IP itself, I use the following in the DB Manager

    The example below searches for any 3rd octect, if 4th is 1-3 ( used this to update all the Cisco VRRP IP subnet descriptions)


    SELECT IPNodeID, IPAddress, Alias, DNSBackward, sysName, Location, Comments FROM [dbo].[IPAM_Node] WHERE IPAddress like '10.102.%.[1-3]'

    Enable table editing and copy and paste the updated information.


    If you are looking for other custom IPAM fields to update it would be similar to the below, you could use a join command with the above, as the below relies on the IPNodeID

    SELECT * FROM [dbo].[IPAM_NodeAttrData] WHERE IPNodeID = '80052' or IPNodeID = '444005' or IPNodeID = '446053'

Reply
  • If you are looking to update other fields, and not the IP itself, I use the following in the DB Manager

    The example below searches for any 3rd octect, if 4th is 1-3 ( used this to update all the Cisco VRRP IP subnet descriptions)


    SELECT IPNodeID, IPAddress, Alias, DNSBackward, sysName, Location, Comments FROM [dbo].[IPAM_Node] WHERE IPAddress like '10.102.%.[1-3]'

    Enable table editing and copy and paste the updated information.


    If you are looking for other custom IPAM fields to update it would be similar to the below, you could use a join command with the above, as the below relies on the IPNodeID

    SELECT * FROM [dbo].[IPAM_NodeAttrData] WHERE IPNodeID = '80052' or IPNodeID = '444005' or IPNodeID = '446053'

Children
No Data