Powercode will give you daily break down but that doesn't identify which PC Xbox or phone did it.
Josh Luthman Office: 937-552-2340 Direct: 937-552-2343 1100 Wayne St Suite 1337 Troy, OH 45373 On Sep 17, 2016 2:18 PM, "Mark - Myakka Technologies" <m...@mailmt.com> wrote: > 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 > page. > > > > > -- > Best regards, > Mark mailto:m...@mailmt.com > > Myakka Technologies, Inc. > www.MyakkaTech.com > > Proud Sponsor of the Myakka City Relay For Life > http://www.RelayForLife.org/MyakkaCityFL > > 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ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ ï¿œ > mailto:m...@mailmt.com > > 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 > > > > > > > > > > > > > > > > >