Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.
Endpoint Management Community Blog

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

Created: 29 Jul 2008 • Updated: 29 Jul 2008
networkchic's picture
0 0 Votes
Login to vote

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