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:
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.LoginStatus FROM ( SELECT n.Caption, n.NodeID, n.Status FROM Orion.Nodes AS n ) AS sub INNER 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!
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.