Query

Hi Team, Query​ Intro to SWQL Studio​ dan jagnow​

Still waiting for your response. Its urgent for me.

Regards

Sandeep

See this thread: Quick way to look through all alert trigger definitions for a specific custom property? .  As far as I know, it's not possible to gather this information with a SWQL query, but you should be able to use a SQL query on AlertDefinitionsView.

Hi,

There is no any AlertDefinitionsView table, i can see only Orion.AlertConfigurations table here. Is this the same table? Used same query that mentioned in your shared post. I got the data but many confusion regards this data. Whatever data I am getting, all are the old alert or not triggering alerts.

AlertDefinitionsView is a view, not a table.  However, I may have misunderstood what you are looking for.  I suggest reading the documentation at Alerts · solarwinds/OrionSDK Wiki · GitHub to get a better understanding of how alerts work in Orion.  If you are interested alerts that are currently active, then you can run a SWQL query with Orion.AlertActive.  Here is a simple example of how you might query for active alerts for a particular node, given the node ID:

SELECT

    aa.AlertActiveID,

    aa.TriggeredDateTime,

    aa.TriggeredMessage,

    ao.RealEntityType,

    ao.EntityNetObjectId

FROM Orion.AlertActive aa

INNER JOIN Orion.AlertObjects ao ON ao.AlertObjectID = aa.AlertObjectID

WHERE ao.RealEntityType = 'Orion.Nodes' AND ao.EntityNetObjectId = 'N:32'

This is a more elaborate example of working with that table in swql question for Active Alerts on Volumes , which is focused on volumes, but which may be useful for you.

Many many thanks. Documentation really helpful for me.

Will come back to you again if any query