Hello,
I have encountered an unusual issue in Solarwinds. Whenever an engineer in our company mutes or schedule mutes a node, a different engineer's name appears under our custom widget. Additionally, when we schedule mute a node, it does not automatically come off mute after the scheduled end time. Nothing has changed in the Custom widget and it's accurate in that it reports correctly that nodes are in a muted state, when i search for the node and unmute it dissapears from the widget. It's not just my account haveing the issue, others are seeing the same. I have tried the usual, logging out/ back in etc but the issue still persists. I have raise a case with Solarwinds support but they suggested i post on thwack re the custom Widget as it's not something they don't support.
This is the Custom SWQL code we are using
SELECT
n.Caption AS [Node]
,n.DetailsURL AS [_LinkFor_Node]
,'/Orion/images/StatusIcons/Small-' + n.StatusLED AS [_IconFor_Node]
,tostring(tolocal(SuppressFrom)) as [From]
,case when SuppressUntil is null or SuppressUntil = '9999-01-01 00:00:00' then 'Not set'
else tostring(tolocal(SuppressUntil )) end AS [Until]
,case when SuppressUntil is null or SuppressUntil = '9999-01-01 00:00:00' then '-'
else tostring(daydiff(getutcdate(), asup.SuppressUntil)) end as [Days Left]
, ae.AccountID AS [Muted By]
FROM Orion.AlertSuppression asup
join orion.nodes n on asup.entityuri=n.uri
join (
SELECT ae.NetObjectID, max(ae.timeloggedutc) as recent
FROM Orion.AuditingEvents ae
WHERE ae.auditingactiontype.actiontype in ('Orion.AlertSuppressionChanged','Orion.AlertSuppressionAdded')
group BY ae.netobjectid) mostrecent ON mostrecent.NetObjectID = n.NodeID
join (
SELECT ae.NetObjectID, ae.AccountID, ae.timeloggedutc
FROM Orion.AuditingEvents ae
WHERE ae.auditingactiontype.actiontype in ('Orion.AlertSuppressionChanged','Orion.AlertSuppressionAdded')
Order BY ae.TimeLoggedUtc desc) ae ON ae.NetObjectID = n.NodeID and ae.timeloggedutc=mostrecent.recent
AND NodeID NOT LIKE '5678' AND NodeID NOT LIKE '5679' AND NodeID NOT LIKE '5681' AND NodeID NOT LIKE '5682' AND NodeID NOT LIKE '5680' AND NodeID NOT LIKE '5683' AND NodeID NOT LIKE '5678' AND NodeID NOT LIKE '5679'
order by n.caption
the node muted by
the example below shows the scheduled start/end date of the node but it's still muted and it shows the wrong person.
