Once you are done with installation/configuration of the sites/Distribution Point,you start distributing the content to it.sometimes you may have to check if the site which you configured has all the content that serve for clients to receive packages. For this,you can compare the newly configured server with already existing server which has all the content including packages,drivers,SUP ,OSD etc .
Here is simple report compare the list of packages missing from newly configured server:
sccm2012sec is considered as base server which has all the content in it
sccm2012nor is newly configured one
select s.SiteCode,s.PackageID,p.Name,(p.sourcesize)/1024 as "size(MB)",s.sourceversion as "DPVersion",p.storedpkgversion as Latversion,s.Installstatus as 'Package Status',
When 0 Then 'Package'
When 3 Then 'Driver'
When 4 Then 'Task Sequence'
When 5 Then 'software Update'
When 7 Then 'Virtual'
When 8 Then 'Application'
When 257 Then 'Image'
When 258 Then 'Boot Image'
When 259 Then 'OS'
Else ' '
END AS 'Type'
from v_PackageStatusDistPointsSumm s
inner join smspackages p on s.packageid = p.pkgid
inner join v_Package on v_Package.PackageID=p.[PkgID]
where s.PackageID not in (select PackageID from v_DistributionPoint where ServerNALPath like '%sccm2012nor%') and ServerNALPath like '%sccm2012sec%'
order by 8
To distribute the missing packages,use the powershell script via http://eskonr.com/2013/11/configmgr-2012powershell-script-add-packages-applicationsdrivers-to-distribution-point/