Symantec Management Platform (Notification Server)

 View Only

  • 1.  SQL query Jobs/Tasks sort by "Start Time"

    Posted Jul 20, 2016 11:41 AM

    I am trying to query Jobs/Tasks to see what has not been delivered in X number of days, in order to do some clean up.

    Maybe sort by "Start time" We have mix of scripts, package and quick delivery.

    Thanks for any help.
     



  • 2.  RE: SQL query Jobs/Tasks sort by "Start Time"

    Posted Jul 21, 2016 03:52 AM

    Take a look at a number of tables:

    • TaskInstances
    • TaskInstanceSummaries
    • TaskInstanceResultSummaries
    • TaskInstanceResults

    Linked on 'TaskInstanceGuid'