Computer not being added to collection

[Kevin79]

I have a computer (could be more, not sure) that isn't being added to a collection that it should be. I have a collection that looks for membership of a different collection and if it isn't, it is added to this collection. The computer is NOT a member of the second collection so it should be part of the first collection. For some reason, it isn't adding itself though. I've force the collection update many times and waited over a day but it isn't added. What logs should I look at to find out why it isn't being added?

[glen8]

how did you create a collection to add machines not in another collection? This is just what I need to setup on our server

 

Thanks!!

[Kevin79]

Here is my query. The last part tells it to only add computers that aren't in the other collection (The collectionID is HOL00021)

 

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 where SMS_R_System.SystemGroupName = "GroupName" and SMS_R_System.ResourceId not in (select ResourceID from SMS_FullCollectionMembership where CollectionID = "HOL00021")

[Peter van der Woude]

So besides not being in collection HOL00021 the computer is also member of "GroupName"?

[Kevin79]

So besides not being in collection HOL00021 the computer is also member of "GroupName"?

 

Correct.