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

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

创新互联主要从事成都做网站、成都网站建设、网页设计、企业做网站、公司建网站等业务。立足成都服务青海,十年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:18980820575

#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"

文章题目：查看Lync前端服务器登录（负载平衡时检查是否成功）
文章路径：https://www.cdcxhl.com/article42/jodeec.html

成都网站建设公司_创新互联，为您提供品牌网站建设、搜索引擎优化、外贸网站建设、网站改版、云服务器、虚拟主机

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联