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’
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.
If you are helped lend your hand to others : Share it
Published by Vinit Pandey
I am Microsoft Certified Trainer ( MCT) with couple of other certifications including MCSE, MCITP and MCTS. My core technologies are Windows Servers and clients, System Center products including MECM, Intune, Systrack, Nexthink, Yellow.AI, PowerShell, Nomad, Tachyon, Shopping, SCOM, SCVMM, Hyper-V, Failover Clustering and Azure. I have done B.Tech in electronics and communication stream. I have total 15+ experience in IT field. Presently, I am working with Larsen and Toubro Infotech as Experience Architect. My job includes transition, transformation and migration activities which we perform for our esteemed clients. Often I need to provide consultancy to my clients in migration and planning projects.
I am from Chousa (Buxar) which has a lot of historical significance. In my free time I love to blog and play with Shreya (my daughter) and Tiger ( my pet dog).
View all posts by Vinit Pandey