在故障转移群集(无avg(上,两个节点,我有两个带有逻辑名称的SQL实例,与计算机名称不同。我需要让侦听器(逻辑(SQL名称连接到一个实例以收集一些库存数据。
我使用get-cluster命令:
import-module failoverclusters
$Clusters = Get-Cluster
foreach ($Cluster in $Clusters)
{
#write-host $Cluster.Name
try
{
$ClusterResources = Get-ClusterResource -Cluster $Cluster
foreach($Resource in $ClusterResources)
{
$Resource
}
}
catch [System.Exception]
{
write-host "!An error occurred!"
}
write-host ""
}
我得到:
Name State Group ResourceType ---- ----- ----- ------------ SQL IP Address 1 (nXXX) Online SQL Server (M_REP1) IP Address SQL IP Address 1 (nYYY) Online SQL Server (M_REP2) IP Address
SQL IP Address 1(nXXX)
是侦听器, SQL SERVER (M_REP1)
实例。
我是否在字符串上进行工作以获取:nXXXM_REP1
或其他方法
SELECT AGS.name AS AGName,
HAGS.primary_replica AS PrimaryInstance
FROM sys.dm_hadr_availability_group_states HAGS
INNER JOIN sys.availability_groups AGS
ON HAGS.group_id = AGS.group_id