I need a few duplex mismatch alerts to send to specific distribution groups based off the custom properties, City, and Department. Out of the box Solarwinds uses an advanced SWQL query,
LEFT JOIN Orion.TopologyConnections tc ON (tc.SrcNodeID = Interfaces.NodeID OR tc.DestNodeID = Interfaces.NodeID) AND (tc.SrcInterfaceID =Interfaces.InterfaceID OR tc.DestInterfaceID =Interfaces.InterfaceID) AND tc.DestInterfaceID IS NOT NULL AND tc.SrcInterfaceID IS NOT NULL AND tc.LayerType = 'L2'
LEFT JOIN Orion.NPM.Interfaces i ON i.InterfaceID = tc.DestInterfaceID OR i.InterfaceID = tc.SrcInterfaceID WHERE Interfaces.DuplexMode != i.DuplexMode AND Interfaces.DuplexMode > 1 AND i.DuplexMode > 1
How can i add the City is "Denver", and the Department is "Accounting" fields to this query?
Thanks!