Hello. I am not sure if this is possible or if I am even asking it correctly. I will give it a shot.
I have a central SMS server with SQL 2005 and 4 child primary SMS servers with SQL 2005. Administrators on the child primary SMS servers manually delete resources from the database on their server. These deletions do not migrated up to the central SMS server. This means that reports created on the central server are not accurate.
Is there anyway I can compare central server with the child server and delete resources on the central server that are not present on the child servers?