<#
	AUTHOR:		Derik Hammer
	DATE:		20150507
	LINK:		www.sqlhammer.com/blog/multiple-server-management-finding-the-database-server
#>

#Make sure to update $serverList, server name (data source), and CMS folder (DataCenter1).

Import-Module sqlps -DisableNameChecking

$serverList = Get-Content 'C:\Temp\SqlServers.txt'

$connectionString = "data source=.\sqlexpress;initial catalog=master;integrated security=sspi;"
$sqlConnection = New-Object ("System.Data.SqlClient.SqlConnection") $connectionstring
$conn = New-Object ("Microsoft.SQLServer.Management.common.serverconnection") $sqlconnection
$cmsStore = New-Object ("Microsoft.SqlServer.Management.RegisteredServers.RegisteredServersStore") $conn
$cmsRootGroup = $cmsStore.ServerGroups["DatabaseEngineServerGroup"].ServerGroups['DataCenter1']

foreach($server in $serverList)
{

    $RegServerName = $server
    $RegServerInstance = $RegServerName
    $NewServer = New-Object Microsoft.SqlServer.Management.RegisteredServers.RegisteredServer($cmsRootGroup, "$RegServerName")
    $NewServer.SecureConnectionString = "server=$RegServerInstance;integrated security=true"
    $NewServer.ConnectionString = "server=$RegServerInstance;integrated security=true"
    $NewServer.ServerName = "$RegServerInstance"
    $NewServer.Create()

}