Network Management

Custom poller query for reports and alerts

This article provides brief information on ways to get the SWQL queries to help create a report or an alert on a custom poller. You will need to generate queries in SWIS to apply them in the alert and reports.

First published date

11/29/2018 10:47 PM

Last published date

6/13/2025 3:02 PM

Overview

This article describes a way to get SWQL queries to help create a report or an alert on a custom poller.

Product section

Network Performance Monitor

Resolution

Generating Queries:

You will need to generate queries in SWIS to apply them in the alert and reports. To do so, go to http://<SERVER NAME>/Orion/Admin/swis.aspx. and replace <SERVER NAME> with the correct IP or hostname for your environment.

The screenshot below shows the page for the Orion SWIS Query and will have a drop-down to select what is available. You can then select this and click Generate Select Query to see how these are created and then you can modify according to your needs. 

 

Orion_SWIS_Query_Dropdown.png

 

Alert:

  1. Create a new alert.
  2. For Trigger condition, select Custom SWQL Alert (Advanced).
  3. Use the drop-down to see what queries are available from here. You can customize the query to achieve a certain type of alert. Please note the SELECT statement is generated automatically based on the item selected from the drop-down.

 

Alert_Trigger_Condition.png

 

Report:

  1. Create a new report.
  2. For Selection Method, select Advanced Database Query (SQL, SWQL) and paste your query in the box:

Add_Report_SWQL.png

  1. Apply the columns needed for the report.

For additional resources on creating custom SWQL Alerts and Reports please check out the Alert Lab and Report Lab in our Thwack community.

Please note that Thwack is a community space where users may post any content as a suggestion or recommendations to you for your internal use. The information set forth herein may come from third-party websites or customers. SolarWinds is not liable for any downtime or any issue that may occur if you perform the following suggestions on the link provided. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.