2 Replies Latest reply on Aug 11, 2013 5:47 PM by bluefunelemental

    How to search for VLANs by Switchport Interface?

    ClintW
    ClintW Feb 22, 2013 4:50 PM

      Perhaps I am missing something obvious which is a distinct possibility.    So can someone direct me on how to find switchport interfaces and their configured, associated VLAN (id or name) using SolarWinds?

       

      The ideal output would look something like the following but more is always better. 

      Hostname         Interface Name          VLAN ID     VLAN Name

      switchname1     GigabitEthernet1/0/49     101          vlanname101

       

      I have NPM, NCM, UDT (where I would expect to find it), and IPAM modules installed. 

      Versions are:  Orion Core 2012.2.1, IPAM 3.1.1, NCM 7.1.1, NPM 10.4.1, NTA 3.10.0, UDT 2.5.1

       

      UDT -  Is there a way to search by VLAN?

            Here is a SQL Query I found on Thwack posted by sean.martinez (thanks Sean if you happen to read this!) that works but is not something I can share with the team when they need to locate VLANs on a switchport.

           "SELECT IPAddress, HostName, MACAddress, ConnectedTo, PortNumber, PortName, VLAN, NodeStatus, NodeID, PortID, ConnectionType, FirstSeen, ConnectionTypeName  FROM UDT_AllEndPoints"

       

      NCM - A report called Cisco VLANs is worthless.

                We run MST (Multiple Spanning Tree) so all VLANs show up on each switch even when they have no interfaces assigned to a specific VLAN.  Also, the report includes VLANid 1002, 1003, 1004, and 1005 which means the report isn't very polished.

       

      IPAM - Ehh, only if I manually entered all of the VLAN ID stuff would it help.

       

      Any help is appreciated!

       

      Thanks,

      Clint

      “                                 “ ~~Marcel Marceau.

        • Re: How to search for VLANs by Switchport Interface?
          stefanIT
          stefanIT May 16, 2013 5:33 AM (in response to ClintW)

          Hi Clint,

           

          You can do this in NPM with UnDP. Here's an example using Brocade switches:

           

          VLANs.png

           

          I created the above using four OIDs:

           

          1.3.6.1.4.1991.1.1.3.3.5.1.1     snSwIInfoPortNum          Table

          1.3.6.1.4.1991.1.1.3.3.5.1.24   snSwIVlanId                   Table

          1.3.6.1.4.1991.1.1.3.3.5.1.17   snSwIName                   Table

          1.3.6.1.4.1991.1.1.3.3.5.1.4     snSwIInfoTagMode         Table

           

          I created a new  tab in the Network Node view in NPM, created a table resource on that page and assigned the above pollers to the switch nodes.

           

          Hope this helps.

          • Re: How to search for VLANs by Switchport Interface?
            bluefunelemental
            bluefunelemental Aug 11, 2013 5:47 PM (in response to ClintW)

            Late to the post but beside being able to search by VLAN in the UDT search field you can also make a report for it - here's a quick one I created that you can add a where vlanid = 'xxx' at the end to limit your response.

             

            SELECT n.caption, up.portifdescr,up.portdescription,up.speed,case up.duplex when 0 then 'None' when 1 then 'Full' when 2 then 'Half' end,up.administrativestatus,up.operationalstatus,uv.vlanid

            FROM UDT_Port up

            inner join UDT_vlan uv

            on up.portid = uv.portid

            inner join nodes n

            on up.nodeid = n.nodeid