
Query
CertifiedEnterprise EditionExecute a SWQL query against SolarWinds Orion
Query
Certified
Enterprise Edition
Execute a SWQL query against SolarWinds Orion
yaml
type: io.kestra.plugin.ee.solarwinds.ipam.QueryExamples
yaml
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
password *Requiredstring
swql *Requiredstring
username *Requiredstring
fetchType string
Default
FETCHPossible Values
FETCH_ONEFETCHSTORENONEoptions Non-dynamic
Definitions
io.kestra.core.http.client.configurations.HttpConfiguration
allowFailedbooleanstring
Default
falseallowedResponseCodesarray
SubTypeinteger
auth
io.kestra.core.http.client.configurations.BasicAuthConfiguration
type*Requiredobject
passwordstring
usernamestring
io.kestra.core.http.client.configurations.BearerAuthConfiguration
type*Requiredobject
tokenstring
io.kestra.core.http.client.configurations.DigestAuthConfiguration
type*Requiredobject
passwordstring
usernamestring
basicAuthPasswordDeprecatedstring
basicAuthUserDeprecatedstring
connectTimeoutDeprecatedstring
Format
durationconnectionPoolIdleTimeoutDeprecatedstring
Format
durationdefaultCharsetstring
Default
UTF-8java.nio.charset.Charset
enabledTcpExtendedKeepAlivebooleanstring
Default
truefollowRedirectsbooleanstring
Default
truelogLevelDeprecatedstring
Possible Values
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIEDlogsarray
SubTypestring
Possible Values
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODYmaxContentLengthDeprecatedinteger
proxy
io.kestra.core.http.client.configurations.ProxyConfiguration
addressstring
passwordstring
portintegerstring
typestring
Default
DIRECTPossible Values
DIRECTHTTPSOCKSusernamestring
proxyAddressDeprecatedstring
proxyPasswordDeprecatedstring
proxyPortDeprecatedinteger
proxyTypeDeprecatedstring
Possible Values
DIRECTHTTPSOCKSproxyUsernameDeprecatedstring
readIdleTimeoutDeprecatedstring
Format
durationreadTimeoutDeprecatedstring
Format
durationssl
io.kestra.core.http.client.configurations.SslOptions
insecureTrustAllCertificatesbooleanstring
timeout
io.kestra.core.http.client.configurations.TimeoutConfiguration
connectTimeoutstring
readIdleTimeoutstring
Default
PT5Mparameters object
pluginDefaultsRef Non-dynamicstring
port integerstring
Default
17778verifySsl booleanstring
Default
trueOutputs
row object
rows array
SubTypeobject
size integer
uri string
Format
uri