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

Leave a Reply