Another option is NetFlow. The tough part is tying the user to the IP for a specific date and time. Especially if the IP changes.
We use Calix Flow Analyzer. They purchased the old Xangati platform a few years back. When a user logs in (DHCP through our captive portal), a RADIUS packet goes to the Calix system. It then knows what username had what IP and when. You can use their API to pull reports (hourly, daily, weekly, monthly, etc.). This data could then be fed to your billing system. Not sure if it would work for your application but it may be something worth considering. Charlie __________________________________ Charles Boening Network Manager 800-858-2399 | Office charl...@calore.net<mailto:charl...@calore.net> www.cot.net<http://www.cot.net/> | Find us on Facebook<https://www.facebook.com/pages/Cal-Ore/205066716227707> __________________________________ Cal-Ore | Real. Local. Trusted. Professional. From: Af <af-boun...@afmug.com> On Behalf Of Lewis Bergman Sent: Wednesday, April 4, 2018 11:55 AM To: email@example.com Subject: Re: [AFMUG] usage based billing Well....I pity you on your billing platform but I understand it. I would look into using RADIUS. At least when I was doing it, it was well supported. I can't imagine Cambium would remove the functionality when it already worked. You have to make a number of entries into the config to allow the routers and AP's to forward those packets to the RADIUS server without being rejected but that is a one time config. We used FreeRADIUS when we did it. Don't know what you are using but the feature is part of the RADIUS standard so I would think they would all be capable. On Wed, Apr 4, 2018 at 1:36 PM Dave <dmilho...@wletc.com<mailto:dmilho...@wletc.com>> wrote: Hmm, ok.. We are moving everything towards radius soon anyways for a complete zero touch setup down to techs using tablets for final signature and payment on site. I did not think of radius pulling that data but absolutely. We still use freeside for our billing CRM. Thanks Dave On 04/04/2018 11:32 AM, Lewis Bergman wrote: Well, Are you taking about what to use for billing? There are a few that require edge boxes to monitor traffic. You could use RADIUS. We used to use that. Takes a bit to get it correct but MT supports sending periodic updates with byte counters to track usage. Your billing platform would have to support the logic to pull it from the DB and do some if over x type logic I would guess. On Wed, Apr 4, 2018 at 10:40 AM Dave <dmilho...@wletc.com<mailto:dmilho...@wletc.com>> wrote: Anyone using usage based billing on their networks? If so what are you using? What is good for an all mikrotik routed network? -- -- [cid:part3.FAA2D16A.1EF3A9B1@wletc.com]