cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post

Please add the status of alerts muted in manage nodes page.

Please add the status of alerts muted in manage nodes page.

Hi Team,

Like the unmanaged node status, it would be helpful to have node status where alerts are muted.

 

prashantsingh_0-1602520279889.png

 

Thank you.

3 Comments

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],

CASE

WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'

THEN [N].[DetailsUrl]

WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'

THEN [I].[DetailsUrl]

WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Applications/ApplicationID=%'

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

WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%' AND [EntityUri] NOT LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/%'

THEN [N].[NodeName]

WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Interfaces/InterfaceID=%'

THEN [I].[InterfaceCaption]

WHEN [EntityUri] LIKE 'swis://%/Orion/Orion.Nodes/NodeID=%/Applications/ApplicationID=%'

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

INNER JOIN Orion.AuditingActionTypes AS [AT]

ON [AE].ActionTypeID = [AT].ActionTypeID

WHERE [AT].ActionTypeDisplayName LIKE '%mute%'

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

Level 13

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?

Level 9