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

Version 1

    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