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?
Solved! Go to Solution.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.