Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

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

Find more posts tagged with

Accepted answers

All comments

pratikmehta003

Hi petersent‌

Does this work? I mean have you tested this as i m looking for a similar information from long time.

petersent

Yes it does work. Now I am running 10.6.1 but it does pull the UDT info out correctly

pratikmehta003

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.