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

Layer 2 Interface Names...

Jump to solution

I'm looking for some assistance to help locate a resolution for fixing missing interface alias.   

I was able to walk the MIB for the MOXA manufactured layer 2 and locate the interface name.  Image of the is attached. How do I apply it?

All interfaces in Orion display Ethernet Port X even though the interface is named in the switch config.

udp.JPG

Thank you

Labels (1)
0 Kudos
1 Solution
Level 9

Didn't figure how to pull it automatically but I was able to manage to set the Interface Name in bulk.

I created a Universal Device Poller called Portname and placed it in a table format. 

Then copied the entire table into Excel 

After that copied the node ID from the SQL query into Excel

SELECT 

    Nodes.NodeID, 

    Nodes.Caption AS HostName, 

    Interfaces.InterfaceID, 

    Interfaces.Caption AS Interface, 

    Interfaces.InterfaceAlias 

    

FROM  

    Nodes 

    

LEFT JOIN 

    Interfaces 

    

ON 

    Nodes.NodeID = Interfaces.NodeID 

 

WHERE 

    (Nodes.Vendor LIKE '%Moxa%')  AND (Nodes.Caption LIKE '%SWI%')

 

ORDER BY Nodes.Caption, Interfaces.Caption  

And copied the "Current Status" into another column.  So the excel worksheet looked like a SQL query.  Pasted to notepad to "find and replace" spaces to delete to therefore run a query to finally set the Interface Name. 

EXEC CUSTOM_UpdateInterfaceAlias 'UDP portName','10560'

UDPtable.JPG

View solution in original post

0 Kudos
1 Reply
Level 9

Didn't figure how to pull it automatically but I was able to manage to set the Interface Name in bulk.

I created a Universal Device Poller called Portname and placed it in a table format. 

Then copied the entire table into Excel 

After that copied the node ID from the SQL query into Excel

SELECT 

    Nodes.NodeID, 

    Nodes.Caption AS HostName, 

    Interfaces.InterfaceID, 

    Interfaces.Caption AS Interface, 

    Interfaces.InterfaceAlias 

    

FROM  

    Nodes 

    

LEFT JOIN 

    Interfaces 

    

ON 

    Nodes.NodeID = Interfaces.NodeID 

 

WHERE 

    (Nodes.Vendor LIKE '%Moxa%')  AND (Nodes.Caption LIKE '%SWI%')

 

ORDER BY Nodes.Caption, Interfaces.Caption  

And copied the "Current Status" into another column.  So the excel worksheet looked like a SQL query.  Pasted to notepad to "find and replace" spaces to delete to therefore run a query to finally set the Interface Name. 

EXEC CUSTOM_UpdateInterfaceAlias 'UDP portName','10560'

UDPtable.JPG

View solution in original post

0 Kudos