查看Lync前端服务器登录（负载平衡时检查是否成功）

#Defined Connection String
$connstring = "server=lync\rtclocal;database=rtcdyn;<br/>trusted_connection=true;" <br/>$connstring2 = "server=lync2\rtclocal;database=rtcdyn;
trusted_connection=true;"

#Define SQL Command

$command = New-Object System.Data.SqlClient.SqlCommand

$command.CommandText = "Select (cast (RE.ClientApp as <br/>varchar (100))) as ClientVersion,
R.UserAtHost as UserName, <br/>Reg.Fqdn
From <br/>rtcdyn.dbo.RegistrarEndpoint RE
Inner Join <br/>rtc.dbo.Resource R on R.ResourceId = RE.OwnerId
Inner Join <br/>rtcdyn.dbo.Registrar Reg on Reg.RegistrarId =
RE.PrimaryRegistrarClusterId `
Order By ClientVersion, UserName "

#Make the connection to Server 1

$connection = New-Object System.Data.SqlClient.SqlConnection
$connection.ConnectionString = $connstring
$connection.Open()

$command.Connection = $connection

$sqladapter = New-Object System.Data.SqlClient.SqlDataAdapter
$sqladapter.SelectCommand = $command

$results = New-Object System.Data.Dataset

$recordcount=$sqladapter.Fill($results)

$connection.Close()

$overallrecords = $overallrecords + $Results.Tables[0]

#Make the connection to Server 2

$connection.ConnectionString = $connstring2
$connection.Open()

$command.Connection = $connection

$results = New-Object System.Data.Dataset
$recordcount=$sqladapter.Fill($results)

$connection.Close()

$overallrecords = $overallrecords + $Results.Tables[0]

#End Section 2

$overallrecords | Export-Csv "PoolDistribution.csv"
Write-Host -ForegroundColor Green "Query complete"

转载于:https://blog.51cto.com/arvinwang/2134559