Client Task Execution Report?
Does anyone have the SQL for a Client Task Execution Report from NS 7.1? I'm looking for info on Client Task Agent executions, not Software Management Delivery... There are reports for Software Management that work great. However, none of the built in task reports return what I need and trying to figure out the columns in the 10+ tables in which task info seems to be captured has me befuddled. In short I need a report that will list the following: 1. Client computer on which the task ran (not the task server which most of the built in reports seem to return), 2. Task name. 3. Task execution status. Success or failure would be great but simple return codes would be OK. 4. Execution time, preferably end time.
I need this for an upcoming mass deployment so we can schedule reports proactively to capture task failures or non-execution on client computers before the users come in in hopes of resolving the issues prior to their arrival.