SWQL query to return Active Alerts with Acknowledge Notes

I thought this looked much like the SolarWinds Active Alert Dashboard .  You just want to extend that and bring in the Ack Note?

On my version (2024.1), you need to pull in the AlertStatus entity...

SELECT [SA].AlertConfigurations.Name AS [Name]
     , [SA].AlertConfigurations.Severity AS [Name_Severity]
     , [SA].EntityCaption AS [Object]
     , [SA].Node.Status AS [Object_Status]
     , [SA].RelatedNodeDetailsURL AS [Related Node_URL]
     , [SA].Node.Status AS [Related Node_Status]
     , [SA].AlertActive.Acknowledged AS [Acknowledged]
     , [Status].Notes AS [Acknowledge Note]
     , [SA].RelatedNodeCaption AS [RELATED NODE]
     , TOSTRING(TOLOCAL([SA].AlertActive.TriggeredDateTime)) AS [Time]
     , TOLOCAL([SA].AlertActive.TriggeredDateTime) AS [Time_SORT]
FROM Orion.AlertObjects AS [SA]
LEFT JOIN Orion.AlertStatus AS [Status]
  ON [SA].AlertConfigurations.AlertRefID = [Status].AlertDefID
  AND [SA].AlertObjectID = [Status].AlertObjectID
WHERE [SA].AlertActive.AlertActiveID > 0
ORDER BY [SA].AlertActive.TriggeredDateTime DESC