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

Listing Vlan name and ID for UDT Report

Thwack,

I am using a custom query to pull node name, port name/description, and MAC address associated with that switchport. Is there a way I can also pull in the VLAN name and ID #?

Currently using UDT 3.2.4 and the query below:

SELECT         

m.NodeAccessPoint AS [NodeName]

, m.PortName AS [PortName]

, m.PortDescription AS [PortDescription]

, m.MacAddress As [MACAddress]

FROM ORION.UDT.MACCurrentInformation m

GROUP BY m.NodeAccessPoint, m.PortName, m.PortDescription, m.MacAddress

0 Kudos
0 Replies