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