How to view all nodes that are muted via Maintenance Mode

I am trying to display a list that shows the nodes that have been muted via maitenance mode, I am assuming this is going to be done via SWQL but I am not sure. If there is an easier way to view it that would also be appreciated.

Find more posts tagged with

nodes

Muting

node_alert

muted

Alerts

Accepted answers

jm_sysadmin

This is from a widget that I use:

SELECT
'' AS n,
n.Caption as NODE,
n.IPAddress as IP,
n.MachineType As Type,
HourDiff(ToLocal(n.UnManageFrom), GETDATE()) as [Hours],
CASE  
    WHEN (ToString(Year(n.UnManageUntil)) like '9999' ) Then 'No End Set'  
    Else ToString(ToLocal(n.UnManageUntil))
END AS [End Time],
'/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_n],
'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.NodeID) AS [_LinkFor_NODE],
FROM
Orion.Nodes n
Where
n.Unmanaged = 1
ORDER BY
n.LastSystemUpTimePollUtc DESC

All comments

jm_sysadmin

This is from a widget that I use:

SELECT
'' AS n,
n.Caption as NODE,
n.IPAddress as IP,
n.MachineType As Type,
HourDiff(ToLocal(n.UnManageFrom), GETDATE()) as [Hours],
CASE  
    WHEN (ToString(Year(n.UnManageUntil)) like '9999' ) Then 'No End Set'  
    Else ToString(ToLocal(n.UnManageUntil))
END AS [End Time],
'/Orion/images/StatusIcons/small-' + ToString(n.StatusIcon) AS [_IconFor_n],
'/Orion/NetPerfMon/NodeDetails.aspx?NetObject=N%3a' + ToString(n.NodeID) AS [_LinkFor_NODE],
FROM
Orion.Nodes n
Where
n.Unmanaged = 1
ORDER BY
n.LastSystemUpTimePollUtc DESC

TMKKCC

Can you send a screenshot (bluring/removing data) of what its supposed to look like? The inital column and the two icon columns are blank/ errored out on the modern dashboard

TMKKCC

@bobmarley That with JM_sysadmins post worked quite nicely. Thank you.

jm_sysadmin

Yah sorry, this was a legacy dash. columns with _ at the start and end get used to put formatting into other columns. From your post below you have it working now though