Duplicate active alert for the same node in AlertObjects

aycode

I'm using this SWQL to find active alerts on a Node. The UI says the alert is no longer active (having been reset twice) but the SWQL shows it as still active but 4 times in the table:

SELECT
  [AlertObjects].AlertConfigurations.AlertID AS [AlertID]
  ,[AlertObjects].RelatedNodeId AS [RelatedNodeId]
FROM
  Orion.AlertObjects AS [AlertObjects]
WHERE
    RelatedNodeId = 111
AND
    [AlertObjects].AlertActive.AlertActiveID > 0
AND
    [AlertID] = 222

Is the SWQL wrong? It works for all other nodes. Does "reset" not clear AlertActiveID? Does "clear" do that?

aycode

I found a more expressive SWQL here and it turns out the EntityType isn't relevant so the SWQL is working. Just need to limit it to Node EntityType.