Retrieve specific data from the SolarWinds database by providing a custom SWQL (SolarWinds Query Language) query.

You can either enter a simple query directly or use a referenced query that leverages the Parameters field.

Examples:

Query without parameters:

SELECT Uri FROM Orion.Pollers ORDER BY PollerID WITH ROWS 1 TO 3 WITH TOTALROWS

Query with parameters

SELECT Uri FROM Orion.Pollers WHERE PollerID=@p ORDER BY PollerID WITH ROWS 1 TO 3 WITH TOTALROWS

External Documentation

To learn more, visit the SolarWinds Information Service documentation.

Parameters

ParameterDescription
ParametersKey-value pairs that correspond to the parameters referenced within the SWQL query.Example:{ "p": 9}
QueryA custom SWQL (SolarWinds Query Language) query to retrieve data based on specified criteria. The query may include parameter references, which should then be inserted into the Parameters field.Example:SELECT Uri FROM Orion.Pollers WHERE PollerID=@p ORDER BY PollerID WITH ROWS 1 TO 3 WITH TOTALROWS

Example Output

{
	"results": [
		{}
	],
	"totalRows": 0
}

Workflow Library Example

Query Solarwinds Database with Solarwinds Information Service and Send Results Via Email

Preview this Workflow on desktop