6 Replies Latest reply on Jun 12, 2018 4:42 PM by njoylif

    UDT SQL script to quickly identify which poller servers have UDT jobs that have not finished

    pratikmehta003

      Thought of sharing this query which helps in identifying the status of UDT polling jobs which have failed. Got this from petersent. So just reporsting it so that others can also know about.

       

      use NetPerfMon;
      select b.nodeid,b.engineid,c.ServerName,COUNT(*) numberOfFailures
      from udt_job a,nodes b,Engines c
      where a.NodeID=b.nodeid
      and b.engineid = c.engineid
      and a.JobLastResult = 0
      group by b.nodeid,b.engineid,c.ServerName