Report showing user who unmanaged elements and muted alerts

Sure. This query gets only current and future mute events:

Select N.Caption, Supp.SuppressFrom, Supp.SuppressUntil, LastMuteEvent.TimeLoggedUtc, AE.AccountID, N.StatusDescription
from Orion.Nodes N 
INNER JOIN Orion.AlertSuppression Supp on Supp.EntityUri = N.Uri 
LEFT OUTER JOIN ( 
SELECT NetObjectID, Max(AuditEventID) as [AuditEventID], Max(TimeLoggedUtc) as [TimeLoggedUtc] 
FROM Orion.AuditingEvents 
where ActionTypeID in ( 
SELECT ActionTypeID 
FROM Orion.AuditingActionTypes 
where ActionType = 'Orion.AlertSuppressionAdded' 
or ActionType = 'Orion.AlertSuppressionChanged' 
) 
group by NetObjectID 
) AS [LastMuteEvent] on LastMuteEvent.NetObjectID = N.NodeID 
LEFT OUTER JOIN Orion.AuditingEvents AE on AE.AuditEventID = LastMuteEvent.AuditEventID
WHERE (
ToUTC(Supp.SuppressFrom) >= TOLOCAL(GETDATE())
OR
ToUTC(Supp.SuppressFrom) <= TOLOCAL(GETDATE()) AND ToUTC(Supp.SuppressUntil) >= TOLOCAL(GETDATE())
)
ORDER BY N.Caption 

This query puts the future unmanage and future mute events into a single table:

Select N.Caption, N.UnManageFrom, N.UnManageUntil, LastUnmanageEvent.TimeLoggedUtc, AE.AccountID, N.StatusDescription
from Orion.Nodes N       
LEFT OUTER JOIN (      
SELECT NetObjectID, Max(AuditEventID) as [AuditEventID], Max(TimeLoggedUtc) as [TimeLoggedUtc]      
FROM Orion.AuditingEvents       
where ActionTypeID=    
(    
SELECT ActionTypeID    
FROM Orion.AuditingActionTypes    
where ActionType = 'Orion.NodeUnmanaged'    
)       
group by NetObjectID       
) AS [LastUnmanageEvent] on LastUnmanageEvent.NetObjectID = N.NodeID      
LEFT OUTER JOIN Orion.AuditingEvents AE on AE.AuditEventID = LastUnmanageEvent.AuditEventID      
Where (N.Unmanaged = TRUE OR N.UnManageFrom > GETUTCDATE())  
UNION
(
Select N.Caption, Supp.SuppressFrom, Supp.SuppressUntil, LastMuteEvent.TimeLoggedUtc, AE.AccountID, N.StatusDescription
from Orion.Nodes N   
INNER JOIN Orion.AlertSuppression Supp on Supp.EntityUri = N.Uri   
LEFT OUTER JOIN (   
SELECT NetObjectID, Max(AuditEventID) as [AuditEventID], Max(TimeLoggedUtc) as [TimeLoggedUtc]   
FROM Orion.AuditingEvents   
where ActionTypeID in (  
SELECT ActionTypeID  
FROM Orion.AuditingActionTypes  
where ActionType = 'Orion.AlertSuppressionAdded'  
or ActionType = 'Orion.AlertSuppressionChanged'  
)   
group by NetObjectID   
) AS [LastMuteEvent] on LastMuteEvent.NetObjectID = N.NodeID   
LEFT OUTER JOIN Orion.AuditingEvents AE on AE.AuditEventID = LastMuteEvent.AuditEventID
WHERE (
ToUTC(Supp.SuppressFrom) >= TOLOCAL(GETDATE())
OR
ToUTC(Supp.SuppressFrom) <= TOLOCAL(GETDATE()) AND ToUTC(Supp.SuppressUntil) >= TOLOCAL(GETDATE())
)
)
ORDER BY N.Caption 

Those are nodes that have never been unmanaged before. TimeLoggedUTC and AccountID come from Orion.AuditingEvents. If the node hasn't ever been unmanaged, it won't have a record in Orion.AuditingEvents.

This query uses the _linkfor_(column name) format to link to the node detail page. It's useful if you want to use a custom query resource on a page in the Orion GUI:

Select N.Caption, Supp.SuppressFrom, Supp.SuppressUntil, AE.TimeLoggedUtc, AE.AccountID
, N.DetailsUrl AS [_linkfor_Caption]
from Orion.Nodes N   
INNER JOIN Orion.AlertSuppression Supp on Supp.EntityUri = N.Uri   
LEFT OUTER JOIN (   
SELECT NetObjectID, Max(AuditEventID) as [AuditEventID] 
FROM Orion.AuditingEvents   
where ActionTypeID in (   
SELECT ActionTypeID   
FROM Orion.AuditingActionTypes   
where ActionType = 'Orion.AlertSuppressionAdded'   
or ActionType = 'Orion.AlertSuppressionChanged' 
) 
and NetObjectType='N'   
group by NetObjectID   
) AS [LastMuteEvent] on LastMuteEvent.NetObjectID = N.NodeID   
LEFT OUTER JOIN Orion.AuditingEvents AE on AE.AuditEventID = LastMuteEvent.AuditEventID   
ORDER BY N.Caption   

If you want to create a Solarwinds report and make the node name clickable, use this version. In the report writer, format the Caption column to link to the details page:

Select N.Caption, Supp.SuppressFrom, Supp.SuppressUntil, AE.TimeLoggedUtc, AE.AccountID
, N.DetailsUrl
from Orion.Nodes N   
INNER JOIN Orion.AlertSuppression Supp on Supp.EntityUri = N.Uri   
LEFT OUTER JOIN (   
SELECT NetObjectID, Max(AuditEventID) as [AuditEventID] 
FROM Orion.AuditingEvents   
where ActionTypeID in (   
SELECT ActionTypeID   
FROM Orion.AuditingActionTypes   
where ActionType = 'Orion.AlertSuppressionAdded'   
or ActionType = 'Orion.AlertSuppressionChanged' 
) 
and NetObjectType='N'   
group by NetObjectID   
) AS [LastMuteEvent] on LastMuteEvent.NetObjectID = N.NodeID   
LEFT OUTER JOIN Orion.AuditingEvents AE on AE.AuditEventID = LastMuteEvent.AuditEventID   
ORDER BY N.Caption