Hi Team,
Like the unmanaged node status, it would be helpful to have node status where alerts are muted.
Thank you.
You can customize the new query widget which can give you the list of nodes where alertmute is set by user. Below is the statement i used in my work place. Hope it solves your purpose.
SELECT EntityUri, UtcSuppressFrom, UtcSuppressUntil, LocalSuppressFrom, LocalSuppressUntil, Element, DetailsUrl, AE2.AccountID
FROM
(
SELECT DISTINCT [EntityUri],
[SuppressFrom] AS [UtcSuppressFrom],
[SuppressUntil] AS [UtcSuppressUntil],
ToLocal([SuppressFrom]) AS [LocalSuppressFrom],
ToLocal([SuppressUntil]) AS [LocalSuppressUntil],
CASE
WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'
THEN [N].[Caption]
WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'
THEN [I].[FullName]
WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Applications/ApplicationID=%'
THEN [AA].[FullyQualifiedName]
ELSE 'SomethingElse'
END AS [Element],
THEN [N].[DetailsUrl]
THEN [I].[DetailsUrl]
THEN [AA].[DetailsUrl]
ELSE '<a href="/Orion/SummaryView.aspx">SomethingElse</a>'
END AS [DetailsUrl]
FROM Orion.AlertSuppression AS [AlertSup]
LEFT OUTER JOIN Orion.Nodes AS [N]
ON [AlertSup].[EntityUri] = [N].[Uri]
LEFT OUTER JOIN Orion.NPM.Interfaces AS [I]
ON [AlertSup].[EntityUri] = [I].[Uri]
LEFT OUTER JOIN Orion.APM.Application AS [AA]
ON [AlertSup].[EntityUri] = [AA].[Uri]
LEFT OUTER JOIN Orion.AuditingEvents AS [AE]
ON [AE].AuditEventMessage LIKE CONCAT('%', CASE
THEN [N].[NodeName]
THEN [I].[InterfaceCaption]
THEN [AA].[Name]
ELSE 'Wrong'
END, '%') AND [EntityUri] LIKE CONCAT('%=', [AE].NetObjectID)
INNER JOIN Orion.AuditingActionTypes AS [AT]
ON [AE].ActionTypeID = [AT].ActionTypeID
WHERE [AT].ActionTypeDisplayName LIKE '%mute%'
) AS tbl1
JOIN
SELECT NetObjectID, MAX(TimeLoggedUtc) AS MaxTimeLoggedUtc
FROM Orion.AuditingEvents AS AE
GROUP BY NetObjectID
) AS tbl2 ON tbl1.EntityUri LIKE CONCAT('%=', tbl2.NetObjectID)
JOIN Orion.AuditingEvents AS AE2 ON tbl2.NetObjectID = AE2.NetObjectID AND tbl2.MaxTimeLoggedUtc = AE2.TimeLoggedUtc
I like the idea ... and the query, which is nice. However the query will not resolve the purpose. The idea - as I understand - would appear everywhere with the node status (like DOWN or UNMANAGED) but the query would appear at particular dashboard. I can add widget with the query to every dashboard of course but why not to have indicator for node with MUTED alerts on?
Maybe this content of @KMSigma.SWI can help you out?https://thwack.solarwinds.com/t5/NPM-Documents/Muted-Nodes-Resource/tac-p/526201
