In my previous report,we saw complete information about Pending packages,installed packages,Targeted but not installed,total packages targeted to DP
http://eskonr.com/2012/08/sccm-report-count-of-packages-available-on-distribution-points/
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 
!
You may also find these useful count-of-packages-available-on-distribution-points http://eskonr.com/2012/08/sccm-report-count-of-packages-available-on-distribution-points/
1 Comment
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