73 reputation
6
bio website TheWorkingDBA.com
location
age
visits member for 1 year, 10 months
seen Jan 9 at 18:24

DBA & SQL Developer. Working w SQL Server since '99 v7. MCSE: Data Platform 2012-2014, MCITP DBA '05 & '08, MCSE (NT 4!)

Everything you do is at your own risk. Duh. :)

Available for short term, 100% remote projects. Specializing in perf tuning and development.


Jan
8
awarded  Scholar
Jan
8
accepted SCCM query for cluster (virtual) name
Jan
6
comment SCCM query for cluster (virtual) name
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?
Jan
3
comment SCCM query for cluster (virtual) name
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.
Dec
27
awarded  Quorum
Dec
18
awarded  Student
Dec
16
awarded  Promoter
Dec
12
asked SCCM query for cluster (virtual) name
Oct
15
awarded  Citizen Patrol
Oct
15
awarded  Supporter