Email bandwith usage per MAC address
I have just set up a pfsense system running the latest 2.3.2, it is working well.
What I want to do is have a daily text email that sends me the total bandwidth usage per MAC address, I have the mail package installed and that sends various logs to me periodically, but I have not found a way to get the details I need, I am happy to write scripts + cron jobs etc.. to do this, I am just not sure what tools are available to gather this data.
thanks for any help
Probably need to send softflow data to something that can parse that out for you. Softflow probably won't give you layer 2 information so you'll probably have to match that up with DHCP data or something.
Splunk or maybe graylog can probably do it if fed the right information.
thanks, I do not really want to run another system, is it possible with in built tools or plugins, if it is done by IP address rather then MAC address?, I could just get the MAC address to IP look up from the lease information and replace the details later?
Maybe darkstat, maybe ntopng, maybe status_traffic_totals if any of those give you what you're looking for.
ntopng has the data i want, but I can not see how to extract it with a command to include the data in the email report, ntopng cli manpage just looks like configuration options, not extraction options.