Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How can I alert on a SWQL Query

tqcenter2002c

Hi All,

I have already created a working SWQL query and tested to be OK. I get a table back and it looks good.

But, When I try to create an alert on it I am getting an error.

Please let me know what I am missing here? I have checked the SWQL and I got a table back with no issues at all.

I need to create an alert on that and I can't.

Please advise,

Thank You

Find more posts tagged with

Accepted answers

All comments

uniswtc

Hi, it would be great, if you can provide the query and a screen shot where you want to create the alert.

tqcenter2002c

Hi,

I am trying to use this in Trigger condition of a new alert. Using the I want to alert on: (drop down menu) Custom SWQL Alert (Advanced)

The I need to setup my SWQL condition - there is a drop down menu from there as well. The Following SWQL(enclosed down below) Works perfectly with NO ERRORS on the swiss.aspx on the server. When I paste the SWQL there and Click validate I am getting ERROR as I have posted the screen the last post.

This is the SWQL:

SELECT

ObjStat.[DisplayName] as DisplayName,

adminState.[Status] as adminState,

ObjStat.[Status] as ObjectStat

FROM

Orion.NPM.CustomPollerStatusOnNodeTabular AS ObjStat,

Orion.NPM.CustomPollerStatusOnNodeTabular AS adminState

where ObjStat.[DisplayName] = adminState.[DisplayName]

AND ObjStat.[CustomPollerAssignment].[CustomPoller].[UniqueName] = 'DataPower_ObjectStatusTbl'

AND adminState.[CustomPollerAssignment].[CustomPoller].[UniqueName] = 'DataPower_ObjectAdminStateStatusTbl'

AND adminState.[Status] = 1 AND ObjStat.[Status]=2

I am doing a polling using a UnDP Pollers: DataPower_ObjectAdminStateStatusTbl and DataPower_ObjectStatusTbl - both are two tables I get using a poller on 2 MiBs/

Please advise,

Thanks.

i_like_eggs

Hey,

when working with the SWQL or SQL you need to join your table on to the the predefined select and from statement. your have to remove your select statement because you will be using two select statements and it will error out. the challenge would be that the current query doesn't have a unique ID of some type so it will need to be reworked to fit the select statement below.

i_like_eggs

here is an example:

 WITH (NOLOCK) INNER JOIN CustomPollerAssignmentView cv WITH (NOLOCK) ON cv.CustomPollerAssignmentID = CustomPollerStatusTable.CustomPollerAssignmentID WHERE CustomPollerName IN ('DataPower_ObjectAdminStateStatusTbl','DataPower_ObjectStatusTbl') AND (Status = 2)