Report Query for Package Distribution Status on Configuration Manager Distribution Points

Querying Package Distribution Status on Configuration Manager Distribution Points

Rather than clicking through the console one package at a time, you can pull distribution status straight from the Configuration Manager SQL database (or as an SSRS report) to see at a glance which packages have and haven’t made it to a given distribution point.

SELECT PSD.PackageID, PAC.Name, PAC.SourceSite, PSD.State
FROM v_PackageStatusDistPointsSummarizer PSD
INNER JOIN v_Package PAC ON PSD.PackageID = PAC.PackageID

The State column reports a numeric status code (for example, values corresponding to “Installed,” “Install Pending,” “Retrying,” and “Failed”) — cross-reference the specific codes against Microsoft’s Configuration Manager distribution status documentation if you want to map them to their friendly names, since the exact numeric meanings have been documented and occasionally adjusted across different Configuration Manager builds. To build this as a proper SSRS report rather than a one-off query, go to Monitoring > Reporting > Reports in the console, create a new report pointed at your reporting services point, and paste the query in as the dataset.

The Built-In Alternative: Content Status (Updated for 2026)

If you’d rather not write SQL at all, current Configuration Manager (2603) has a dedicated visual view for this built right into the console: Monitoring > Distribution Status > Content Status. Selecting a package shows a graphical breakdown of success/in-progress/error counts across every distribution point it’s targeted to, without needing database access — it’s been Microsoft’s documented primary path for checking distribution status since it was added a few releases back, and it’s still current today. The SQL approach above still has its place for anything you want to script, alert on, or fold into a custom SSRS report, but for a quick at-a-glance check, Content Status is worth reaching for first.

Resources

• query
• How to create a Configuration Manager Report using SSRS
• WQL
• our SQL & WQL query library