I'm using platypus and radius.  I don't know much about powercode, but
I'm assuming they dump the usage into some type of SQL table.

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

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

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

Best regards,
 Mark                            mailto:m...@mailmt.com

Myakka Technologies, Inc.

Proud Sponsor of the Myakka City Relay For Life

Please Donate at Please Donate at http://www.myakkatech.com/RFL.html

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 <m...@mailmt.com> wrote:
TOGs> How are you tracking overall usage now?

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

TOGs> Myakka Technologies, Inc.
TOGs> www.MyakkaTech.com

TOGs> Proud Sponsor of the Myakka City Relay For Life
TOGs> http://www.RelayForLife.org/MyakkaCityFL

TOGs> Please Donate at Please Donate at
TOGs> http://www.myakkatech.com/RFL.html
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 <afmu...@gmail.com> wrote:
TOGs>> Sandvine :-D

TOGs>> ᅵ

TOGs>> Daniel White

TOGs>> Managing Director ᅵ Hardware Distribution Sales

TOGs>> ConVergence Technologies

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

TOGs>> dwh...@converge-tech.com

TOGs>> ᅵ

TOGs>> From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
TOGs>> Sent: Thursday, September 15, 2016 9:37 PM
TOGs>> To:af@afmug.com
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>> <thatoneguyst...@gmail.com> 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. www.avast.com

Reply via email to