Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm trying to determine if the cluster name is stored in SCCM audit data. I see the host name in [v_R_System], and I'm able to identify cluster nodes here. What I need is the virtual name for the cluster nodes.

share|improve this question

1 Answer 1

up vote 2 down vote accepted
+200

If we are talking about windows clustering and not something else then you can create a MOF file to extend hardware inventory to query the cluster name.

You can use powershell to check the cluster name:

get-wmiobject -class "MSCluster_Cluster" -namespace "root\mscluster" -computername "virtualName" | select -ExpandProperty name

If you have SCCM 2012, an alternative to creating the MOF file is using the "set classes" in the SCCM console.

share|improve this answer
    
Thank you for the suggestion of powershell, but the goal is to get the data out of the SCCM database via T-SQL query. In Cluster Administrator (Failover Cluster Manager) the cluster name resource is what I'm after. Whether the name is for a SQL Server cluster (which is my primary focus) or just the name of the Windows Cluster, I need to get that name and associate it with the node names. I'll check out the set classes method you've listed. –  Eric Higgins Jan 3 at 16:05
1  
@EricHiggins right, then what you'll need to do is to follow the steps to either create the mof file or use the set classes tool. You need to tell SCCM to collect the cluster name from WMI to populate the SCCM database after which you can create your SCCM queries to view the data. –  James Santiago Jan 3 at 16:11
    
I'm sharing this info with my team to determine if we can go the route of custom mof / set classes tool. Would you know what we should enter in the mof file or select in the set classes tool? –  Eric Higgins Jan 6 at 18:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.