How to exclude clusers

[CrashRider]

I need to exclude clustered servers from a Collection. I tried to do it by not equal to service name "Cluster Service" but it they still showed up.

Thanks,

Codis

 

[tbrennans]

take a look at this and see if it helps..

http://tek-tips.com/viewthread.cfm?qid=955493&page=4

 

[CrashRider]

I get an error when trying to do the exclude systems in another container

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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Roles not like "%Domain_Controller%" and SMS_G_System_SYSTEM.Name not in (select name from SMS_CM_RES_COLL_STE00043)

The last line after Domain_Controller is what I added per the other posts. I'm not sure what I'm doing I don't understand SQL at all.

Codis