I was trying to work within Steve's budget.

Also, I should give a disclaimer.  In my previous life, I was a
programmer.  I still love to program.  Any excuse I get to write even
a small script/program, I'll do it.

Case in point is netflow.  I wanted to track our nat users.  Mikrotik,
starting with 6.29, added NAT data to the netflow export.  I looked at
all the collectors out there and decided they were way overkill for
what I wanted.  So, I took a day and wrote my own netflow collector
using perl.  Just grabs the netflow data, filters out the garbage, and
writes to a tab-delimited text file base of the date and hour.  Very
simple.  Does exactly what I needed.

Best regards,

Myakka Technologies, Inc.

Proud Sponsor of the Myakka City Relay For Life

Please Donate at Please Donate at

Saturday, September 17, 2016, 2:37:48 PM, you wrote:

JL> Netflow would do that.ᅵ Procera might, and it's a big ass BMU.

JL> Josh Luthman
JL> Office: 937-552-2340
JL> Direct: 937-552-2343
JL> 1100 Wayne St
JL> Suite 1337
JL> Troy, OH 45373

JL> On Sep 17, 2016 2:28 PM, "That One Guy /sarcasm"
JL> <> wrote:
JL> I actually wasnt even looking for granular to the PC, I was
JL> just more curious about getting the service or source.

JL> I got on their AirRouter, there is an XboxOne, so thats probably the cuplrit

JL> There is also a directv and 4 odd vendor MACs im assuming are
JL> the directv slingthings s there is that

JL> long term torch logging would have sufficed at the site router

JL> On Sat, Sep 17, 2016 at 1:23 PM, Josh Luthman
JL> <> wrote:
JL> Powercode will give you daily break down but that doesn't
JL> identify which PC Xbox or phone did it.

JL> Josh Luthman
JL> Office: 937-552-2340
JL> Direct: 937-552-2343
JL> 1100 Wayne St
JL> Suite 1337
JL> Troy, OH 45373

JL> On Sep 17, 2016 2:18 PM, "Mark - Myakka Technologies" <> 
JL> I'm using platypus and radius.ᅵ I don't know much about powercode, but
JL> I'm assuming they dump the usage into some type of SQL table.

JL> I wanted a finer detailed usage, so I added some code to the PLAT SQL
JL> database to give me upload and download by hour for for each user in a
JL> different table.

JL> Took me a few days to figure out how to do it.ᅵ Someone that knows SQL
JL> could bang it out in a few hours tops.ᅵ Most of my time was
JL> researching SQL triggers.

JL> Having it broken down by hour helps when talking to customers.ᅵ I also
JL> wrote some CGI scripts, so the customers can access the data via a web
JL> page.

JL> --
JL> Best regards,
JL> ᅵMarkᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ

JL> Myakka Technologies, Inc.

JL> Proud Sponsor of the Myakka City Relay For Life

JL> Please Donate at Please Donate at
JL> ------

JL> Saturday, September 17, 2016, 2:05:03 PM, you wrote:

TOGs>> powercode

TOGs>> On Sat, Sep 17, 2016 at 12:47 PM, Mark - Myakka
TOGs>> Technologies <> wrote:
TOGs>> How are you tracking overall usage now?

TOGs>> --
TOGs>> Best regards,
TOGs>> ᅵMarkᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ
TOGs>> ᅵ ᅵ

TOGs>> Myakka Technologies, Inc.

TOGs>> Proud Sponsor of the Myakka City Relay For Life

TOGs>> Please Donate at Please Donate at
TOGs>> ------

TOGs>> Friday, September 16, 2016, 12:40:59 AM, you wrote:

TOGs>>> I forgot to caveat the "I want to" with the "I have 0
TOGs>>> funding from the boss purse"

TOGs>>> On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <> 
TOGs>>> Sandvine :-D

TOGs>>> ᅵ

TOGs>>> Daniel White

TOGs>>> Managing Director ï¿  Hardware Distribution Sales

TOGs>>> ConVergence Technologies

TOGs>>> Cell: +1 (303) 746-3590


TOGs>>> ᅵ

TOGs>>> From: Af [] On Behalf Of Josh Reynolds
TOGs>>> Sent: Thursday, September 15, 2016 9:37 PM
TOGs>>> Subject: Re: [AFMUG] documenting customer usage

TOGs>>> ᅵ

TOGs>>> Procera :P

TOGs>>> ᅵ

TOGs>>> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm"
TOGs>>> <> wrote:

TOGs>>> so we got this:

TOGs>>> "Can yotu help us somehow figure out what is using all of
TOGs>>> our data? We have looked at the daily usage and can not figure
TOGs>>> it out. There are days that we have been gone for several hours
TOGs>>> and the usage is VERY high. Then days we are home have been
TOGs>>> extremely low. We are at a loss; can you help us or recommend
TOGs>>> someone who can. Is there a way to break this down hourly?
TOGs>>> Thanks!
TOGs>>> --"

TOGs>>> ᅵ

TOGs>>> ᅵ

TOGs>>> this is the one in ten request, the other 9 are normally
TOGs>>> "we didnt do this you people are lying,we never use the
TOGs>>> internet, our kids follow rules, youre cheating us" in a real
TOGs>>> catty voice

TOGs>>> ᅵ

TOGs>>> ᅵ

TOGs>>> screw those 9 douches, its usually one of the spouses
TOGs>>> porn affliction, the kids game console. or the fact they leave 5
TOGs>>> units running in the house with netflix on autoplay, if theyre
TOGs>>> not illegally torrenting some shit.

TOGs>>> ᅵ

TOGs>>> ᅵ

TOGs>>> but, there is the one, who arent cocks, they genuinely
TOGs>>> want to know. We arent providing them a router, so monitoring
TOGs>>> from there directly is out

TOGs>>> ᅵ

TOGs>>> we just recently moved DNS to us (huge value I have
TOGs>>> already found) So whats the best way (to the account, not the
TOGs>>> individual machine) to track this down, in our environment, We
TOGs>>> have mikrotik 1100ahx2 from to AP to the edge, and for the firs
TOGs>>> time, I actually want to set up a tool to help the 10 percent
TOGs>>> and if you guys who know more than me can spit out a script to
TOGs>>> drop in to monitor this customer I can pretend I have value
TOGs>>> within th company. .

TOGs>>> ᅵ

TOGs>>> ᅵ

TOGs>>> ᅵ

TOGs>>> If you only see yourself as part of the team but
TOGs>>> youᅵ don'tᅵ see your team as part of yourself you haveᅵ already
TOGs>>> failed as part of the team.

TOGs>>>ᅵ ᅵVirus-free.

Reply via email to