Hello,
I am looking for report which show me what all alerts associated with each node/objects.
Can anyone help me with the query how to get these details from DB?
Manage to create below query but not showing all alerts assosicated with nodes. Some alerts are missing. Even in alert object some alertID are missing.
SELECT
CASE
WHEN ao.RelatedNodeId IS NULL
THEN 'STANDALONE ALERT'
ELSE ao.RelatedNodeCaption
END AS 'RelatedNodeCaption',
n.Environment,n.AG --this is custom property
acv.Name
FROM AlertObjects ao
JOIN AlertConfigurationView acv ON acv.AlertID = ao.AlertID
LEFT JOIN Nodes n ON n.NodeID = ao.RelatedNodeId
ORDER BY ao.RelatedNodeCaption
Please help me to correct this query which can give all associated alerts.
