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

5 comments:

  1. I love your site! You will be in our prayers and thoughts! Nice and informative post
    on this topic thanks for sharing with us.Thank you
    epoxy coatings

    ReplyDelete
  2. Very useful query.

    ReplyDelete
  3. Useful for weekly SCCM health check thanks.

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

    Thank you!

    PatM

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

    ReplyDelete