sccm report packages status on Distribution Point
Posted by Eswar Koneti on June 2nd, 2012
Previous report list the packages which are successfully distributed to Distribution Points http://eskonr.com/2012/06/sccm-report-total-number-of-packages-targeted-to-dp/
This post gives you more information about package status for selected 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%’
January 16th, 2013 at 12:27 AM
How can I post this inside of standard SCCM webreporting done through the console?
January 16th, 2013 at 7:58 AM
are you referring to SSRS reports ?
you can create new report from SSRS and past the query into it.
January 25th, 2013 at 1:18 AM
Hi,
Could you please help in getting SCCM report Count packages with no advertisements. in this we need package Details like Package Name with ID and Versions of it.
Please help me in getting this report
Thanks in advance,
Regards
Dhivakar
January 25th, 2013 at 7:17 AM
http://eskonr.com/2012/08/sccm-report-count-packages-with-no-advertisements/