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
Posted by at

4 comments:

  1. AnonymousOctober 12, 2013 at 4:18 PM

    Very useful query.

    ReplyDelete
  2. AnonymousDecember 11, 2013 at 4:10 PM

    Useful for weekly SCCM health check thanks.

    ReplyDelete
  3. AnonymousMarch 20, 2014 at 5:44 PM

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

    Thank you!

    PatM

    ReplyDelete
  4. AnonymousAugust 30, 2016 at 9:26 PM

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

    ReplyDelete

Subscribe to: Post Comments (Atom)