"Subqueries are not supported" running queries in EOC

Running queries against table NCM.NodeProperties.  

In regular Orion the query works fine.  Attempting the same query in EOC returns an error:

"Subqueries are not supported". 

No subqueries here. Just a simple SELECT statement against a single table

We recently upgraded our Orion and EOC to version 2022.3.  Using SWQL Studio version

Any insight from the community much appreciated.  Thanks.

Parents Reply
  • Opened a ticket with technical support.

    Solarwinds acknowledges this as a product bug, as detailed below:

    Author: Support Team - Technical Support Address [technicalsupport@solarwinds.com]
    Recipient: robertxxxxxxxxxxxxx

    Hello Robert,  Thank you for your patience, I have heard back from my development team.  My Development team was able to reproduce this issue in our lab.  We have identified it as a BUG in the product; at this time, we do not have a workaround to offer.   Thank you for bringing this to our attention.  Please let me know if this helps or if you require further assistance.  Kind regards, John Wallace, SolarWinds Technical Support  

    For now it appears that queries running against the NCM.NodeProperties table from EOC will fail and return a message "Subqueries are not supported".  These queries will run fine against regular Solarwinds.