Show all Pending Content Distribution to a Specific DP

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%’.

DPstatus

/* 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