This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

2020.2.5 breaks some modern dashboard queries

Hi there!

We're using a swql query to list all active volume alerts and some of the relevant details of those alerts. This query still works in swql studio, as well as in the old dashboard (custom table), but the table widget in our modern dashboard is now empty (query broken after the update to 2020.2.5). 

Here's the query in question:

SELECT o.AlertConfigurations.Name AS [ALERT NAME],
    '/Orion/NetPerfMon/ActiveAlertDetails.aspx?NetObject=AAT:' + ToString(o.AlertObjectID) AS [_LinkFor_ALERT NAME],
    CASE WHEN o.AlertConfigurations.Severity = 2 THEN '/Orion/images/ActiveAlerts/Critical.png'
        WHEN o.AlertConfigurations.Severity = 3 THEN '/Orion/images/ActiveAlerts/Serious.png'
        WHEN o.AlertConfigurations.Severity = 1 THEN '/Orion/images/ActiveAlerts/Warning.png'
        WHEN o.AlertConfigurations.Severity = 0 THEN '/Orion/images/ActiveAlerts/InformationalAlert.png'
        WHEN o.AlertConfigurations.Severity = 4 THEN '/Orion/images/ActiveAlerts/Notice.png'
    END AS [_IconFor_ALERT NAME],
    o.EntityCaption AS [ALERT OBJECT] ,o.EntityDetailsURL AS [_LinkFor_ALERT OBJECT],
    CASE WHEN o.RelatedNodeCaption=EntityCaption THEN 'Self'
        WHEN o.RelatedNodeCaption!=EntityCaption THEN RelatedNodeCaption 
    END AS [RELATED NODE],
    o.RelatedNodeDetailsURL AS [_LinkFor_RELATED NODE],
    ToLocal(o.AlertActive.TriggeredDateTime) AS [ALERT TRIGGER TIME],
    '/Orion/images/StatusIcons/Small-' + p.StatusIcon AS [_IconFor_RELATED NODE],
    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],
    round(v.VolumePercentUsed,2) AS [PERCENT USED],
    round(v.VolumeSpaceAvailable/1024/1024/1024,2) AS [GB FREE]
    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.Volumes v ON v.VolumeID=Substring(EntityNetObjectId, 3, 20)
    LEFT JOIN orion.alerthistory ah on ah.AlertActiveID=aa.AlertActiveID and ah.EventType in (2,3) 
    WHERE o.EntityNetObjectId LIKE 'V:%'

It seems that o.AlertConfigurations.Name no longer works, when using modern dashboard. To me, this feels like a bug.

Does this work for anyone else? 

Kind regards

Ariano

Parents
No Data
Reply
  • Hi Xaturbatu!

    Thanks for trying to figure it out! Sadly, this doesn't work either. Don't get me wrong: the query looks correct and it works fine in swql studio (as expected). It just does not work in a table widget, on a modern dashboard running on 2020.2.5. At least for me, it doesn't...

    I can create the widget, validate and preview results, but upon saving, it still throws errors and does not show results, so this is the same result as with the previous tests above.

    Once the Solarwinds support has responded to the case, I will update this thread to keep you informed.

Children
No Data