November 2, 2017 at 6:49 am
Hi,
Is there a way to get the File Share Witness physical location using TSQL? I've looked through a number of DMV's and system tables doesn't seem that information or any information relating to FSW is stored in SQL apart from what is in sys.dm_hadr_cluster_members.
Thanks to all who reply
November 2, 2017 at 8:16 am
Since the Quorum and FSW is a Windows Cluster Component, your best bet is PowerShell:
get-clusterresource -cluster sqlcluster | where-object {$_.ResourceType -like “File Share Witness”} | get-clusterparameter
To run it from t-sql, you could use xp_cmdshell ( I know this might be frowned upon)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply