Analysis to check if SQL Server is Pimary/Secondary

@jgstew

Will you be able to assist with creating something similar to the analysis provided on this thread? Checking for active/passive node of cluster

Then use ‘MSCluster_ClusterToNode’ to get the ‘RoleOfNode’ as shown on this link: