How to create a report to show all nodes that are muted via Maintenance Mode

ArchieG

Hello,

Please can someone show me how to create a custom report to show all nodes that are muted vis maintenance mode? I'm a report beginner 

I tried this How to view all nodes that are muted via Maintenance Mode - Alert Lab - The SolarWinds Platform - THWACK but got the "Query is not valid" error.

Many Thanks!

dodo123

Yeah there is an extra comma before the 'FROM' so should be

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