Need help to get FQDN using PS command to extract network name resource of a Role running in Failover Cluster Manager

Question

I already have a complex command to get server name of a Role running in my application failover cluster. But now I want to modify it to get FQDN for the same server name in one line.

Below is the command which fetches me the servername. How do I modify it to get FQDN?

(Get-ClusterResource | Where-Object {$.ResourceType.Name -eq "Network Name" -and $.OwnerGroup -eq (Get-ClusterResource | Where-Object {$.ResourceType.Name -eq "Generic Service" -and $.Name -like "Rhapsody*"} ).OwnerGroup.Name}).name

Thanks in advance!!

-Surabhi

Answer 1

Hi @Surabhi Jaiswal ,

Your PowerShell command seems to be missing something as it's not working here.

To get the FQDN, you could refer to the following article:

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Best regards,
Leon

Answer 2

Method I've used:

Get-ClusterResource | Where-Object ResourceType -eq 'Network Name' | Select-Object Cluster, Name, OwnerNode, @{L='FQDN';E={if ($_.Name -match 'SQL Network Name') {[System.Net.Dns]::GetHostByName($_.Name.TrimStart('SQL Network Name (').TrimEnd(')')).HostName} else {[System.Net.Dns]::GetHostByName($_.Cluster).Hostname}}}