cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 7

UDT EMAILS - ALERT ME WHEN A ROGUE MAC ADDRESS APPEARS ON THE NETWORK - Solarwinds 2020.2

hello ,I have a problem ,i need UDT module,alert me when a rogue mac address appears on the network,and i need alert me switch ip and interface.my software version is 2020.2 HF1。I cannot get the
switch IP and interface information using thwack SQL statement。Are there any SQL
statements available in this version?

 

my email action like this:

Rouge MAC-Address: 00:01:00:01:00:01 Port: ${SQL: SELECT Name from [dbo].[UDT_Port]
WHERE (PortID = (SELECT PortID from [dbo].[UDT_PortToEndpointCurrent] WHERE (EndpointID
= 1)))} IP: ${SQL: SELECT N.IP_Address FROM [dbo].[Nodes] N JOIN [dbo].[UDT_Port] UP ON
(UP.NodeID = N.NodeID) JOIN [dbo].[UDT_PortToEndpointCurrent] P2EC ON (P2EC.PortID =
UP.PortID) WHERE (P2EC.EndpointID = 1)} Port Name: ${SQL: SELECT PortDescription from
[dbo].[UDT_Port] WHERE (PortID = (SELECT PortID from [dbo].[UDT_PortToEndpointCurrent]
WHERE (EndpointID = 1)))} Device: ${SQL: SELECT N.Caption FROM [dbo].[Nodes] N JOIN
[dbo].[UDT_Port] UP ON (UP.NodeID = N.NodeID) JOIN [dbo].[UDT_PortToEndpointCurrent]
P2EC ON (P2EC.PortID = UP.PortID) WHERE (P2EC.EndpointID = 1)}

0 Kudos
1 Reply