Need assistance creating an alerting modern dashboard

KMSigma.SWI  Do we have any

SELECT aa.AlertActiveID,
CASE 
  WHEN ao.AlertConfigurations.Severity = 2 then '<b><p style="color:red;font-size:16px">Critical</p></b>'
  WHEN ao.AlertConfigurations.Severity = 3 then '<b><p style="color:orangered;font-size:16px">Serious</p></b>'
  WHEN ao.AlertConfigurations.Severity = 1 then '<b><p style="color:Orange;font-size:16px">Warning</p></b>'
  WHEN ao.AlertConfigurations.Severity = 0 then '<p style="font-size:16px">Informational</p>'
  WHEN ao.AlertConfigurations.Severity = 4  then '<p style="font-size:16px">Notice</p>'
  ELSE concat(ao.AlertConfigurations.Severity, '')
  END AS [Severity]
, CONCAT('<p style="font-size:16px"><a href="/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:', a.AlertObjectID, '">' , ao.AlertConfigurations.DisplayName, '</a></p>') AS Alert 
, a.triggertimestamp
, a.TriggerCount AS [Recent Alert Count]
, CASE
    WHEN Minutediff(a.triggertimestamp,GETUTCDATE()) BETWEEN 0 AND 119 THEN concat('<p style="font-size:16px">',Minutediff(a.triggertimestamp,GETUTCDATE()), ' Minutes Ago</p>') 
    WHEN HOURDIFF(a.TriggerTimeStamp,GETUTCDATE()) BETWEEN 2 AND 48 THEN concat('<p style="font-size:16px">',HOURDIFF(a.triggertimestamp,GETUTCDATE()), ' Hours Ago</p>') 
    ELSE concat('<p style="font-size:16px">',DAYDIFF(a.triggertimestamp,GETUTCDATE()), ' Days Ago</p>') 
--  ELSE concat('<p style="font-size:16px">',a.TriggerTimeStamp,'</p>') 
    END AS [Trigger Time] 
, concat('<p style="font-size:16px">',ao.AlertNote,'</p>') as [Ticket]
, concat('<p style="font-size:16px">',ao.AlertActive.AcknowledgedBy,'</p>') as [Acknoledged By]
, concat('<p style="font-size:16px">',ao.AlertActive.AcknowledgedDateTime,'</p>') as [Acknoledged Time]
, CASE 
  WHEN ao.RelatedNodeCaption IS NULL then  CONCAT('<p style="font-size:16px"><a href="',ao.EntityDetailsUrl, '">',ao.EntityCaption, '</a></p>') 
  WHEN ao.EntityCaption = ao.RelatedNodeCaption then  CONCAT('<p style="font-size:16px"><a href="',ao.EntityDetailsUrl, '">',ao.EntityCaption, '</a></p>') 
  ELSE CONCAT('<p style="font-size:16px"><a href="',ao.EntityDetailsUrl,  '">',ao.EntityCaption, '</a> on ','<a href="', ao.RelatedNodeDetailsUrl, '">', ao.RelatedNodeCaption,'</a></p>') 
  END AS [On]

FROM Orion.AlertActive aa
LEFT JOIN Orion.AlertStatus a on aa.AlertObjectID = a.AlertObjectID
LEFT JOIN Orion.AlertObjects ao on a.AlertObjectID = ao.AlertObjectID

Is this tweak on the SolarWinds Active Alert Dashboard , adam.beedell ?

Probably, cant remember where I got it from and revised several bits. There's a couple columns there no-one needs but hey I had it to hand

Everyone else, if 2 people recommend a page, and one of them is KMSigma.SWI  use his one first

Probably, cant remember where I got it from and revised several bits. There's a couple columns there no-one needs but hey I had it to hand

Everyone else, if 2 people recommend a page, and one of them is KMSigma.SWI  use his one first