nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

custom SWQL alert Trigger Condition

rkshprb

I want to add whole SWQL query in Trigger Condition .

As of now we are not able add customize query in alert condition . Is there any way to add SWQL query in alert condition.?

Find more posts tagged with

SWQL

alert condition

Accepted answers

All comments

neomatrix1217

rkshprb

thanks for reply @neomatrix1217 ,

But I want to write my own complex query Here.

As in Trigger condition Custom SWQL Alert , we are not able join table .

Is there any way to join tables or write complex query .

christopher.t.jones123

@rkshprb, you start it in the text field after the pre-populated query. you cant change the selection statement but you certainly can add in complexity using joins and such, you just start your join in the text field.

rkshprb

@christopher.t.jones123

you have any sample join query ?. I tried to join table but its showing error . Query condition is not valid.

@christopher.t.jones123

christopher.t.jones123

@rkshprb, can you paste a screenshot of what you are attempting to do? It'll probably be more efficient for me to work with what you are trying to do.

rkshprb

Thank for reply @christopher.t.jones123

I want to use below query in custom SWQL

SELECT top 10
cs.Component.Application.Node.Caption AS NODE
,cs.Component.Application.Node.DetailsUrl as [_linkfor_NODE]
,si.DisplayName
,cs.Component.name AS [CMPNT]
,cs.Component.DetailsUrl as [_linkfor_CMPNT]
,'/Orion/Images/StatusIcons/Small-' + si.DisplayName + '.gif' AS [_iconfor_CMPNT]
,cs.Component.Application.Name AS [APP]
,cs.Component.Application.DetailsUrl as [_linkfor_APP]
FROM Orion.APM.CurrentComponentStatus cs
JOIN Orion.APM.StatusMetadata si ON si.ApmStatusValue = cs.Availability
Left JOIN orion.AlertSuppression als ON (als.Entityuri like concat('%ApplicationId=',cs.component.ApplicationID) OR als.Entityuri like concat('%NodeId=',cs.Component.Application.NodeID))
Left outer JOIN Orion.NodesCustomProperties ncp On ncp.NodeID =cs.Component.Application.NodeID
Left Join Orion.APM.Component ac on ac.ComponentID=cs.ComponentID
WHERE
cs.component.Application.Node.status not in (9)
and cs.Component.Application.Status not in (9)
and si.DisplayName Not in ( 'Up', 'Disabled' , 'Unmanaged' , 'Not Running' , 'Critical' , 'Warning' )

and ac.Disabled=False

I Tried to use joins as shown in image,