3 Replies Latest reply on Nov 25, 2019 1:31 PM by mesverrum

    SWQL 'DISTINCT' clause not functioning

    daax7

      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