Query SolarWinds Database - BlinkOps Documentation

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

Parameter	Description
Parameters	Key-value pairs that correspond to the parameters referenced within the SWQL query. Example: `{ “p”: 9 }`
Query	A 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