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
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.
1 of 1 people found this helpful
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
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.
tweaked to remove nodeID to give quick totals:
select b.engineid,c.ServerName,COUNT(*) numberOfFailures
from udt_job a,nodes b,Engines c
and b.engineid = c.engineid
and a.JobLastResult = 0
group by b.engineid,c.ServerName