Skip to content

Computer not being added to collection

Featured Replies

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?

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!! :)

  • Author

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")

  • Author

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

 

Correct.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.