Jump to content


  • 0
Kevin79

Computer not being added to collection

Question

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?

Share this post


Link to post
Share on other sites

4 answers to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites

Join the conversation

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

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.