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 .