Hi,
I have a lot of subnets in IPAM and I now realized that the ones that are not in use (which I imported with the display name "free" or "Spare" and the custom field Category='free') should rather have the type supernet instead of subnets!
I was wondering if i could fix this with an SQL Update which would look something like this:
UPDATE IPAM_Group g, IPAM_GrouptAttrData d
set g.GroupType='8'
where g.g.GroupId = d.GroupId
and d.Category='free';
Can this be done without causing damage to the IPAM database?
