Cisco mac-notification

chiefmarriott

Is there a way to get NPM trap viewer to decode Cisco mac-notification SNMP traps?

FormerMember

SolarWinds has solved the problem in NPM 10.1.2

The OIDValue has now the form:

0100.5E00.237D.4A64.3D00.2E00

where 005E is the VLAN in hex (-> 94 dec), 00.237D.4A64.3D is the MAC and 002E is the interface number in hex (-> 46 dec)

The following SQL statement lists the entries from the NetPerfMon database:

SELECT TOP 10 Traps.TrapID, Traps.[DateTime], Traps.[NodeID], Nodes.Caption AS Node,
           substring(TrapVarbinds.OIDValue, 3, 2) + substring(TrapVarbinds.OIDValue, 6, 2) AS VLAN_hex,
           dbo.hex2int(substring(TrapVarbinds.OIDValue, 3, 2) + substring(TrapVarbinds.OIDValue, 6, 2)) AS VLAN,
           substring(TrapVarbinds.OIDValue, 23, 2) + substring(TrapVarbinds.OIDValue, 26, 2) AS Port_hex,
           dbo.hex2int(substring(TrapVarbinds.OIDValue, 23, 2) + substring(TrapVarbinds.OIDValue, 26, 2)) AS Port,
           substring(TrapVarbinds.OIDValue, 8, 15) AS MAC
    FROM [NetPerfMon].[dbo].[TrapVarbinds] INNER JOIN [NetPerfMon].[dbo].[Traps]
                                           ON [NetPerfMon].[dbo].[Traps].TrapID = [NetPerfMon].[dbo].[TrapVarbinds].TrapID
                                           INNER JOIN [NetPerfMon].[dbo].[Nodes]
                                           ON [NetPerfMon].[dbo].[Traps].NodeID = [NetPerfMon].[dbo].[Nodes].NodeID
    WHERE TrapVarbinds.OIDName = 'cmnHistMacChangedMsg.1'
    ORDER BY Traps.[DateTime] DESC

 

Where hex2int is:

CREATE function [dbo].[hex2int](@s varchar(16)) --Convert hex to bigint
RETURNS bigint -- e.g. select dbo.hex2int('7ff2a5')
AS
BEGIN
    SET @s=upper(@s)
    DECLARE @i int, @len int, @c char(1), @result bigint
    SET @len = len(@s)
    SET @i = @len
    SET @result = CASE WHEN @len>0 THEN 0 END
    WHILE (@i>0)
    BEGIN
        SET @c = substring(@s, @i, 1)
        SET @result = @result + (ASCII(@c) - (CASE WHEN @c between 'A' and 'F' THEN 55
                                                    ELSE CASE WHEN @c between '0' and '9' THEN 48
                                                    END
                                               END)) * power(16., @len-@i)
        SET @i = @i-1
    END -- while
    RETURN @result
END -- function

 

Thomas