SCCM report Count Status of packages on All Distribution Points

In my previous report,we saw complete information about Pending packages,installed packages,Targeted but not installed,total packages targeted to DP

In todays report,we go with count of all packages information at one glance to identify and Fix total number of Packages Distributed out of which how many are installed,Pending Packages.

select dbo.v_SystemResourceList.Servername as "Server Name",
(select count(*)from v_PackageStatusDistPointsSumm where servernalpath = nalpath) as "Total Packages",
(select count(*)from v_PackageStatusDistPointsSumm where installstatus ='Package Installation complete'and servernalpath = nalpath) as "Packages Installed",
(select count(*)from v_PackageStatusDistPointsSumm where servernalpath = nalpath and (installstatus = 'Waiting to install package' or installstatus ='Retrying package installation')) as "Packages Pending"
from dbo.v_SystemResourceList join v_PackageStatusDistPointsSumm
on dbo.v_SystemResourceList.nalpath = v_PackageStatusDistPointsSumm.servernalpath
group by dbo.v_SystemResourceList.servername,dbo.v_SystemResourceList.nalpath

Happy Troubleshooting Smile!

You may also find these useful count-of-packages-available-on-distribution-points

Report Task Sequence Packages available on DP or not

One Response to "SCCM report Count Status of packages on All Distribution Points"

  1. Hello, I would like to know how many applications in a specific environment. This is for Win 10 migrations plan, so how to get the total no of applications deployed together with the details in this environment which is using SCCM 2007. Please help, thank you


Leave a Reply