
SolarWinds Orion Query
CertifiedEnterprise EditionExecute a SWQL query against SolarWinds Orion
SolarWinds Orion Query
Execute a SWQL query against SolarWinds Orion
Runs an arbitrary SolarWinds Query Language (SWQL) statement against the SWIS REST endpoint and returns results according to the chosen fetchType.
SWQL is a SQL-like language for querying Orion entities. Bind parameters can be passed as a map; reference them in the query as @ParamName.
type: io.kestra.plugin.ee.solarwinds.ipam.QueryExamples
List all IPAM subnets with their utilization.
id: swql_list_subnets
namespace: company.team
tasks:
- id: query
type: io.kestra.plugin.ee.solarwinds.ipam.Query
host: "{{ secret('SOLARWINDS_HOST') }}"
username: "{{ secret('SOLARWINDS_USER') }}"
password: "{{ secret('SOLARWINDS_PASSWORD') }}"
swql: |
SELECT SubnetId, Address, CIDR, FriendlyName, Used, Available, TotalCount
FROM IPAM.Subnet
WHERE GroupId = @groupId
parameters:
groupId: 1
fetchType: STORE
Properties
host *Requiredstring
SolarWinds Orion host
Hostname or IP address of the SolarWinds Orion server. Must be reachable from the Kestra worker.
password *Requiredstring
Password
Password for the SolarWinds Orion account. Masked in logs.
swql *Requiredstring
SWQL query
SolarWinds Query Language statement to execute. Use @ParamName placeholders for bind parameters.
username *Requiredstring
Username
SolarWinds Orion account used for HTTP Basic authentication.
fetchType string
FETCHFETCH_ONEFETCHSTORENONEFetch type
Controls how results are returned:
FETCH_ONE: returns the first row as an inline map.FETCH: returns all rows inline (suitable for small result sets).STORE: writes all rows to Kestra internal storage as an ION file (recommended for large datasets).NONE: discards results.
options Non-dynamic
HTTP client configuration
Optional HTTP client overrides such as timeouts or proxy settings. Uses platform defaults when omitted.
io.kestra.core.http.client.configurations.HttpConfiguration
falseIf true, allow a failed response code (response code >= 400)
List of response code allowed for this request
The authentication to use.
io.kestra.core.http.client.configurations.BasicAuthConfiguration
The password for HTTP basic authentication.
The username for HTTP basic authentication.
io.kestra.core.http.client.configurations.BearerAuthConfiguration
The token for bearer token authentication.
io.kestra.core.http.client.configurations.DigestAuthConfiguration
The password for HTTP Digest authentication.
The username for HTTP Digest authentication.
The password for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.
The username for HTTP basic authentication. Deprecated, use auth property with a BasicAuthConfiguration instance instead.
durationThe time allowed to establish a connection to the server before failing.
durationThe time an idle connection can remain in the client's connection pool before being closed.
UTF-8The default charset for the request.
java.nio.charset.Charset
trueWhether to enable TCP Keep-Alive extended socket options (TCP_KEEPIDLE, TCP_KEEPINTERVAL, TCP_KEEPCOUNT).
Set to false when running on Windows workers, as these extended socket options are not supported by the Windows JDK and will cause connection failures.
trueWhether redirects should be followed automatically.
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIEDThe log level for the HTTP client.
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODYThe enabled log.
The maximum content length of the response.
The proxy configuration.
io.kestra.core.http.client.configurations.ProxyConfiguration
The address of the proxy server.
The password for proxy authentication.
The port of the proxy server.
DIRECTDIRECTHTTPSOCKSThe type of proxy to use.
The username for proxy authentication.
The address of the proxy server.
The password for proxy authentication.
The port of the proxy server.
DIRECTHTTPSOCKSThe type of proxy to use.
The username for proxy authentication.
durationThe time allowed for a read connection to remain idle before closing it.
durationThe maximum time allowed for reading data from the server before failing.
The SSL request options
io.kestra.core.http.client.configurations.SslOptions
Whether to disable checking of the remote SSL certificate.
Only applies if no trust store is configured. Note: This makes the SSL connection insecure and should only be used for testing. If you are using a self-signed certificate, set up a trust store instead.
The timeout configuration.
io.kestra.core.http.client.configurations.TimeoutConfiguration
The time allowed to establish a connection to the server before failing.
PT5MThe time allowed for a read connection to remain idle before closing it.
parameters object
Bind parameters
Named bind parameters referenced in the SWQL query as @ParamName. Values can be strings, numbers, or booleans.
pluginDefaultsRef Non-dynamicstring
Reference (ref) of the pluginDefaults to apply to this task.
port integerstring
17778SWIS port
TCP port of the SolarWinds Information Service REST endpoint. Defaults to 17778.
verifySsl booleanstring
trueVerify SSL certificate
When false, disables TLS certificate verification. Useful when Orion uses a self-signed certificate.
Defaults to true (secure).
Outputs
row object
First result row (FETCH_ONE mode)
rows array
All result rows (FETCH mode)
size integer
Number of rows returned
uri string
uriInternal storage URI containing results as ION (STORE mode)