sccm report packages status on Distribution Point

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 Responses to "sccm report packages status on Distribution Point"

  1. 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.

    Reply
    1. 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

      Reply
  2. 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.

    Reply
  3. 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.

    Reply
    1. 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.

      Reply
  4. 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

    Reply

Leave a Reply to Nadeem Cancel reply