SCCM report packages status on Distribution Point

Report for packages which are Pending:

select s.sitecode,s.packageid,p.name,s.sourceversion as “dpversion”,p.storedpkgversion as latesteversion
from v_PackageStatusDistPointsSumm s
join smspackages p on s.packageid = p.pkgid
where s.installstatus !=’Package Installation complete’
and s.servernalpath like ‘%DPserverName%’
order by s.packageid

Report for packages which are Installed :

select s.sitecode,s.packageid,p.name,s.sourceversion as “dpversion”,p.storedpkgversion as latestversion
from v_PackageStatusDistPointsSumm s
join smspackages p on s.packageid = p.pkgid
where s.installstatus =’Package Installation complete’
and s.servernalpath like ‘%DPSERVERNAME%’
order by s.packageid

Report for packages which are not Targeted but not installed :

Select Sitecode,PackageID,Name,Targeted,INSTALLED from v_PackageStatusDetailSumm where SiteCode =’Sitecode’ and Targeted-Installed >0

Report for total number of packages targetted to Distribution Point :

 

SELECT v_Package.PackageID, Name,    v_DistributionPoint.LastRefreshTime
FROM v_Package INNER JOIN v_DistributionPoint ON v_Package.PackageID = v_DistributionPoint.PackageID
WHERE v_DistributionPoint.ServerNALPath LIKE ‘%DPServerName%’

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

Up ↑

%d bloggers like this: