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%'
9 Comments
is there any way to have a report where packages are pending but not in waiting for prestaged content. i'm only interested in processing content status.
Hi Naveen,
If you have infra with packages enabled with prestate option ,then you can look at SQL views to find the information and create report for it.
I am sure, the package properties information stored in SQL hence you can create report with it.
Thanks,
Eswar
Hi,
Is it possible to create a report to show the version of a package/application on a Distribution Point and compare it to the version on the Primary site.
Nadeem.
Hi,
Is it possible to create a report to show the version of a package/application on a Distribution Point and compare it to the version on the Primary site.
you can check the default reports to check the status of packages/apps on the dp's.if the package is installed successfully,the version must be same else package is failure or has issues and it requires some troubleshooting.
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
http://eskonr.com/2012/08/sccm-report-count-packages-with-no-advertisements/
How can I post this inside of standard SCCM webreporting done through the console?
are you referring to SSRS reports ?
you can create new report from SSRS and past the query into it.