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
