NEED AN "INVENTORY" REPORT OF NODE FOR DATABASE CLEANUP!

etcentene

Similar to the thread below (Image 1a) I am looking to stand up a brand new Solarwinds Environment (3 actually) with the EOC etc and would like to be able to run a SQL query that does what the query below does only for the node I am importing not the custom properties.  The old instance of Solarwinds was stood up 10 years ago and has outgrown its self(Image 2a)

We need to be able to move certain NODES over to the new environment along with all the custom views the node appears on, groups, alerts node is assigned to, SAM monitors etc etc etc.    Does anyone know if this is something that can be done similar to the Query in the same thread as image 1a?   Any assistance would be much appreciated. 

1a

2a

mesverrum

Syncing things up across multiple instances and capturing the nodes, child objects, sam templates, template over rides, custom properties, alerts, views, groups is not something that comes out concisely.   I've done it many times for clients in the past but it typically involved 10-20 days of professional services to figure it out, move it over, then validate what did or didn't come across. Its not really the kind of thing that lends itself to a single thwack response, lots of moving parts.