1 of 1 people found this helpful
Does your query have any kind of order by at the end? the Custom Query widget gets mad when you use certain functions and don't tell it how to sort them.
Loop1 Systems: SolarWinds Training and Professional Services
Going off the example I gave above, the following worked for me.
SELECT DISTINCT Caption FROM Orion.Nodes ORDER BY Caption ASC
Do you have more examples like that? I usually tend to play with my query in the SWQL Studio and brute force my way through the errors (I wish it would pass the error directly when it came up), but I wonder how many times I've run into something like this instead of the usual syntactical issues I almost always seem to introduce.