Sccm query based collections not updating
Sccm query based collections not updating
Here is the first report to know compliance % per collection.
Net Framework 4.0 or newer · Windows 7, Windows 8 or Windows Server 2012 · Administrative Permissions · Power Shell Remoting CORETECH A/S SOFTWARE LICENSE TERMS These license terms are an agreement between Coretech A/S and you. They apply to the software you are downloading from Coretech.dk, which includes the media on which you received it, if any. IF YOU DO NOT ACCEPT THEM, DO NOT USE THE SOFTWARE. You may install and use any number of copies of the software on your devices. You may not · Work around any technical limitations in the binary versions of the software; · reverse engineer, decompile or disassemble the binary versions of the software, except and only to the extent that applicable law expressly permits, despite this limitation; · make more copies of the software than specified in this agreement or allowed by applicable law, despite this limitation; · publish the software for others to copy; · rent, lease or lend the software; · transfer the software or this agreement to any third party; or 3. Any person that has valid access to your computer or internal network may copy and use the documentation for your internal, reference purposes.
Any deployment i have done on this collection has not reached the machine.
I have deleted and recreated the collection and same issue.
Description SCCM Client Actions Tool Power Shell Edition aka Posh CAT is a practical and simple Power Shell application for performing most common day-to-day administrative tasks on System Center 2012 Configuration Manager Clients. If you acquired the software in the United States, Washington state law governs the interpretation of this agreement and applies to claims for breach of it, regardless of conflict of laws principles. If you acquired the software in any other country, the laws of that country apply. This agreement does not change your rights under the laws of your country if the laws of your country do not permit it to do so.
The tool allows running actions remotely on one or more computers simultaneously. The laws of the state where you live govern all other claims, including claims under state consumer protection laws, unfair competition laws, and in tort.
Looking in the file there was a lot of errors like this:*** exec dbo.sp_Transfer Membership ‘PS100014’, 0 SMS_COLLECTION_EVALUATOR 7392 (0x1CE0) *** [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. I have been working with Enterprise client management since 1992.Microsoft Regional Director, Enterprise Mobility MVP. Co-founder of System Center User Group Denmark in 2009.When i check "Collection Properties Membership Rules" I am able to see the two machines which i added with Type "Direct".But when i double click on the collection it does not show anything.The fix is to make sure that “The Device” in all the collections in the Limiting train.