Scheduled Tasks query using SQL query

Version 6

    Verified Product Versions

    LANDESK Management Suite 9.5

    Since there's no easy way to see all Scheduled Tasks, I wrote the attached query. Please let me know if there are any questions. I've written some other really useful queries, and I will try to post them as time permits.

     

    NOTES:

    • Don't forget to change the current database (in whatever query tool you're using) to the Landesk database.

    • It's possible there may be either NO or MULTIPLE queries assigned to a task ... which is why I used sub-selects, and only selected the first (or "top") query. Query Count will tell you how many queries are assigned to one task.

    • Here's what some of the codes mean:
       
      TASK STATUS:
      0 server tasks? 
      1 working 
      3 Failed 
      4 scheduler service stopped 
      5 completed 
      6 partially completed 
      7 none completed 
      8 failed 
      9 not started yet 
      12 available for download 
      14 in progress?
       
      DELIVERY METHOD:
      1 = multicast 
      2 = push/policy 
      3 = push 
      4 = policy
       
      PACKAGE TYPE:
      2 = MSI 
      4 = EXE 
      5 = BAT
      (we don't use any others, so I don't know what the codes are for SWD, etc.)