Allow any valid SWQL query to be a dynamic query in a group

m-milligan

Right now there are two ways to add items to a Solarwinds Group: You can add individual items or you can create a Dynamic Query using the query builder tool. The query builder doesn't support a lot of the queries I'd like to use.

I should be able to use any valid SWQL to create a dynamic query. For example, if I want to create a dynamic query that includes all Application entities where the Application's Node entity has a custom property called "Department" with a value of "Student Finance," I should be able to create dynamic query with the SWQL:

SELECT A.ID 
from Orion.APM.Application A 
where A.Node.CustomProperties.Department = 'Student Finance'

 

adrianthompson

Would actually make dynamic queries 'dynamic' by incorporating more selection criteria, filtering, reference to custom properties and logic, e.g. AND, OR, NOT, LIKE.