0 Replies Latest reply on Jun 15, 2017 6:31 AM by lucas.martin

    Listing Vlan name and ID for UDT Report




      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:



      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