Could anyone advise on whether it's possible to create dependencies in bulk?
I have 3000 sites, each with 3 monitored nodes. Node 'Server' is dependent on Node 'Switch' which is dependent on Node 'Router' so I'd like to set up this dependency for every site without, obviously, having to do it manually.
Each node at the site has a common 'Site ID' custom property and each of the Nodes has a different 'Device Type' custom property. eg. Router, Switch, Server.
So for each Site ID in turn I want to set Router as the parent of Switch and Switch as the parent of Server.
We have some SQL skills if it looks like we have to go that way ...
