Posted by Eswar Koneti on September 22nd, 2012
Ok You are done with installation of Primary / Secondary site and you needed to distributed the packages to site but you want to check if there are any packages missing from its Parent or other site.
Here is simple report list all the packages in comparison with other DP.
select s.SiteCode,s.PackageID,p.Name,(p.sourcesize)/1024 as "size(MB)",s.sourceversion as "Source Version",p.storedpkgversion as PkgVersion,s.Installstatus as ‘Package Status’
from v_PackageStatusDistPointsSumm s
inner join smspackages p on s.packageid = p.pkgid
where s.PackageID not in (select PackageID from v_DistributionPoint where SiteCode=’P01′) and s.SiteCode=’S01′
order by p.SourceSize