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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s