The following SQL query displays all pending content distribution to a specific distribution point. This will display all packages that are not currently in state 0 to a specific distribution point. Replace the name of the distribution point for ‘DPNAME%’.
/* All Content Pending to a Specific DP */ select p.pkgid as 'PKGID', s.installstatus as 'Content Status', p.name as 'Content Name',(p.SourceSize/1024) as 'Content Size(MB)', s.state as 'Content State', substring(servername,0,charindex('.',servername)) as 'DP' from v_PackageStatusDistPointsSumm s join smspackages p on s.packageid = p.pkgid join v_DistributionPointInfo dist on s.ServerNALPath = dist.NALPath where s.state !=0 and ServerName like 'DPNAME%' Order by SourceSize desc, s.installstatus, p.name