Click on Manage -- Reports, right-click on "Reports" and select New -- Report.
Add a report name and description and select enter SQL sirectly and use something like:
SELECT it.Name AS TaskName,
vc.Name AS ComputerName,
vc.Guid AS ComputerGuid,
st.Status AS TaskStatus,
st.ExitCode AS TaskReturnCode,
st.AttemptTime AS TaskAttemptTime
FROM inv_synch_status st
INNER JOIN vcomputer vc on vc.guid = st._resourceguid
INNER JOIN item it on st.taskid = it.guid
Where st.SynchronizationId in (
SELECT Guid
FROM Item
WHERE Name = 'TaskNameHere')
Order by it.name
Put the name of your task in place of "taskNameHere" above. Click "test" to see if any results are returned. If you like what you see, click "Finish". You will be taken to the report page and you can now schedule this report to run and have it send and email when it does.
RS