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.
so at the risk of showing my true ignorance, is this some sort of SQL database change itself?
This updates the database directly without using Orion IPAM. Don't do updates without a database backup.