Well, i have two offices. Big one - with about 200 workstations and 10 servers, and small one - about 10 workstations and no servers.
Trying to save some money - i have bought a microtik routerboard to manage the small office.
It works well, i have all the VPN needed.
But i need some way to gather traffic statistics, because internet in small office is very expensive. (to punish some video watchers
).
To say simply - i need a way to see, how much does any IP downloads every week.
I tried to google, which tools does mikrotik have.
Looks like there are 2 mechanisms - “Traffic Accounting(http://www.mikrotik.com/documentation/manual_2.6/IP/Accounting.html)” and “Traffic Flow(http://www.mikrotik.com/testdocs/ros/2.9/ip/traffic-flow.php)”
I can install the software, which analyzes traffic information on a server in the big office.
“Traffic Accounting” looks exactly what i need, but the manual suggests processing data with grep|perl. And i am not very proficient in perl or shell-script. Any way, instead of learning new languages, maybe someone has already written a software, which can transform TrafficFlow information in some convenient format (like Mysql+perl+apache)
TrafficFlow manual offers netflow format. Which looks perfect, but there are thousands of programs understanding netflow. Which one should i choose, for such a simple task? (i prefer open source ones, is there any?)
thanks in advance