Cacher is the code snippet organizer for pro developers

SELECT TSP.Name,
       TSRI.*
FROM [SMS_D01].[dbo].[v_TaskSequenceReferencesInfo] AS TSRI
INNER JOIN dbo.v_TaskSequencePackage AS TSP ON TSRI.PackageID = TSP.PackageID
WHERE ReferenceName LIKE '%'
  AND -- ID der Release Tasksequenz
TSP.PackageID LIKE 'D0102CFF'
  AND (ReferenceProgramName LIKE 'Install'
       OR ReferenceProgramName LIKE '*')
ORDER BY Referencename