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’,…