How to check SCCM available packages on DPs Details?

Pull the SCCM Servers list from SCCM Central Database or refer the SCCM Design documents to get the Site servers list.

How to check SCCM available packages on DPs Details?

check SCCM available packages on DPs Details
check SCCM available packages on DPs Details

Also read: How to check clients hardware and WSUS scam health details in SCCM?

Execute the below query:
SQL Query:
——————————-
select dbo.v_SystemResourceList.ServerName as ‘ServerName’,
dbo.v_SystemResourceList.SiteCode,
(select count(*)from v_PackageStatusDistPointsSumm where servernalpath = nalpath) as ‘Targetted’,
(select count(*)from v_PackageStatusDistPointsSumm where installstatus =’Package Installation complete’and servernalpath = nalpath) as ‘Installed’,
(select count(*)from v_PackageStatusDistPointsSumm where installstatus =’Waiting to install package’and servernalpath = nalpath) as ‘Waiting’,
(select count(*)from v_PackageStatusDistPointsSumm where (installstatus =’Waiting to Retry package’or installstatus =’Waiting to remove package’) and servernalpath = nalpath) as ‘Retry+Removing’,
(select count(*)from v_PackageStatusDistPointsSumm where installstatus like’%Fail%’and servernalpath = nalpath) as ‘Failed’,
(select ROUND((100 * (select count(*)from v_PackageStatusDistPointsSumm where installstatus =’Package Installation complete’and servernalpath = nalpath)/(select count(*)from v_PackageStatusDistPointsSumm where servernalpath = nalpath)),2)) as ‘Compliance %’
from dbo.v_SystemResourceList join v_PackageStatusDistPointsSumm
on dbo.v_SystemResourceList.nalpath = v_PackageStatusDistPointsSumm.servernalpath
where dbo.v_SystemResourceList.RoleName = ‘SMS Distribution Point’
group by dbo.v_SystemResourceList.SiteCode,dbo.v_SystemResourceList.servername,dbo.v_SystemResourceList.nalpath order by 1

Donwload Hub site pdf

Download SharePoint Online Tutorial PDF FREE!

Get update on Webinars, video tutorials, training courses etc.

>