Thursday, May 23, 2013

SCCM Report for Distribution Points - Package Status

This query gives all the packages status on all the Distribution Points

****************************************************************

SELECT DPS.PackageID, PCK.Name, PCK.SourceSite, 
DPS.ServerNALPath, DPS.InstallStatus
FROM v_PackageStatusDistPointsSumm DPS INNER JOIN v_Package PCK
ON DPS.PackageID = PCK.PackageID
ORDER BY DPS.PackageID
****************************************************************


More SCCM custom reports can be found here

4 comments:

  1. Very useful query.

    ReplyDelete
  2. Useful for weekly SCCM health check thanks.

    ReplyDelete
  3. Hello, do you have query for specific package on ALL distribution points?
    Perhaps the specific package appear as prompt.

    Thank you!

    PatM

    ReplyDelete
  4. Hi , Need query for specific package on ALL distribution points?
    Perhaps the specific package appear as prompt.

    ReplyDelete