Query works in SDK but not on Modern Dashboard Table

ive got the below SWQL working in SKD but when I load it into Modern Dashboard Table I get "Provided SWQL query is not valid. Details: RunQuery failed, check fault information. Cannot resolve property Alert"

Any assistance would be greatly appreciated

SELECT

o.AlertConfigurations.Name AS [Alert]


,'/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT]

,o.EntityCaption AS [ALERT OBJECT]

,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT]

,case

WHEN o.RelatedNodeCaption=EntityCaption THEN RelatedNodeCaption

When o.RelatedNodeCaption!=EntityCaption THEN RelatedNodeCaption

End as [RELATED NODE]

,o.RelatedNodeDetailsURL AS [_LinkFor_RELATED NODE]

,ToLocal(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME]

,CASE

when minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())>1440 then (tostring(round(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())/1440.0,1)) + ' Days')

when minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())>60 then (tostring(round(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())/60.0,1)) + ' Hours')

else (tostring(minutediff(o.AlertActive.TriggeredDateTime,GETUTCDATE())) + ' Minutes')

end as [Time Active]

,aa.AcknowledgedBy

,ah.Message as [Note]

From Orion.AlertActive aa

join Orion.AlertObjects o on aa.alertobjectid=o.alertobjectid

LEFT join Orion.Nodes p on p.nodeid=relatednodeid

left join orion.alerthistory ah on ah.AlertActiveID=aa.AlertActiveID and ah.EventType in (2,3)

where o.AlertConfigurations.Name like '%Node Down%' or o.AlertConfigurations.Name like '%Node status warning%' or o.AlertConfigurations.Name like '%Extended CPU%' or o.AlertConfigurations.Name like '%Max CPU%'

ORDER by o.AlertActive.TriggeredDateTime DESC

Parents Reply Children
No Data