We recently fired up IPAM and imported all 1100+ scopes in to it. We have two DHCP servers, and we split the scopes. Is there a way to change the Location field for several scopes at a time? Going thru each one seems painful.
thanx,
michael
UPDATE IPAM_Group
SET Location = 'New York'
WHERE ParentId = 100 AND
GroupType = 8
If you SELECT * FROM IPAM_Group, you will find different attributed you can filter with. GroupType = 2 is Groups, 4 is Supernets, and 8 is Subnets.
2 is DHCP Servers, so that's how you find the ParentID you filter on to find all the subnets belonging to a DHCP server.
-=Dan=-
so at the risk of showing my true ignorance, is this some sort of SQL database change itself?
thanx.
This updates the database directly without using Orion IPAM. Don't do updates without a database backup.
