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