[ADR is failing with 0X87D20003 SQl Error]

I have an ADR that failed with 0X87D20003 SQl Error.

I have found this site that has the same error, and its related to a deleted collection or missing collection.

https://sccmnotes.wordpress.com/2019/07/10/automatic-deployment-rule-failing-with-error-0x87d20003/comment-page-1/

I am trying to run a query to identify a missing collection, but getting an error:

declare @ADRName varchar (200) = 'Workstation Updates ADR'
select
   Data.value('(/DeploymentCreationActionXML//CollectionId/node1]', 'nvarchar(max)') CollectionID
 , c.CollectionID
 , c.Name
from RuleActions ra
left join v_Collection c on c.CollectionID = Data.value('(/DeploymentCreationActionXML//CollectionId/node1]', 'nvarchar(max)')
where ra.RuleID = (select AutoDeploymentID from vSMS_AutoDeployments where Name = @ADRName)
and ra.Name = 'DeploymentTemplate'

Msg 2205, Level 16, State 1, Line 7
XQuery [RuleActions.Data.value()]: ")" was expected.

What have i missed in the query? 

I have also checked and all collections are in good state.

Thanks for the help.

 

[Upgrade SilverLight]

Is it possible to upgrade a version of silverlight with patching? Or i need to create a new package to upgrade a version?

Thank you,

[How to retrieve the smstslogs During OSD]

This is an old topic, but i am trying to use during in place upgrade TS and having some issues.

When i run this command:

cmd.exe /c robocopy /mir /z %_smstslogpath% m:\%_smstsmachinename% /copy:dt /NFL /NDL

The %_smstslogpath% is resolving to "c:\windows\sysWOW64\ccm\logs\Smstslog"

However that directory does not exists, I only have "c:\windows\sysWOW64\ccm\logs" at that point.

So my xcopy is failing with exit code 3. Is there any way to use that variable or should i hard code it to c:\windows\ccm\logs?

Thank you.

OSD PHASE	SMSTS.LOG LOCATION
WinPE, Before HD Format	x:\windows\temp\smstslog\smsts.log
WinPE, After HD Format	x:\smstslog\smsts.log
Windows, No SCCM Client Installed	c:\_SMSTaskSequence\Logs\Smstslog\smsts.log
Windows x86, SCCM Client Installed	c:\windows\system32\ccm\logs\Smstslog\smsts.log
Windows x64, SCCM Client Installed	c:\windows\sysWOW64\ccm\logs\Smstslog\smsts.log
Task Sequence Completed x86	c:\windows\system32\ccm\logs\smsts.log
Task Sequence Completed x64	c:\windows\sysWOW64\ccm\logs\smsts.log

[Adding second site to the lab]

I would like to build a second SCCM site in my lab. One is 1706 and i would like to build 1710. Same AD. I just build a new server for CM 1710 and can see that exising server already pushed a client. What would be the best config? Thank you.

[1709 Removing People AppxPackage]

people is not a provisioned package. Only appx. And generating an error on remove. I can remove other appx

's with the same command

 

[1709 Removing People AppxPackage]

Were you able to remove an app? I keep getting an error.

Just need to test adding this to default profile.

[1709 Removing People AppxPackage]

What are we supposed to do? Cant be remove is not an option in an Enterprise.....Why would they include this crap in the OS?

I am looking in CU registry key and setting it as default...

[1709 Removing People AppxPackage]

I just installed 1709 and there are some new appx packages i would like to remove. 

PS C:\WINDOWS\system32> Get-AppxPackage -AllUsers *people* | select name, PackageFullName

Name                                   PackageFullName
----                                   ---------------
Microsoft.Windows.PeopleExperienceHost Microsoft.Windows.PeopleExperienceHost_10.0.16299.15_neutral_neutral_cw5n1h2t.

 

PS C:\WINDOWS\system32> Get-AppxPackage -AllUsers *people* | Remove-AppxPackage

But getting the following error:
Remove-AppxPackage : Deployment failed with HRESULT: 0x80073CFA, Removal failed. Please contact your software vendor.
(Exception from HRESULT: 0x80073CFA)
error 0x80070032: AppX Deployment Remove operation on package

I can remove other packages....

Thanks for the help.

[I need some help with a query]

I need some help with a query to create a collection for Visio Pro and Project Pro 2016 - en-us. When i just query for i am getting results, but when i add en-us i am getting nothing, but i know i have them out there

[How can I use the Upgrade Task Sequence in System Center Configuration Manager (current branch) ?]

Just ran in place upgrade TS. 1703 after upgrade is not usable, have anyone seen this?

[Windows 10 Serice Plan]

I have setup a service plan and started testing. 1607 to 1703.

Just wondering what are the logs i can read to monitor and troubleshoot on the client and server side?

Thank you.

[Windows as a Service WaaS]

I have setup a service plan and started testing. 1607 to 1703.

Just wondering what are the logs i can read to monitor and troubleshoot on the client and server side?

Thank you.

[A deeper look at the Upgrade task sequence in System Center Configuration Manager (Current Branch)]

Nor sure if you are still looking at this. For some reason my logs do not copy to a UpgradeLogs$  share.

Where can i check in the logs what is going on? I dont see anything in smsts.log file. 

Thank you

[How can I forcefully upgrade Windows 7 or Windows 10 to the latest version of Windows 10 using System Center Configuration Manager (Current Branch)?]

$location = Get-ItemProperty "HKLM:SOFTWARE\Microsoft\SMS\Setup" | Select-Object -ExpandProperty "UI Installation Directory"

Resolves to C:\Program Files\Microsoft Configuration Manager\AdminConsole. 

That is the correct registry key. However AdminConsole folder is not in the C:\Program Files\Microsoft Configuration Manager

The Module is only in x86 folder. I changed the registry 'UI Installation Directory' to point to: C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole and script is working after that change.

[How can I use servicing plans in System Center Configuration Manager (Current Branch) to upgrade Windows 10 devices ?]

I am a bit confused about step configuring Updates in the servicing plan.

When i  click on "Preview" i do not see any information:

What have i missed?

Thank you

[Building new TP LAB, and keeping existing environment.]

I have a general question on what would be a best approach to build a tech preview lab. My current lab runs in VM with one DC and one CM/SQL server and few win10/win7 clients. I am currently in CB1610. I would like to install 1702, should i just build a new CM/SQL server and install 1702? Or there is a better way? Thank you.

[How can I install System Center Configuration Manager version 1606 (Current Branch) on Windows Server 2016 with SQL 2016]

Thank you for reply. After SQL installation SQL browser and SQL Server Integration services are not running, is that normal?

Also should i change the log and backup path to a different drive "other then c:\"

Thank you,

[How can I install System Center Configuration Manager version 1606 (Current Branch) on Windows Server 2016 with SQL 2016]

Thanks for another great post.

Just a qq, what are the rights do i need to assign for the created users?

* CM_BA, used for building ConfigMgr created images

* CM_JD, used for joining computers to the domain
* CM_SR used for reporting services

And CM_NAA, a domain user and CM_CP, a domain user just regular user accounts?

 

And do i need to open the ports 1433, 4022 for SQL with this install?

I see ports are open in PS script......Big Thank you.

 

Thank you,

[Disk Space]

I had configured windows 10 servicing plan, and it had pulled lots of data. I have deleted from the console but data still in the packages. How can i clean up the data from There?

 

Thank you,

[Disk Space]

I am running a lab on a home VM. I had 100GB allocated for SCCM server, but now i am running out of space.

I think its due to updates as i have not added any packages or wim files.

The biggest folders i can see are C:\SCCMContentLib\FileLib and my source folder.

I have cleaned up some updates groups and Windows 10 Servicing plan. Dont see any changes to the file system.

Maybe someone can recommend what else i can do or check?

Thank you.

[Creating Compliance Settings in 1610]

Has anyone tired to create a new Compliance Settings in 1610?

 

I am trying to create a setting based on the registry value.

 

1. First problem, for some reason i cant connect to a client from browse registry in the settings tab.

I can ping client, and open \\hostname\c$, but cant connect.

 

2. If i try to browse local registry i do not see a key i am looking for, however i do see that key in the local registry.

 

 

WHat am i missing here?

 

Thank you.

 

 

[Task Sequence failing to Join the Domain.]

Interesting that the issue with failing to join the domain on existing "rebuild" client. I tried with a new VM and it joined domain with no issues.

[Task Sequence failing to Join the Domain.]

This is the only errors i see in the NetSetup.log:

12/10/2016 11:49:09:415 unicodePwd = <SomePassword>

12/10/2016 11:49:09:415 NetpMapGetLdapExtendedError: Parsed [0x5] from server extended error string: 00000005: SecErr: DSID-031A11E5, problem 4003 (INSUFF_ACCESS_RIGHTS), data 0

12/10/2016 11:49:09:415 NetpModifyComputerObjectInDs: ldap_modify_s failed: 0x32 0x5

12/10/2016 11:49:09:415 NetpCreateComputerObjectInDs: NetpModifyComputerObjectInDs failed: 0x5

12/10/2016 11:49:09:415 NetpProvisionComputerAccount: LDAP creation failed: 0x5

12/10/2016 11:49:09:415 NetpProvisionComputerAccount: Retrying downlevel per options

12/10/2016 11:49:09:415 NetpManageMachineAccountWithSid: NetUserAdd on 'AD1.sccmlab.com' for 'WIN10CL001$' failed: 0x8b0

12/10/2016 11:49:09:415 SamOpenUser on 1103 failed with 0xc0000022

Is this related to not able to create a computer account?

Thanks for the help.

I updated the TS to change OU, but now i am missing DP from the "add distribution points" window.

Is this because: If the content is already on the DP, then that DP won't show up in the list.??

Thank you.

[Task Sequence failing to Join the Domain.]

I have Current Branch running as the lab.

Trying to run a win10 TS. It build the OS, but fails to join the domain and fails to install the application.

I have a lot of:

Policy Evaluation failed, hr=0x87d00269

 

Install application action failed: 'VMware Tools'. Error Code 0x87d00269

 

The site is missing from site code and i am not able to tyep one in.

 

I am attaching smsts.log file.

Please let me know if i can provide any more information>?

 

Thank you.

 

Can i attach an image here? When i click on the image i am prompted for URL? Is there a way to attach an image from the local drive?

smsts.log

[How can I deploy Windows 10 with MDT 2013 Update 2 integrated with System Center Configuration Manager (Current Branch)]

Task Sequence finished. But did not joined the domain.

Interesting that c:\windows\sysWOW64\ccm folder is empty and there is no logs folder.

 

Looking at Configuration Manager Properties under site there is no Currently assigned site, Find Site is disabled and i am not able to type one is. Logged in as a local admin.

Under Actions i only see Machine user policy.

 

Do i have client config wrong?