Switches, Hubs, and Modems
cancel
Showing results for 
Search instead for 
Did you mean: 

PCM 2.3 MySQL Query

mmacleod
Occasional Visitor

PCM 2.3 MySQL Query

Hi there,
I am using the MySQL browser to connect to the MySQL PCM database, and it works well, I can see all the tables just fine.
I want to try and write a query that will produce a list of all the ports in my network that are members of a particular VLAN. We have over 400 switches, so this would be very useful, but I can not identify the combination of tables that I would need to link together to get this information. I can see a vlan table, but I cant find the table that gives me what ports are members of which vlan.

Can any one help me with identifying the tables I need?

Many thanks



2 REPLIES
Jason Scott
Regular Advisor

Re: PCM 2.3 MySQL Query

I somehow missed your post. Unfortunately I don't have the answer to your query but wondered if you could confirm how you connected to the database? I've tried but it returns an access denied error even though I'm using a user account that is present on PCM and is authorised for external db access.
Jason Scott
Regular Advisor

Re: PCM 2.3 MySQL Query

Doh, just tried without any password and its connected. Odd. Wish we could delete posts on here :)