Collection query to populate all servers that are cluster nodes?
Has anyone created a collection using a query that queries for servers that are only clusters?
January 14th, 2011 11:48pm

I don't think anything is captured by default that is specific to clusters but there are a whole set of WMI classes present on cluster nodes that you could easily add to sms_def.mof to collection relevant information: http://technet.microsoft.com/en-us/library/cc780572(WS.10).aspx.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2011 11:05am

I think I've developped a query that will work. Have a look: select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SERVICE on SMS_G_System_SERVICE.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SERVICE.DisplayName like "Cluster Service"
January 15th, 2011 5:29pm

Yes, that should work except for the "like" operator. You should only use the like operator if you are using a wildcard which you are not in this case so you should use = instead.Jason | http://myitforum.com/cs2/blogs/jsandys | http://blogs.catapultsystems.com/jsandys/default.aspx | Twitter @JasonSandys
Free Windows Admin Tool Kit Click here and download it now
January 15th, 2011 6:31pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics