Unable to filter Alerts on TriggeredDateTime

I'm using query

SELECT o.AlertConfigurations.Name AS [ALERTNAME], o.EntityCaption AS [ALERT_OBJECT], o.AlertActive.AlertActiveID, o.AlertActive.TriggeredDateTime FROM Orion.AlertObjects o WHERE o.AlertConfigurations.Name = 'Node is down' AND o.AlertActive.TriggeredDateTime = '2024-10-24T12:38:58.7430000Z

I actually want to give TriggerDateTime 2024-10-24T12:38:58.7430000Z as input and it is confirmed that I have alert at this trigger time but when I give this time a input I does not show any result

can anyone please help me to resolve this issue?

Find more posts tagged with

SWQL

npm

orion sdk

Comments

yaquaholic

Hi Musman12362,

It's the formatting of the time that is messing it up, try this

AND o.AlertActive.TriggeredDateTime = '2024-10-24 12:38:58'

Rich

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Help
Best Of