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!
“ “ ~~Marcel Marceau.
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
You can do this in NPM with UnDP. Here's an example using Brocade switches:
I created the above using four OIDs:
126.96.36.199.4.19188.8.131.52.184.108.40.206 snSwIInfoPortNum Table
220.127.116.11.4.1918.104.22.168.22.214.171.124 snSwIVlanId Table
126.96.36.199.4.19188.8.131.52.184.108.40.206 snSwIName Table
220.127.116.11.4.1918.104.22.168.22.214.171.124 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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.