This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.

You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

How to search for VLANs by Switchport Interface?

ClintW over 11 years ago

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.

0 stefanIT over 10 years ago

Hi Clint,
You can do this in NPM with UnDP. Here's an example using Brocade switches:
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.
Cancel
Vote Up 0 Vote Down

Cancel
0 bluefunelemental over 10 years ago

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
Cancel
Vote Up 0 Vote Down

Cancel