At present we are utilising modern dashboards to create a "Top xx" style dashboard for each large client.
I've noticed, and don't know how to fix that some of the queries create duplication. So one query we use is a "Nodes Down" and the simple code is:
SELECT a.Caption, a.DetailsURL, c.LastTriggeredDateTime
from Orion.Nodes AS a
JOIN Orion.NodesCustomProperties as b ON a.NodeID = b.NodeID
JOIN Orion.AlertObjects as c ON a.NodeID = c.RelatedNodeID
WHERE Status = '2' AND ClientPrefix LIKE '%ABCDEF%'
but this gives results like:
I've worked out that the offending code is the extra JOIN: [ JOIN Orion.AlertObjects as c ON a.NodeID = c.RelatedNodeID ] but I can't work out how (or where) to pull in the last date the alert triggered without it starting to duplicate.
It's clearly something I'm doing with the code, but I have no clue - any ideas?
p.s. I tried DISTINCT and it makes no difference.
