MVP Track

Under Track in the MMS Session select "MVP Track" Here you will see the Self-pace labs. I think it would be great if we could see the MVP Sessions as well. I am finishing up my lab and putting the final touches on my presentation. Hope it all goes well. See you at MMS 2012!!!

Something new for MMS 2012: MVP Labs

This year like many past MMS experiences, Microsoft is adding new items. This year in particular is very cool in deed. For the first time MVPs are allowed to create Self-paced labs. I am creating a 15 min lab on an introduction to Console Extensions in 2012. This compliments my session on Console Extensions. The labs are listed on the Speakers bio and soon should be listed for the attendees to sign up. The MVPs just need to get everything done and working. My Lab: MV-L306 Creating Console Extensions for ConfigMgr 2012

Packages referenced by a specific task sequence that are Missing

So you have many task sequences but when you setup a DP you need to know if that DP is ready for that Task sequence. There are reports for Packages on a DP, Packages for a Task Sequence but here is a report that will tell you what packages are missing from the DP for the specific task sequence.

The current draw back is that this report doesn't check to makes sure the package is already installed, just deployed so I will update that soon. But here you go. Hope this helps with some deployments.



---------------------
TaskSequenceID = Task Sequence ID
ID = Distribution point ID

-----------------------------------------
SELECT ps.Name AS Name
, ps.SourceVersion
, ps.SourceDate
, ps.SourceSize
, ps.SourceCompressedSize
, ps.PackageID
FROM
(
SELECT DISTINCT v_TaskSequenceReferencesInfo.ReferencePackageID AS PackageID
FROM v_TaskSequenceReferencesInfo
WHERE v_TaskSequenceReferencesInfo.PackageID=@TaskSequenceID
) RefPkgs
JOIN v_PackageStatusRootSummarizer ps ON ps.PackageID = RefPkgs.PackageID
where RefPkgs.PackageID not in (SELECT v_Package.PackageID
FROM v_Package
INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID
WHERE v_DistributionPoint.ServerNALPath LIKE '%' + @ID + '%')
ORDER BY ps.Name