how to retrieve the SQL serverand instance name for any back-end pool database
1. Get-CsService -Registrar -Pool Fqdn <poolFqdn> (poolFqdn = Fqdn of the pool you want)
2. Get-CsService -UserServer –PoolFqdn <poolFqdn> (note the “UserDatabase” property for step #3)
3. Get-CsService -UserDatabase –PoolFqdn <use the UserDatabase property from step #2>
The SQL user database for the pool is the SqlServer property appended with the \SqlInstance property.
PS C:\> Get-CsService -Registrar -PoolFqdn lchlncpool01.labbsci.labbossci.com
Identity : Registrar:lchlncpool01.labbsci.labbossci.com
MonitoringServer :
ArchivingServer :
WebServer : WebServer:lchlncpool01.labbsci.labbossci.com
EdgeServer :
UserServer : UserServer:lchlncpool01.labbsci.labbossci.com
SipPort : 5061
WebPort : 444
SipHealthPort :
SipServerTcpPort :
EnableAutomaticFailover : True
FailbackDetectionInterval : 00:10:00
FailureDetectionInterval : 00:05:00
BackupRegistrar : Registrar:lrolncpool01.labbsci.labbossci.com
DependentServiceList : {MediationServer:lchlncpool01.labbsci.labbossci.com
, ApplicationServer:lchlncpool01.labbsci.labbossci.
com}
ServiceId : 2-Registrar-1
SiteId : Site:STP 2 Lab
PoolFqdn : lchlncpool01.labbsci.labbossci.com
Version : 5
Role : Registrar
PS C:\> Get-CsService -UserServer -PoolFqdn lchlncpool01.labbsci.labbossci.com
Identity : UserServer:lchlncpool01.labbsci.labbossci.com
UserDatabase : UserDatabase:lchlncdbl01.labbsci.labbossci.com
ConferenceServer : ConferencingServer:lchlncpool01.labbsci.labbossci.c
om
MediaOnlyConferenceServer :
McuFactorySipPort : 444
DependentServiceList : {Registrar:lchlncpool01.labbsci.labbossci.com, WebS
erver:lchlncpool01.labbsci.labbossci.com, Conferenc
ingServer:lchlncpool01.labbsci.labbossci.com}
ServiceId : 2-UserServices-1
SiteId : Site:STP 2 Lab
PoolFqdn : lchlncpool01.labbsci.labbossci.com
Version : 5
Role : UserServer
PS C:\> Get-CsService -UserDatabase -PoolFqdn lchlncdbl01.labbsci.labbossci.com
Identity : UserDatabase:lchlncdbl01.labbsci.labbossci.com
SqlInstanceName : lab
DependentServiceList : {UserServer:lchlncpool01.labbsci.labbossci.com}
ServiceId : 2-UserStore-1
SiteId : Site:STP 2 Lab
PoolFqdn : lchlncdbl01.labbsci.labbossci.com
Version : 5
Role : UserDatabase
PS C:\>