SELECT
vpsdps.PackageID,
vp.Manufacturer,
vp.Name,
vp.Version,
vp.Language,
SUBSTRING(vpsdps.ServerNALPath, CHARINDEX('\\', vpsdps.ServerNALPath) + 2, CHARINDEX('"]', vpsdps.ServerNALPath) - CHARINDEX('\\', vpsdps.ServerNALPath) - 3 ) AS DP,
vpsdps.SummaryDate
FROM
v_PackageStatusDistPointsSumm vpsdps
INNER JOIN v_Package vp 
	ON vpsdps.PackageID = vp.PackageID
WHERE
State <> 0
AND 
vpsdps.PackageID in (SELECT DISTINCT PackageID FROM v_TaskSequenceReferenceDps WHERE TaskSequenceID = @tsid)
ORDER BY vpsdps.PackageID