Hi Philip, This isn't for users to access, we actually don't want to know individual usage, it's for a service for our customers so that when Telstra or somebody wants to sting them stupid money for excess usage or they just want to know where their Internet bandwidth is going we can provide them a report for a snapshot in time. It needs to just be summary information about usage, like top 10 IP's or websites, breakdown of types of usage like social media, email, general browsing etc Regards Paul -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Philip Loenneker Sent: Wednesday, 10 January 2018 11:35 AM To: MikroTik Australia Public List Subject: Re: [MT-AU Public] Internet Usage Reporting device Manageengine have a free netflow analyser... I had a tinker with it a while back. But allowing users to only see their own data would be a challenge. -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Paul Julian Sent: Wednesday, 10 January 2018 11:09 AM To: 'MikroTik Australia Public List' <public@talk.mikrotik.com.au> Subject: Re: [MT-AU Public] Internet Usage Reporting device I would be willing to do that for sure, I suppose everything would probably be in Netflow data, it's just pulling it out and reporting on it. I did consider Netflow or Sflow but the reporting tools seemed a bit hard to find, whereas something that was more targeted at web filtering/proxy seemed to have more reporting options. Regards Paul -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Philip Loenneker Sent: Wednesday, 10 January 2018 11:00 AM To: MikroTik Australia Public List Subject: Re: [MT-AU Public] Internet Usage Reporting device Perhaps you're better off using netflow to record the data, store it in a database, and query the database based on client IP to pull out the information you want... Mikrotk can send the data, at least, but not process it. Then you won't have issues with proxy servers. -----Original Message----- From: Public [mailto:public-bounces@talk.mikrotik.com.au] On Behalf Of Paul Julian Sent: Wednesday, 10 January 2018 10:51 AM To: public@talk.mikrotik.com.au Subject: [MT-AU Public] Internet Usage Reporting device Hi all, Happy New Year BTW ! I am looking to put together a solution which we can provide as a diagnosis service for our customers to help them analyse what is happening on their Internet connection. There are a number of products which can give you information on such things like PfSense, Untangle, BandwidthD etc, but basically I am after something that can report things to the customer, or us actually so that we can then put together a report and recommendations. The sort of things we want to report on are: - Top talkers - Bandwidth used - Application usage We are not interested in tracking end user usage or anything, it's more just so that the customer knows what their Internet is getting used for and how much. I would really love to put this into a Mikrotik Routerboard but can't see how it's possible. I know we will need some type of proxy running like Squid or something, but it's the information gathering and reporting that are important. At this point my best solution seems to be a NUC running windows with Untangle on it and a mAP-2nD or something to redirect the traffic transparently to the NUC Proxy. Has anybody done a project like this before or does anybody have any better suggestions than what I am thinking of at the moment ? Thanks Paul _______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au _______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au _______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au _______________________________________________ Public mailing list Public@talk.mikrotik.com.au http://talk.mikrotik.com.au/mailman/listinfo/public_talk.mikrotik.com.au