This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

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

Parents
  • Thanks a lot petersent

    Worked for me as well. I had searched a lot in community regarding this but got to know that there is no way to figure this out except log files.

    This would help me in keeping tab for the failure status. Actually i also have a case opened since m getting a notfication for UDT jobs failing again and again.

    Support engineer after checking has recommended to repair the UDT services once and see since the jobs are getting completed as per the log files.

Reply
  • Thanks a lot petersent

    Worked for me as well. I had searched a lot in community regarding this but got to know that there is no way to figure this out except log files.

    This would help me in keeping tab for the failure status. Actually i also have a case opened since m getting a notfication for UDT jobs failing again and again.

    Support engineer after checking has recommended to repair the UDT services once and see since the jobs are getting completed as per the log files.

Children
No Data