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

I also found once you find the servers that have the backed up udt jobs all you need to do is restart the solarwind's services on those servers.  It might take a bit of time but eventually those jobs reduce to 0

Hi petersent‌

Wonderful. It actually worked. Over the weekend, the polling engine which was reporting these failure was rebooted and today i dont see any of those messages nor the older dates which were visible earlier.

Not sure how the Support engineer didnt know about this.

Thank you so much for your inputs :-)

This might be a stupid question but you are running this query where??????

SQL management studio?

I am asking because I am having this same issue and I want to see what pollers are causing the error.

query message error:

Msg 911, Level 16, State 1, Line 1

Database 'NetPerfMon' does not exist. Make sure that the name is entered correctly.

I ran it in report writer and then got it auto scheduled...

By any changes the Db name is different? Coz that's what the error is

pointing abt

DB name isn't different I was running in management studio.  We had to move devices to the 4 APs that we were trying to not use to stop all the slowness everyone was experiencing. I am going to try and run that in report writer just so I know.

Thank You.

tweaked to remove nodeID to give quick totals:

use NetPerfMon;

select 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.engineid,c.ServerName