Can you register a list of servers with a CSV file in Central managed servers?

• Guy-591148

  Mr or Mrs. 500

  Points: 561

  More actions

  January 12, 2012 at 10:36 am

  #391299

  I know that with CMS (Central management server), you have the abilty to administer multiple servers at a time. I am not finding an option where I can import my list of serers from a simple flat file. Has anyone ever created a group of servers in CMS from a csv file?

  Is XML the only option supported for importing server groups, beside the manual way?

  Thanks

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  January 13, 2012 at 3:57 pm

  #1433587

  You could use PowerShell to grab the contents of the CSV file and update the CMS directly.

  Chad Miller's post will give you 90% of the information to do that http://sev17.com/2009/01/dynamically-register-sql-instances-in-sql-server-management-studio-2008/%5B/url%5D

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• Guy-591148

  Mr or Mrs. 500

  Points: 561

  More actions

  January 16, 2012 at 11:37 am

  #1434212

  I will give this a shot.

  Thank you.

  Messan