Email Subscription Notifications Suspended Temporarily
We are in the process of making navigation in the Servers and Operating Systems forums simpler and more direct. While doing this, we have to temporarily suspend email notifications for subscriptions. If you are subscribed to one or more discussion boards or blogs in the community, please check them daily to see new content. Notifications will be turned back on in a few days. We apologize for any inconvenience this may cause. Thanks, Warren_Admin
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 :)