SWQL 'DISTINCT' clause not functioning

I'm attempting to get distinct values from an swql query in a custom query widget, but always receive an error after adding the DISTINCT clause.

Example:

SELECT Caption From Orion.Nodes ---> Returns all node names

SELECT DISTINCT Caption From Orion.Nodes ---> "There was an error processing the request"

This doc (https://support.solarwinds.com/SuccessCenter/s/article/Use-SolarWinds-Query-Language-SWQL) states that "SELECT DISTINCT" is supported, but I'm not sure what I'm doing wrong. Any help is appreciated.

Thank you

Find more posts tagged with

swql_widget

Accepted answers

mesverrum

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.

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

All comments

mesverrum

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.

-Marc Netterfield

Loop1 Systems: SolarWinds Training and Professional Services

LinkedIN: Loop1 Systems
Facebook: Loop1 Systems
Twitter: @Loop1Systems

daax7

Thank you!

Going off the example I gave above, the following worked for me.

SELECT DISTINCT Caption FROM Orion.Nodes ORDER BY Caption ASC

jrouviere

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.