Execute SWQL Query

The plugin is designed to execute Solarwinds SWQL queries

Prerequisites:
In addition to the general perquisites mentioned at SolarWinds plugin level, SWQL studio.

No.	Field Name	Description
1	Step Name	Name of the step. This name has to be unique in a single workflow.
	Connection:
2	Server Name	Provide the SolarWinds instance name, IP address, or hostname.
3	Port	The port number of the SolarWinds instance should be provided. Port number should only be an integer.
4	Username	The username of the SolarWinds instance to authenticate.
	Password:
5	Checkbox: Accept Value as variable/static	Leave the checkbox unchecked to accept the Password value from a field in the previous steps of the stream using a drop-down list. Else, enable the checkbox for the Password field to appear as a text box.
6	Password	The password for the specified username to authenticate. Password is encrypted and not stored in the `.psw` file. Password is entered using a widget. The widget handles both Text Var (static value or environment variable) and Combo (drop-down containing values from previous steps). This field is mandatory. If the checkbox above is enabled, the Password field appears as a text box. Else, if the checkbox above is disabled, the Password field appears as a drop-down to select fields from previous steps.
	Button:
7	Test Connection	Test connection with the username and password provided. Verifies whether the connection is available or not. Note: Test Connection button does not work if the connection fields are populated from previous steps.

No. Field Name Description

Input Field:

SWQL Query

No.	Field Name	Description
	Input Field:
1	SWQL Query	The SWQL query based on which the required SolarWinds data will be retrieved. This field is mandatory. The SWQL query should be valid. Following are some sample queries on different objects: `SELECT TOP 1000 AlertActiveID, AlertObjectID, Acknowledged, AcknowledgedBy, AcknowledgedDateTime, AcknowledgedNote:, TriggeredDateTime, TriggeredMessage, NumberOfNote:s, LastExecutedEscalationLevel FROM Orion.AlertActive` `SELECT AlertHistoryID, EventType, Message, TimeStamp, AccountID, AlertActiveID, AlertObjectID, ActionID FROM Orion.AlertHistory` `SELECT NodeID, Caption, IPAddress, Status FROM Orion.Nodes ORDER BY Caption`

The SWQL query based on which the required SolarWinds data will be retrieved.

This field is mandatory. The SWQL query should be valid.

Following are some sample queries on different objects:

SELECT TOP 1000 AlertActiveID, AlertObjectID, Acknowledged, AcknowledgedBy, AcknowledgedDateTime, AcknowledgedNote:, TriggeredDateTime, TriggeredMessage, NumberOfNote:s, LastExecutedEscalationLevel FROM Orion.AlertActive
SELECT AlertHistoryID, EventType, Message, TimeStamp, AccountID, AlertActiveID, AlertObjectID, ActionID FROM Orion.AlertHistory
SELECT NodeID, Caption, IPAddress, Status FROM Orion.Nodes ORDER BY Caption

No.	Field Name	Description
	Buttons:
1	OK	On click of this button, it will check the field values. If any required field values are missing, it will display a validation error message. If all required field values are provided, it will save the field values.
2	Cancel	On click of this button, it will cancel the window and will not save any values.

No.

Field Name

Description

Buttons:

On click of this button, it will check the field values.

If any required field values are missing, it will display a validation error message.

If all required field values are provided, it will save the field values.

Cancel

On click of this button, it will cancel the window and will not save any values.