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 DocumentationTo 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
Workflow LibraryPreview this Workflow on desktop