#SCCM / #Configmgr Report TS Packages not distributed to DP

In previous post,we saw how to get list of referenced task sequence packages used in Task Sequence which are incomplete.

In this report,we see how to get list of Distribution Points who do not have these referenced packages used in Task Sequence so you know all these sites which do not have package may fail during the OSD Policy check.

Count  : Distribution Points who do not have these packages used in Task Sequence

select sitecode,COUNT(distinct packageID) as [Not Distributed] from v_PackageStatusDetailSumm PSD
where PSD.Targeted='0' and PSd.PackageID in (select ReferencePackageID from v_TaskSequenceReferencesInfo
where PackageID =@TS1)
group by psd.SiteCode
order by psd.sitecode

what Task Sequence Reference packages missing from Which DP :

select PSD.PackageID,PSD.Name,psd.SiteCode,PSD.SiteName,PSD.SummaryDate  from v_PackageStatusDetailSumm PSD
where PSD.Targeted='0' and PSd.PackageID in (select ReferencePackageID from v_TaskSequenceReferencesInfo
where PackageID =@TS1)
Group by PSD.PackageID,PSD.Name,psd.SiteCode,PSD.SiteName,PSD.SummaryDate
order by SiteCode

Prompt for TS1 :

select PackageID,Name from v_TaskSequencePackage

Fix it before you advertise any Task Sequence to Computers .

Post Comment