2 Replies Latest reply on May 13, 2014 4:18 AM by Deltona

    Windows Scheduled Tasks report for all nodes

    Deltona

      Hi,

       

      I'm trying to figure out how to create a resource that lists all Windows Scheduled Tasks that have failed.

      So far i've confirmed that there is no resource for this and no containers selectable in the Custom Object Resource.

       

      I've found two tables in the database, APM_WstmTask_Detail and WsmTaskResult.

      Could someone with SQL skills kindly join the NodeID in APM_WstmTaskDetail with NodeID in the Nodes table and add Caption?

      Lastly, I'd like a filter to only display tasks where LastRunResult is not equal to 0.

       

      Thanks in advance.