Hello,

How would I change

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

Have it prompt for DP Server Name, so I don't have to edit the bold part above of the report?

Thanks so much,

Mark

Hello,

This question is more related to SQL, you can create a new post in sql forum.

https://social.technet.microsoft.com/Forums/sqlserver/en-us/home?category=sqlserver

To my knowledge, you can build reports .

I believe you are trying this report in SSRS . Follow this URL to create SSRS report https://msdn.microsoft.com/en-us/library/bb522859.aspx with following SQL Quires or you can contact your SQL/SSRS guy to help you on this.

SQL Query:

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  (SUBSTRING(S.ServerNALPath, 13, CHARINDEX('.', S.ServerNALPath) -13 ))=@DPServer
order by s.packageid

more via http://eskonr.com/2012/06/sccm-report-packages-status-on-distribution-point/

Prompt for @DPServer:

SELECT     distinct   SUBSTRING(ServerNALPath, 13, CHARINDEX('.', ServerNALPath) - 13) AS [Server Name], SiteCode FROM   v_PackageStatusDistPointsSumm
order by 1

Thank you so much  Eswar.  I can't put into words how much I appreciate your reports in sccm 2012!!

Mark