The most recent content from our members.
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…
Hi, can someone tell me why, if I run this query under a "Query Resource", it will fail with an error: Error: A query to the SolarWinds Information Service failed. However, if I remove the select "DISTINCT", it will run the query? Can you not use the "distinct"? I know I can run this as a custom table, but it just looks…
Is there a way or any plans to include a 'show sql code' function in the report writer as it has numerous limitations, If users could see the code behind the report, then adapt it slightly the report writer would give everyone what they needed..fully customisable!! One problem I have found is that we have duplicate nodes…
It looks like you're new here. Sign in or register to get started.