How to check SCCM available packages on DPs Details?

check SCCM available packages on DPs Details
InfoPath alternatives for form designing SharePoint

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

Similar SharePoint 2013 Tutorials

About Ramu Rao

I have been working as a Team Lead in IT last 6 years with a strong focus on Microsoft Server Technologies I have been working on Windows Server 2008, 2008 R2, 2012 & SCCM 2012 R2 etc. Interested in everything related to Configuration Manager & Windows Azure. Keep learning Keep sharing and keep growing !!

View all posts by Ramu Rao →

Leave a Reply