VLAN and port count

[sdutto]

Hi all,
I am new on using Cacti.
I manage a network made of Cisco CATos and Cisco Ios equipment. There are different VLAN configured on them.
Now, my boss require me to have a monthly report of how many phisical ports are configured for VLAN X (correspond to one client and we have to tell him how much he have to pay), how many phisical ports are configured on VLAN Y, and so on.
On MacTrack under Mac addresses I can filter for VLAN, but I only see the port that are up and not all the port.

Can you help me? How can I do this?

Thank you for all your help

Simone

[artagel]

There's a pulldown that says show: Most Recent.
If you change that to All, then export, You can use excel to get rid of anything from previous months(this is assuming you have your mactrack retention settings at more than 1 month..I think default is 2 weeks). Then use some excel magic to find only the unique physical ports. Do this by highlighting the ports column, go to the data menu and click advanced in the filters area. Click the unique records check box and hit ok.

Your list will now only show the unique port numbers for that VLAN. In other words, you will only see the port numbers active at any time during that month on that VLAN.
One port could obviously show up on multiple vlans per month.

Anyways, it's not 100% elegant, but it'll get the reports you need.
-Dan