Hey,
Just wondering if sub-queries are planned to be supported by SWQL?
Currently, I get
This seems like a big piece of functionality that isn't supported. Sadly I can't use custom SQL in the new modern dashboard so I'm at a bit of a loss currently
The documetation seems to suggest that subqueries are supported:
https://support.solarwinds.com/SuccessCenter/s/article/Use-SolarWinds-Query-Language-SWQL?language=en_US
Common SQL Constructs Supported
SWQL supports the following constructs from SQL:Note: You must use CRUD operations to create, read, update, or delete entities.
Yes it does. Here's a couple examples.
SELECT sub.Caption, sub.Status, nc.LoginStatusFROM ( SELECT n.Caption, n.NodeID, n.StatusFROM Orion.Nodes AS n ) AS subINNER JOIN NCM.Nodes AS nc ON sub.NodeID = nc.CoreNodeID
Here's another one too - https://support.solarwinds.com/SuccessCenter/s/article/Create-an-SLA-report-showing-average-SLA-availability-during-business-hours?language=en_US
Hope this helps!
Could you share the query? I am very interested to see how you would like to use Modern Dashboards.
There are some specific limitations in SWQL but if you post the full query there is usually a work around. The only thing I have to revert to plain SQL for these days is window functions.
