SCCM, Troubleshooting SCCM

SCCM query to check Task Sequence variables not present on a Distribution Point during OSD

Hello Friends

This post is quick query which is very handy during operating system deployment (OSD). At times we do OSD in multi-site environment and all the variables of task sequence are not present on local DP, resulting in failure of task sequence. You need to distribute all the variables to local DP for running task sequence. So how will you know which all variables are not distributed yet? You can run below query for the purpose:

select ReferencePackageID from v_TaskSequenceReferencesInfo where PackageID =’xxx’
except
select PackageID from v_PackageStatusDistPointsSumm where ServerNALPath='[“Display=yyy]

Replace xxx with package id of task sequence and yyy with ServerNALPath of DP. How you will find ServerNALPath? Just run

select * from v_PackageStatusDistPointsSumm

and it will list all ServerNALPath. Copy the DP you are looking for. Easy, isn’t it ? 🙂

So, this is all in this post. I will be back with some other technical posts. Stay tuned.

Unknown's avatar

Published by Vinit Pandey

I’m a Microsoft Certified Trainer (MCT) with over 18 years of experience in the IT industry, backed by certifications including MCSE, MCITP, and MCTS. My core expertise lies in AI, Windows Server and Client platforms, and a wide range of endpoint and infrastructure management tools such as System Center (MECM, SCOM, SCVMM), Intune, Systrack, Nexthink, Yellow.AI, PowerShell, Nomad, Tachyon, and Shopping. I also have hands-on experience with virtualization and high availability technologies like Hyper-V and Failover Clustering, as well as cloud platforms like Microsoft Azure. I hold a B.Tech degree in Electronics and Communication and currently serve as Associate Director at LTIMindtree, where I lead Digital Experience initiatives. My role involves driving transition, transformation, and migration programs for global clients, often providing strategic consulting on planning and execution. Originally from Chousa (Buxar), a place rich in historical significance, I enjoy blogging in my spare time and love spending quality moments with my daughters, Shreya and Reet, and our pet dog, Tiger.

Leave a comment