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…