I have a CMS setup on my Monitoring server that can talk to all other servers. It looks like this
I would like to know if there is a way(scripting) to add a new server to this monitoring group. I know I can rt click and register a new server but I want to run a SP rather than using the GUI. Coz when ever a new serve is created I want to run this SP that adds new server to this group.
Please advise. Also does anyone know if we can query the metadata associated with CMS
SELECT ServerName, RegisteredGroup FROM master/msdb.SomeTableThatSavesCMSData
Today is the tomorrow you worried about yesterday:-)