Switches, Hubs, and Modems
1748325 Members
3350 Online
108762 Solutions
New Discussion юеВ

PCM 2.3 MySQL Query

 
mmacleod
New Member

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 2
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 :)