June 25, 2013 at 1:04 pm
I have a CMS setup on my Monitoring server that can talk to all other servers.
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
Ex:
SELECT ServerName, RegisteredGroup FROM master/msdb.SomeTableThatSavesCMSData
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 25, 2013 at 2:41 pm
I don't know if this is what you are looking for, but I've always used powershell to do this. If you have a master list of your servers in a table somewhere, then it is really easy to grab those with powershell and register them in the CMS.
Here is a good article to get you started with doing this in powershell:
Twitter: @SQL_JGood
Blog: sqljgood.wordpress.com/[/url]
June 25, 2013 at 9:11 pm
I do not know too , I will experiment with it tomorrow and will let you know.
[font="Verdana"]
Today is the tomorrow you worried about yesterday:-)[/font]
June 26, 2013 at 8:06 am
Mr. Factor wrote a really good article on administering SQL Servers with CMS. In the article, he writes of the tables that you can use to manage your registered servers:
https://www.simple-talk.com/sql/sql-tools/registered-servers-and--central-management-server-stores/
I have used these tables to automate registration. I also have an email delivered to me when a server is added, so that I can investigate and categorize.
Karl Lambert
SQL Server Database Administration
Business Intelligence Development
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply