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 !
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/