NPM: 12.2
For those of you who want to know which nodes have been muted in your environment, this is how I found nodes that have been muted using Microsoft Access. The table names and columns should be the same across SQL server, MS Acess SQL, and SWQL. To use it in the different areas, you will just need to modify the syntax.
The following tables will need to be mapped in MS Access:
SELECT dbo_AlertSuppression2.SuppressFrom, dbo_AlertSuppression2.SuppressUntil, dbo_AuditingEvents.AccountID AS ChangedBy, dbo_Nodes.NodeID, dbo_Nodes.IP_Address, dbo_Nodes.Caption, dbo_Nodes.StatusDescription, dbo_Nodes.Vendor, dbo_Nodes.MachineType, dbo_Nodes.UnManaged, dbo_Nodes.UnManageFrom, dbo_Nodes.UnManageUntil
FROM dbo_AlertSuppression2, (dbo_Nodes INNER JOIN (dbo_AuditingEvents INNER JOIN dbo_AuditingActionTypes ON dbo_AuditingEvents.ActionTypeID = dbo_AuditingActionTypes.ActionTypeID) ON dbo_Nodes.NodeID = dbo_AuditingEvents.NetworkNode) INNER JOIN dbo_AlertObjects ON dbo_Nodes.NodeID = dbo_AlertObjects.RelatedNodeId
WHERE (((dbo_AuditingActionTypes.ActionType) Like "Orion.AlertSuppressionAdded" Or (dbo_AuditingActionTypes.ActionType) Like "Orion.AlertSuppressionChanged") AND ((dbo_AlertObjects.EntityUri)=[dbo_AlertSuppression2].[EntityUri]) AND ((dbo_AlertSuppression2.EntityUri) Like "swis://*/Orion/Orion.Nodes/NodeID=*" And (dbo_AlertSuppression2.EntityUri) Not Like "swis://*/Orion/Orion.Nodes/NodeID=*/*"))
GROUP BY dbo_AlertSuppression2.SuppressFrom, dbo_AlertSuppression2.SuppressUntil, dbo_AuditingEvents.AccountID, dbo_Nodes.NodeID, dbo_Nodes.IP_Address, dbo_Nodes.Caption, dbo_Nodes.StatusDescription, dbo_Nodes.Vendor, dbo_Nodes.MachineType, dbo_Nodes.UnManaged, dbo_Nodes.UnManageFrom, dbo_Nodes.UnManageUntil
ORDER BY dbo_AlertSuppression2.SuppressFrom DESC;
