Show all Pending Content Distribution for a Specific Package

The following SQL query displays all pending content distribution for a specific package. This will display all distribution points that are not currently in state 0 for a specific package. Replace the package ID for ‘packageid’ in the where clause. /* Specific Content Pending to All DPs */ select p.pkgid as ‘PKGID’, s.installstatus as ‘Content Status’, p.name as…

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%’. /* All Content Pending to a Specific DP */ select p.pkgid as ‘PKGID’, s.installstatus as ‘Content Status’,…

Show all Pending Content Distribution

The following SQL query display all pending content distribution to all distribution points. This will display all packages that are not currently in state 0. /* All Content in Flight to All DPs */ 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’, Count(substring(servername,0,charindex(‘.’,servername))) as…