I am trying to create an SWQL query that shows all volume-related active alerts:
SELECT DISTINCT V.FullName, AA.TriggeredDateTime, AA.TriggeredMessage
FROM Orion.AlertActive AA
JOIN Orion.Volumes AS V ON (AA.AlertObjects.RealEntityUri = V.Uri)
WHERE AA.AlertObjects.EntityType LIKE 'Orion.Volumes' AND AA.AlertObjects.Node.CustomProperties.CustomerID LIKE 'A34' AND AA.AlertObjects.Node.Volumes.Type LIKE 'Fixed Disk'
In SWQL Studio, this query gives me exactly what I want:
But when I use this in my custom table resource, it seems like the distinct does not work. I end up getting a number of duplicates for each server:
The number of duplicated equals the number of monitored disks on each of the servers. Why is the "select distinct" only removing these duplicates in SWQL studio, and not in the custom table resource? Can I change the query in some way to avoid getting these duplicates?