Query

Query

Certified
Enterprise Edition

Execute a SWQL query against SolarWinds Orion

yaml
type: io.kestra.plugin.ee.solarwinds.ipam.Query
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
DefaultFETCH
Possible Values
FETCH_ONEFETCHSTORENONE
Definitions
allowFailedbooleanstring
Defaultfalse
allowedResponseCodesarray
SubTypeinteger
auth
type*Requiredobject
passwordstring
usernamestring
type*Requiredobject
tokenstring
type*Requiredobject
passwordstring
usernamestring
basicAuthPasswordDeprecatedstring
basicAuthUserDeprecatedstring
connectTimeoutDeprecatedstring
Formatduration
connectionPoolIdleTimeoutDeprecatedstring
Formatduration
defaultCharsetstring
DefaultUTF-8
enabledTcpExtendedKeepAlivebooleanstring
Defaulttrue
followRedirectsbooleanstring
Defaulttrue
logLevelDeprecatedstring
Possible Values
ALLTRACEDEBUGINFOWARNERROROFFNOT_SPECIFIED
logsarray
SubTypestring
Possible Values
REQUEST_HEADERSREQUEST_BODYRESPONSE_HEADERSRESPONSE_BODY
maxContentLengthDeprecatedinteger
proxy
addressstring
passwordstring
portintegerstring
typestring
DefaultDIRECT
Possible Values
DIRECTHTTPSOCKS
usernamestring
proxyAddressDeprecatedstring
proxyPasswordDeprecatedstring
proxyPortDeprecatedinteger
proxyTypeDeprecatedstring
Possible Values
DIRECTHTTPSOCKS
proxyUsernameDeprecatedstring
readIdleTimeoutDeprecatedstring
Formatduration
readTimeoutDeprecatedstring
Formatduration
ssl
insecureTrustAllCertificatesbooleanstring
timeout
connectTimeoutstring
readIdleTimeoutstring
DefaultPT5M
Default17778
Defaulttrue
SubTypeobject
Formaturi