Listed Nodes Different Between Two "Down Node" Resources

bharris1

On my dashboard I am using two different type of "Node Down" resources, the first is the built in one "Nodes with High Response Time or Packet Loss" and another is a custom query that is using a custom sql/swql query that is pretty much just filtering where Status = Down and Device Type = UPS.  The first resource has 5 UPS items listed, while the custom query one only has 1.  The one that is does have IS listed in the built in resource.  Does anyone have any throughts why 4 of the 5 UPS nodes are missing in the custom resource?

Here is the query for the custom one:

SELECT
NodeName AS [Node Name],
'/Orion/images/StatusIcons/Small-' + StatusIcon AS [_IconFor_Node Name],
DetailsUrl AS [_LinkFor_Node Name],Nodes.CustomProperties.Alert_Team AS [Alert Team], Nodes.CustomProperties.Business_Function AS [Business Function], MAX(ToLocal(DOWNEVENT.EVENTTIME)) AS [Down Time]
FROM ORION.NODES NODES
INNER JOIN ORION.EVENTS DOWNEVENT
ON NODES.NODEID = DOWNEVENT.NETWORKNODE
WHERE STATUS = 2 AND Nodes.CustomProperties.Device_Type = 'UPS'
GROUP BY NodeName, StatusIcon, DetailsUrl, Nodes.CustomProperties.Alert_Team, Nodes.CustomProperties.Business_Function
ORDER BY [Down Time] DESC

mesverrum

I'd lay money down that since this is joining to the events table to see when the node went down the 4 missing UPS have been down so long they don't have an entry on the events table anymore, at least 30 days with default settings.

You can probably cover them all by making that inner join to events a left join.