I am interested in data to assist troubleshooting when a user bridges 2 of our VLANs and we subsequently want to know all the possible locations this may have occurred.
We run +300 vlans on +700 switches (mostly Cisco). I want to be able to query a DB with 'what switches are vlan 5 and vlan 845 on?'. I have looked at a few MIBs that will provide data of switch ports by vlan (unfortunately in hex and not easily adapted to a spreadsheet or DB) but I cannot find a MIB that might provide a table of switchport and vlan.
How do others address this problem?
There is the vmVlan object from the CISCO-VLAN-MEMBERSHIP-MIB. For each switchport, this will indicate the access VLAN of the port. This object will only relibably work for access ports. For trunk ports, you would need to use the vlanTrunkPortVlansEnabled object from the CISCO-VTP-MIB. But that would require you to decode the bit string which specifies which VLANs are enabled on the port.
These are the objects that CiscoWorks Campus Manager users to build its VLAN data.