Sccm 2016 collection membership not updating

I can see the workstation is there when I just search for it, but whenver trying to add it through "membership rules", it's not appearing there so, I can't add it.I have already went to the machine and initiated "Discovery Data Collection Cycle" couple of times already, but still I am not able to add it, please suggest how to add it and make it work.This equates to roughly 0.043 seconds for each computer.What would the amount of time be for a larger environment?The below SQL Code is for Collections with count of Direct Membership rule and what type of Collection Schedule configured. Usually for Collections with Direct membership rule, you really no need to configure any Schedule at all as they are one time created and do not require any update. This way you can work on updating your “bad” WQL queries.Below is a screenshot of what you can expect from CEV.

Can you try updating the collection membership manually or refresh so the computer might appear again after discovery cycle?

Looking in the file there was a lot of errors like this:*** exec dbo.sp_Transfer Membership ‘PS100014’, 0 SMS_COLLECTION_EVALUATOR 7392 (0x1CE0) *** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the CHECK constraint "Client Offer Status_Item Key_Partition_CK".

The conflict occurred in database "CM_PS1", table "dbo. : Collection Members_ins_upd_del SMS_COLLECTION_EVALUATOR 7392 (0x1CE0) CCollection Source_SQL:: Refresh Results – could not execute SQL cmd exec dbo.sp_Transfer Membership ‘PS100014’, 0 SMS_COLLECTION_EVALUATOR 7392 (0x1CE0) STATMSG: ID=601 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR_AUXILIARY_EVALUATOR" SYS=Alkapcm001NEW.SITE=PS1 PID=5644 TID=7392 GMTDATE=ma jun 02 .129 2014 ISTR0="exec dbo.sp_Transfer Membership ‘PS100014’, 0" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=0 SMS_COLLECTION_EVALUATOR 7392 (0x1CE0) [Auxiliary Evaluator] Error refreshing collection, will retry momentarily [PS100014, Error 0xb] SMS_COLLECTION_EVALUATOR 7392 (0x1CE0) STATMSG: ID=2511 SEV=E LEV=M SOURCE="SMS Server" COMP="SMS_COLLECTION_EVALUATOR_AUXILIARY_EVALUATOR" SYS=Alkapcm001NEW.SITE=PS1 PID=5644 TID=7392 GMTDATE=ma jun 02 .136 2014 ISTR0="PS100014" ISTR1="" ISTR2="" ISTR3="" ISTR4="" ISTR5="" ISTR6="" ISTR7="" ISTR8="" ISTR9="" NUMATTRS=1 AID0=402 AVAL0="PS100014" SMS_COLLECTION_EVALUATOR 7392 (0x1CE0) Looking at the error message, you will see useful information like the collection id and a conflict.

It turned out that “someone” added a reference to the x64 Unknown computer account and that rule was the causing all the issues.

Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992.

Search for sccm 2016 collection membership not updating:

sccm 2016 collection membership not updating-78sccm 2016 collection membership not updating-11sccm 2016 collection membership not updating-67sccm 2016 collection membership not updating-55

We all know what it’s like to ask another team to review the server and fix, “slowness issues,” so before you do that you should review your Config Mgr setup and make sure first that Now I’m sure many of you are saying that 1.407 seconds is not a lot of time.

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “sccm 2016 collection membership not updating”

  1. So you don't have to worry about sitting through an actual date where you have to ask questions you don't want to hear the answers to and have to worry about her thinking you want to be involved in a serious relationship. I bet we can have fun together really soon ;)”IBite Back_ Adult is the best adult dating site online.