How to determine SWQL/SQL query behind a Dynamic Query Builder report?

Is there a way to determine the SWQL/SQL query behind a report that's configured like this? We are trying to recreate it through the API on a third-party system. This is the out-of-the-box report "Interface Downtime Summarized - Last 7 Days". I presume the duration in the report is something that is calculated in Solarwinds code rather than SWQL/SQL, but I just need the base query.

Find more posts tagged with

dynamic query builder

report

Accepted answers

Lofstrand

There is no easy way of getting those queries but you can try this rather advanced option.

Try out this query JUST after you ran the report....

SELECT TOP 1000 Host, Login, ApplicationTag, CommandText, StartTime, ElapsedMs, Status, TooplesCount, RowsCount
FROM System.ActiveQuery
WHERE ApplicationTag like '%SolarWinds.Orion.Core.Reporting.DataTableQueryDynamic.Query%'

You can test it first without the WHERE part to get to know the feature. ;-)

All comments

Lofstrand

There is no easy way of getting those queries but you can try this rather advanced option.

Try out this query JUST after you ran the report....

SELECT TOP 1000 Host, Login, ApplicationTag, CommandText, StartTime, ElapsedMs, Status, TooplesCount, RowsCount
FROM System.ActiveQuery
WHERE ApplicationTag like '%SolarWinds.Orion.Core.Reporting.DataTableQueryDynamic.Query%'

You can test it first without the WHERE part to get to know the feature. ;-)

hebron1212

This works! Thanks!