Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Mon Mar 18, 2019 12:52 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: VLAN and port count
PostPosted: Fri May 04, 2012 5:34 am 
Offline

Joined: Fri May 04, 2012 5:11 am
Posts: 1
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


Top
 Profile  
 
 Post subject: Re: VLAN and port count
PostPosted: Tue Jun 26, 2012 10:02 pm 
Offline
Cacti User

Joined: Wed May 21, 2008 11:33 pm
Posts: 226
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

_________________
Please mark the topic solved if this resolves your problem.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group