Use Report Server to Build Your Notification Server Reports - Software Delivery Task Execution

Use this query to get software delivery task information. You can put in your own Where criteria.

If you use with Business Dev Studio use a report parameter so it will prompt you to choose the filter.

Where (b.AdvertisementName IN (@AdvertisementName))

SELECT b.AdvertisementName, a.Name, a.[User], a.[OS Name], a.[OS Version], a.IsManaged, b.ReturnCode, a.Guid

FROM vComputer AS a 
INNER JOIN Inv_AeX_SWD_Execution_Summary AS b ON a.Guid = b._ResourceGuid

WHERE b.AdvertisementName like '%' and b.ReturnCode = '0'

ORDER BY b.AdvertisementName, a.Name