Re: [AFMUG] documenting customer usage

2016-09-17 Thread George Skorup
   JL> Proud Sponsor of the Myakka City Relay For Life
JL> http://www.RelayForLife.org/MyakkaCityFL
<http://www.RelayForLife.org/MyakkaCityFL>

JL> Please Donate at Please Donate at
JL> http://www.myakkatech.com/RFL.html
<http://www.myakkatech.com/RFL.html>
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 <m...@mailmt.com <mailto:m...@mailmt.com>>
wrote:
TOGs>> How are you tracking overall usage now?



TOGs>> --
TOGs>> Best regards,
TOGs>> ï¿ Markï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿ ï¿  ï¿  ï¿  ï¿
TOGs>> ï¿  ï¿  mailto:m...@mailmt.com <mailto:m...@mailmt.com>

TOGs>> Myakka Technologies, Inc.
TOGs>> www.MyakkaTech.com <http://www.MyakkaTech.com>

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

TOGs>> Please Donate at Please Donate at
TOGs>> http://www.myakkatech.com/RFL.html
<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 <mailto: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 <tel:%2B1%20%28303%29%20746-3590>

TOGs>>> dwh...@converge-tech.com <mailto:dwh...@converge-tech.com>

TOGs>>> ᅵ

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































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




Re: [AFMUG] documenting customer usage

2016-09-17 Thread Mark - Myakka Technologies
akkaTech.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
TOGs>>>> <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






































Re: [AFMUG] documenting customer usage

2016-09-17 Thread That One Guy /sarcasm
>> TOGs>> --
>> TOGs>> Best regards,
>> TOGs>> ï¿ Markï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿
>> TOGs>> ï¿  ï¿  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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>


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


Re: [AFMUG] documenting customer usage

2016-09-17 Thread That One Guy /sarcasm
that would work for refering to timestamps on our DMCA complaints on our
nat customers

On Sat, Sep 17, 2016 at 1:58 PM, Mark - Myakka Technologies <m...@mailmt.com
> wrote:

> Josh,
>
> 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,
>  Markmailto: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: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> <thatoneguyst...@gmail.com> 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> <j...@imaginenetworksllc.com> 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" <m...@mailmt.com>
> wrote:
> 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ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ mailto:
> m...@mailmt.com
>
> JL> Myakka Technologies, Inc.
> JL> www.MyakkaTech.com
>
> JL> Proud Sponsor of the Myakka City Relay For Life
> JL> http://www.RelayForLife.org/MyakkaCityFL
>
> JL> Please Donate at Please Donate at
> JL> http://www.myakkatech.com/RFL.html
> 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 <m...@mailmt.com> wrote:
> TOGs>> How are you tracking overall usage now?
>
>
>
> TOGs>> --
> TOGs>> Best regards,
> TOGs>> ï¿ Markï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿
> TOGs>> ï¿  ï¿  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>

Re: [AFMUG] documenting customer usage

2016-09-17 Thread Josh Luthman
Netflow is free...

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

On Sep 17, 2016 2:58 PM, "Mark - Myakka Technologies" <m...@mailmt.com>
wrote:

> Josh,
>
> 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,
>  Markmailto: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: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> <thatoneguyst...@gmail.com> 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> <j...@imaginenetworksllc.com> 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" <m...@mailmt.com>
> wrote:
> 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ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ mailto:
> m...@mailmt.com
>
> JL> Myakka Technologies, Inc.
> JL> www.MyakkaTech.com
>
> JL> Proud Sponsor of the Myakka City Relay For Life
> JL> http://www.RelayForLife.org/MyakkaCityFL
>
> JL> Please Donate at Please Donate at
> JL> http://www.myakkatech.com/RFL.html
> 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 <m...@mailmt.com> wrote:
> TOGs>> How are you tracking overall usage now?
>
>
>
> TOGs>> --
> TOGs>> Best regards,
> TOGs>> ï¿ Markï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿  ï¿
> TOGs>> ï¿  ï¿  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 

Re: [AFMUG] documenting customer usage

2016-09-17 Thread Mark - Myakka Technologies
Josh,

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,
 Markmailto: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: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> <thatoneguyst...@gmail.com> 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> <j...@imaginenetworksllc.com> 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" <m...@mailmt.com> 
wrote:
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ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ 
mailto:m...@mailmt.com

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

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

JL> Please Donate at Please Donate at
JL> http://www.myakkatech.com/RFL.html
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 <m...@mailmt.com> wrote:
TOGs>> How are you tracking overall usage now?



TOGs>> --
TOGs>> Best regards,
TOGs>> ᅵMarkᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ
TOGs>> ᅵ ᅵ 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&

Re: [AFMUG] documenting customer usage

2016-09-17 Thread Josh Luthman
Netflow would do that.  Procera might, and it's a big ass BMU.

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

On Sep 17, 2016 2:28 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com>
wrote:

> I actually wasnt even looking for granular to the PC, I was just more
> curious about getting the service or source.
>
> I got on their AirRouter, there is an XboxOne, so thats probably the
> cuplrit
>
> There is also a directv and 4 odd vendor MACs im assuming are the directv
> slingthings s there is that
>
> long term torch logging would have sufficed at the site router
>
> On Sat, Sep 17, 2016 at 1:23 PM, Josh Luthman <j...@imaginenetworksllc.com
> > wrote:
>
>> 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,
>>>  Markmailto: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:
>>>
>>>
>&

Re: [AFMUG] documenting customer usage

2016-09-17 Thread Mark - Myakka Technologies
Watch out for DirecTV.  We have had many cases after power outages
that something gets corrupt on the DVR.  It will then try to download
any of the corrupt recorded shows via the internet.

Not to mention their turn back time option.  If you come home and miss
the first 10 minutes of the 2 hour cross over special of Hoarders and
American Pickers and use the turn back time feature,  You are now
watching 2 hours of IPTV over your Internet connection.



-- 
Best regards,
 Markmailto: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:28:42 PM, you wrote:

TOGs> I actually wasnt even looking for granular to the PC, I
TOGs> was just more curious about getting the service or source.


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


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


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


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

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


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

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

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

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




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> 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>> ᅵ ᅵ 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 

Re: [AFMUG] documenting customer usage

2016-09-17 Thread Mark - Myakka Technologies
Josh,

Can you break that daily down to the hour? Sometimes that is a huge
help.

-- 
Best regards,
 Markmailto: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:23:36 PM, you 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" <m...@mailmt.com> 
wrote:
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ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ 
mailto:m...@mailmt.com

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

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

JL> Please Donate at Please Donate at
JL> http://www.myakkatech.com/RFL.html
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 <m...@mailmt.com> wrote:
TOGs>> How are you tracking overall usage now?



TOGs>> --
TOGs>> Best regards,
TOGs>> ᅵMarkᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ ᅵ
TOGs>> ᅵ ᅵ 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

Re: [AFMUG] documenting customer usage

2016-09-17 Thread That One Guy /sarcasm
I actually wasnt even looking for granular to the PC, I was just more
curious about getting the service or source.

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

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

long term torch logging would have sufficed at the site router

On Sat, Sep 17, 2016 at 1:23 PM, Josh Luthman <j...@imaginenetworksllc.com>
wrote:

> 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,
>>  Markmailto: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 

Re: [AFMUG] documenting customer usage

2016-09-17 Thread Josh Luthman
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,
>  Markmailto: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
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>


Re: [AFMUG] documenting customer usage

2016-09-17 Thread Mark - Myakka Technologies
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,
 Markmailto: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


















Re: [AFMUG] documenting customer usage

2016-09-17 Thread That One Guy /sarcasm
powercode

On Sat, Sep 17, 2016 at 12:47 PM, Mark - Myakka Technologies <
m...@mailmt.com> wrote:

> How are you tracking overall usage now?
>
>
>
> --
> Best regards,
>  Markmailto: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
> --
>
> Friday, September 16, 2016, 12:40:59 AM, you wrote:
>
> TOGs> I forgot to caveat the "I want to" with the "I have 0 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
>
>
>
>
>
>
>
>
>


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


Re: [AFMUG] documenting customer usage

2016-09-17 Thread Mark - Myakka Technologies
How are you tracking overall usage now?



-- 
Best regards,
 Markmailto: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
--

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

TOGs> I forgot to caveat the "I want to" with the "I have 0 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










Re: [AFMUG] documenting customer usage

2016-09-17 Thread Mark - Myakka Technologies
This is one of my biggest issues.  Customers that want to see what is
going on inside their network.  I have come to the conclusion, the
only way to do this is a managed router solution.

Years ago we found the skydog router, it was a great system.  We were
ready to standardize on their system, but comcast bought them and they
disappeared.

Been fiddling with some roll your own stuff using openwrt.  Not too
bad, not sure how it will scale though.

I'm currently testing one system that is suppose to have the inside BW
monitoring at the end of the month.  Have another system coming in
next week that claims to have it all running now.

I'll be making my final decision in November.  Want to give the
cambium guys one more look at the show to see how their stuff has
changed in a year.

We are looking at doing the managed router at about $7.95-$9.95 per
month.  Starting to see more and more people interested in a managed
router.



-- 
Best regards,
 Markmailto: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
--

Thursday, September 15, 2016, 9:36:03 PM, you 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> 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> 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> 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> 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> 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.




  



Re: [AFMUG] documenting customer usage

2016-09-16 Thread Dennis Burgess
Or just use a device that won’t let one device eat up the entire pipe?


Thanks,

Dennis Burgess – Network Engineer/Consutant
MikroTik Certified 
Trianer/Consultant<http://www.linktechs.net/productcart/pc/viewcontent.asp?idpage=5>
 – MTCNA, MTCRE, MTCWE, MTCTCE, MTCINE
Cambium ePMP Certified, Telrad Certified, Cisco CCNA

For Wireless Hardware/Routers visit www.linktechs.net<http://www.linktechs.net/>
RF Mapping: www.towercoverage.com<http://www.towercoverage.com/>
Office: 314-735-0270
dmburg...@linktechs.net<mailto:dmburg...@linktechs.net>

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Eric Kuhnke
Sent: Friday, September 16, 2016 11:26 AM
To: af@afmug.com
Subject: Re: [AFMUG] documenting customer usage

They want to know specifically what device/IP address/MAC address on their LAN 
is moving a lot of traffic (like a kid's gaming PC with Steam, or an XboxOne, 
or whatever)?  I would suggest some sort of home router that can do per device 
cumulative accounting like this. The $50 ubnt edgerouter has this in its GUI, I 
believe.  Or the $99 one.

On Thu, Sep 15, 2016 at 6:36 PM, That One Guy /sarcasm 
<thatoneguyst...@gmail.com<mailto:thatoneguyst...@gmail.com>> wrote:

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


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


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


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

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



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



Re: [AFMUG] documenting customer usage

2016-09-16 Thread Josh Reynolds
With DPI turned on (and facing LAN) all of the edgerouter models can.

On Sep 16, 2016 11:26 AM, "Eric Kuhnke"  wrote:

> They want to know specifically what device/IP address/MAC address on their
> LAN is moving a lot of traffic (like a kid's gaming PC with Steam, or an
> XboxOne, or whatever)?  I would suggest some sort of home router that can
> do per device cumulative accounting like this. The $50 ubnt edgerouter has
> this in its GUI, I believe.  Or the $99 one.
>
> On Thu, Sep 15, 2016 at 6:36 PM, That One Guy /sarcasm <
> thatoneguyst...@gmail.com> wrote:
>
>>
>> so we got this:
>> "Can yotu help us somehow figure out what is using all of our data? We
>> have looked at the daily usage and can not figure it out. There are days
>> that we have been gone for several hours and the usage is VERY high. Then
>> days we are home have been extremely low. We are at a loss; can you help us
>> or recommend someone who can. Is there a way to break this down hourly?
>> Thanks!
>> --"
>>
>>
>> this is the one in ten request, the other 9 are normally "we didnt do
>> this you people are lying,we never use the internet, our kids follow rules,
>> youre cheating us" in a real catty voice
>>
>>
>> screw those 9 douches, its usually one of the spouses porn affliction,
>> the kids game console. or the fact they leave 5 units running in the house
>> with netflix on autoplay, if theyre not illegally torrenting some shit.
>>
>>
>> but, there is the one, who arent cocks, they genuinely want to know. We
>> arent providing them a router, so monitoring from there directly is out
>>
>> we just recently moved DNS to us (huge value I have already found) So
>> whats the best way (to the account, not the individual machine) to track
>> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
>> edge, and for the firs time, I actually want to set up a tool to help the
>> 10 percent and if you guys who know more than me can spit out a script to
>> drop in to monitor this customer I can pretend I have value within th
>> company. .
>>
>>
>>
>> If you only see yourself as part of the team but you don't see your team
>> as part of yourself you have already failed as part of the team.
>>
>
>


Re: [AFMUG] documenting customer usage

2016-09-16 Thread Eric Kuhnke
They want to know specifically what device/IP address/MAC address on their
LAN is moving a lot of traffic (like a kid's gaming PC with Steam, or an
XboxOne, or whatever)?  I would suggest some sort of home router that can
do per device cumulative accounting like this. The $50 ubnt edgerouter has
this in its GUI, I believe.  Or the $99 one.

On Thu, Sep 15, 2016 at 6:36 PM, That One Guy /sarcasm <
thatoneguyst...@gmail.com> wrote:

>
> so we got this:
> "Can yotu help us somehow figure out what is using all of our data? We
> have looked at the daily usage and can not figure it out. There are days
> that we have been gone for several hours and the usage is VERY high. Then
> days we are home have been extremely low. We are at a loss; can you help us
> or recommend someone who can. Is there a way to break this down hourly?
> Thanks!
> --"
>
>
> this is the one in ten request, the other 9 are normally "we didnt do this
> you people are lying,we never use the internet, our kids follow rules,
> youre cheating us" in a real catty voice
>
>
> screw those 9 douches, its usually one of the spouses porn affliction, the
> kids game console. or the fact they leave 5 units running in the house with
> netflix on autoplay, if theyre not illegally torrenting some shit.
>
>
> but, there is the one, who arent cocks, they genuinely want to know. We
> arent providing them a router, so monitoring from there directly is out
>
> we just recently moved DNS to us (huge value I have already found) So
> whats the best way (to the account, not the individual machine) to track
> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
> edge, and for the firs time, I actually want to set up a tool to help the
> 10 percent and if you guys who know more than me can spit out a script to
> drop in to monitor this customer I can pretend I have value within th
> company. .
>
>
>
> If you only see yourself as part of the team but you don't see your team
> as part of yourself you have already failed as part of the team.
>


Re: [AFMUG] documenting customer usage

2016-09-16 Thread SmarterBroadband
What Procera / Powercode break?

Are they not working together anymore?

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of That One Guy /sarcasm
Sent: Thursday, September 15, 2016 7:46 PM
To: af@afmug.com
Subject: Re: [AFMUG] documenting customer usage

 

lol, for my requested purpose other than dpi, i dont think the mutli 10k 
solution we were quoted was it.

 

 

not being a jerk, but if the unit is on your network, how does it mitigate a 
ddos? will it speak with my upstream that doesnt support blackholes with bgp?

is it working with powercode again since it broke operations with powercode?

will they provide me a document that says theyre legal with the whole "open 
internet" nonsense

 

I really liked them, til we priced them. We invested with netenforcer some time 
ago, it was great at the time because p2p was so destructive to a network at 
the time, but once we moved bandidth beyond a couple T1s they decided we needed 
a good old fashioned no spit raping. I say the same structure in procera... 
then the powercode break happenned, and I didnt care if it got resolved, it 
broke.

 

 

I can toss a sniifer on or dump a mirrored port. I think I may have indicated I 
care more than I do. I was primarily asking if my current environment had a 
tool that consiststed of this much work: what IP are you curious about? (I 
input the IP, maybe click my mouse less than 10 times and key in less than ten 
more digits) and i come bak and have a torchish output saying what happenned.

 

if it doesnt stay within that simple of a solution with the gear I have, I dont 
really care to give the ten percent who arent dicks any different answer than 
the 90 who are

 

 

On Thu, Sep 15, 2016 at 8:52 PM, Josh Reynolds <j...@kyneticwifi.com> wrote:

Huh?

DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?

You talk a lot about a product it doesn't seem like you've ever used.

 

On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com> 
wrote:

yeah, crazy thing about that, not looking to drop multiple 10ks at once to have 
a nice guy on a product that quits working with the management system and is 
questionably legal beyond monitoring :-)

 

On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds <j...@kyneticwifi.com> wrote:

Procera :P

 

On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com> 
wrote:




so we got this:

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

 

 

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

 

 

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

 

 

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

 

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

 

 

 

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





 

-- 

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

 





 

-- 

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



Re: [AFMUG] documenting customer usage

2016-09-16 Thread Chuck McCown
I think so, but I don’t personally provision or do  support so my knowledge is 
from the sales pitch info.  We use it and customers love it.  

From: Ken Hohhof 
Sent: Friday, September 16, 2016 9:54 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

I guess my question is whether you can go to My Calix or whatever the user 
portal is called and see data usage by device, by application, or both.  That 
would take care of Steve’s situation, I think.  Customer wants to know what is 
using all those gigabytes.


From: Chuck McCown 
Sent: Friday, September 16, 2016 10:29 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

I honestly don’t know the cost of the cloud control app.  I think you have to 
pay Calix something so parents can control the router.  

From: Ken Hohhof 
Sent: Friday, September 16, 2016 9:26 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

I wonder if people call the water company asking what is using so much water?  
Or the electric company?  Probably they refer you to a list of most common 
reasons like taking long showers, toilet always running, leaking garden hose.

Also, anybody currently using the Calix Gigacenters, is this something the 
customer can get from the cloud based user portal?  Data usage by device and/or 
application?  That really seems like the ultimate solution, charge the customer 
a monthly fee for a something they can use themselves to answer such questions.


From: That One Guy /sarcasm 
Sent: Friday, September 16, 2016 9:53 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

Its not something I want to drop a huge amount of time or effort into, I was 
hoping there was just a quick thing. We have fortigates we can drop in at the 
premise to log everything, but its no big deal. 
theyre on a 300 gb plan, usually use less than 100, but theyre sitting at 260 
today

On Fri, Sep 16, 2016 at 7:34 AM, Ken Hohhof <af...@kwisp.com> wrote:

  Or customer could check this from his end.  Problem is customers don’t want 
to do any work or learn any technology, and they don’t want to pay the guy.  
I’m sure there are computer techs who would come out and do this for a fee.

  If the data usage is making their Internet “slow”, there’s the tried and true 
method of turning devices off until the problem goes away.

  On  computers at least, there is software that can be used to see what 
application is using bandwidth:
  
http://www.howtogeek.com/howto/43713/how-to-monitor-the-bandwidth-consumption-of-individual-applications/

  That gets less useful as people use “devices” like phones, game consoles, 
streaming devices, and iOT instead of actual computers.

  I am sometimes willing to watch a realtime graph of bandwidth usage as the 
customer turns off various devices or unplugs them.  Again, unfortunately, this 
was easier when devices plugged in with an Ethernet cable instead of WiFi.  
Plus apps run all the time on portable devices.


  From: Daniel White 
  Sent: Friday, September 16, 2016 5:33 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] documenting customer usage

  Okay so outside of my snarky response – I’d first say Sandvine is about to 
get really exciting.  But I’ll leave that to our vendor session on October 10th 
at WISPAPALOOZA.



  Steve – my no budget friend with monkeys throwing poo at him.



  There are a few questions you have to ask before I think any of us can give 
you any good advice:



  -  How much do you really want to help from a time/resource 
perspective?  Most ISP’s would say the router is their demark and they cannot 
troubleshoot beyond that and suggest a local computer tech to figure it out.

  -  Now let’s assume this is the bosses next door neighbor… so common 
sense goes out the window and help at all costs.  What router do you have at 
the customer prem?  For instance, something like a Cambium R200 router would 
tell you what device has the heavy usage… and that might narrow it down enough

  -  Do you have hardware lying around you could replace the customer 
router to get better metrics?  Is that a step you want to take?  Mikrotik on 
the customer prem would give you a lot of information

  -  What resources do you have at the tower?  You can look at the 
traffic to and from the customer… but what you’re really trying to identify may 
be encrypted… this is where something like Sandvine/Procera would help



  To me – this is the perfect example of why to offer a managed WiFi solution.  
You control the router at the customer prem, you have more resources to help 
troubleshoot some of this.  And the best part… your collecting money every 
month for the privilege.



  Also –why is the customer concerned about the usage?  Do you do UBB and they 
are hitting their cap?



  Daniel White

  Managing Director – Hardware Distribution Sales

  ConVergence Technologies

  Cell: +1 (303) 746-3590

  dwh...@converge-tech.com



  Fr

Re: [AFMUG] documenting customer usage

2016-09-16 Thread Ken Hohhof
I guess my question is whether you can go to My Calix or whatever the user 
portal is called and see data usage by device, by application, or both.  That 
would take care of Steve’s situation, I think.  Customer wants to know what is 
using all those gigabytes.


From: Chuck McCown 
Sent: Friday, September 16, 2016 10:29 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

I honestly don’t know the cost of the cloud control app.  I think you have to 
pay Calix something so parents can control the router.  

From: Ken Hohhof 
Sent: Friday, September 16, 2016 9:26 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

I wonder if people call the water company asking what is using so much water?  
Or the electric company?  Probably they refer you to a list of most common 
reasons like taking long showers, toilet always running, leaking garden hose.

Also, anybody currently using the Calix Gigacenters, is this something the 
customer can get from the cloud based user portal?  Data usage by device and/or 
application?  That really seems like the ultimate solution, charge the customer 
a monthly fee for a something they can use themselves to answer such questions.


From: That One Guy /sarcasm 
Sent: Friday, September 16, 2016 9:53 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

Its not something I want to drop a huge amount of time or effort into, I was 
hoping there was just a quick thing. We have fortigates we can drop in at the 
premise to log everything, but its no big deal. 
theyre on a 300 gb plan, usually use less than 100, but theyre sitting at 260 
today

On Fri, Sep 16, 2016 at 7:34 AM, Ken Hohhof <af...@kwisp.com> wrote:

  Or customer could check this from his end.  Problem is customers don’t want 
to do any work or learn any technology, and they don’t want to pay the guy.  
I’m sure there are computer techs who would come out and do this for a fee.

  If the data usage is making their Internet “slow”, there’s the tried and true 
method of turning devices off until the problem goes away.

  On  computers at least, there is software that can be used to see what 
application is using bandwidth:
  
http://www.howtogeek.com/howto/43713/how-to-monitor-the-bandwidth-consumption-of-individual-applications/

  That gets less useful as people use “devices” like phones, game consoles, 
streaming devices, and iOT instead of actual computers.

  I am sometimes willing to watch a realtime graph of bandwidth usage as the 
customer turns off various devices or unplugs them.  Again, unfortunately, this 
was easier when devices plugged in with an Ethernet cable instead of WiFi.  
Plus apps run all the time on portable devices.


  From: Daniel White 
  Sent: Friday, September 16, 2016 5:33 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] documenting customer usage

  Okay so outside of my snarky response – I’d first say Sandvine is about to 
get really exciting.  But I’ll leave that to our vendor session on October 10th 
at WISPAPALOOZA.



  Steve – my no budget friend with monkeys throwing poo at him.



  There are a few questions you have to ask before I think any of us can give 
you any good advice:



  -  How much do you really want to help from a time/resource 
perspective?  Most ISP’s would say the router is their demark and they cannot 
troubleshoot beyond that and suggest a local computer tech to figure it out.

  -  Now let’s assume this is the bosses next door neighbor… so common 
sense goes out the window and help at all costs.  What router do you have at 
the customer prem?  For instance, something like a Cambium R200 router would 
tell you what device has the heavy usage… and that might narrow it down enough

  -  Do you have hardware lying around you could replace the customer 
router to get better metrics?  Is that a step you want to take?  Mikrotik on 
the customer prem would give you a lot of information

  -  What resources do you have at the tower?  You can look at the 
traffic to and from the customer… but what you’re really trying to identify may 
be encrypted… this is where something like Sandvine/Procera would help



  To me – this is the perfect example of why to offer a managed WiFi solution.  
You control the router at the customer prem, you have more resources to help 
troubleshoot some of this.  And the best part… your collecting money every 
month for the privilege.



  Also –why is the customer concerned about the usage?  Do you do UBB and they 
are hitting their cap?



  Daniel White

  Managing Director – Hardware Distribution Sales

  ConVergence Technologies

  Cell: +1 (303) 746-3590

  dwh...@converge-tech.com



  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
  Sent: Friday, September 16, 2016 1:11 AM
  To: af@afmug.com
  Subject: Re: [AFMUG] documenting customer usage



  Well... sandvine, wind river, etc can cost more than a nice house in San 
Francisco. :)



  

Re: [AFMUG] documenting customer usage

2016-09-16 Thread That One Guy /sarcasm
Actually with the water company, yes. They must be under some mandate of
conservation or something because if the usage pattern gets odd they will
send a guy with a stethoscope out to locate. at least American Water does
around here, it could be a part of their municipal franchise contract though

On Fri, Sep 16, 2016 at 10:26 AM, Ken Hohhof <af...@kwisp.com> wrote:

> I wonder if people call the water company asking what is using so much
> water?  Or the electric company?  Probably they refer you to a list of most
> common reasons like taking long showers, toilet always running, leaking
> garden hose.
>
> Also, anybody currently using the Calix Gigacenters, is this something the
> customer can get from the cloud based user portal?  Data usage by device
> and/or application?  That really seems like the ultimate solution, charge
> the customer a monthly fee for a something they can use themselves to
> answer such questions.
>
>
> *From:* That One Guy /sarcasm <thatoneguyst...@gmail.com>
> *Sent:* Friday, September 16, 2016 9:53 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] documenting customer usage
>
> Its not something I want to drop a huge amount of time or effort into, I
> was hoping there was just a quick thing. We have fortigates we can drop in
> at the premise to log everything, but its no big deal.
> theyre on a 300 gb plan, usually use less than 100, but theyre sitting at
> 260 today
>
> On Fri, Sep 16, 2016 at 7:34 AM, Ken Hohhof <af...@kwisp.com> wrote:
>
>> Or customer could check this from his end.  Problem is customers don’t
>> want to do any work or learn any technology, and they don’t want to pay the
>> guy.  I’m sure there are computer techs who would come out and do this for
>> a fee.
>>
>> If the data usage is making their Internet “slow”, there’s the tried and
>> true method of turning devices off until the problem goes away.
>>
>> On  computers at least, there is software that can be used to see what
>> application is using bandwidth:
>> http://www.howtogeek.com/howto/43713/how-to-monitor-the-
>> bandwidth-consumption-of-individual-applications/
>>
>> That gets less useful as people use “devices” like phones, game consoles,
>> streaming devices, and iOT instead of actual computers.
>>
>> I am sometimes willing to watch a realtime graph of bandwidth usage as
>> the customer turns off various devices or unplugs them.  Again,
>> unfortunately, this was easier when devices plugged in with an Ethernet
>> cable instead of WiFi.  Plus apps run all the time on portable devices.
>>
>>
>> *From:* Daniel White <afmu...@gmail.com>
>> *Sent:* Friday, September 16, 2016 5:33 AM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] documenting customer usage
>>
>>
>> Okay so outside of my snarky response – I’d first say Sandvine is about
>> to get really exciting.  But I’ll leave that to our vendor session on
>> October 10th at WISPAPALOOZA.
>>
>>
>>
>> Steve – my no budget friend with monkeys throwing poo at him.
>>
>>
>>
>> There are a few questions you have to ask before I think any of us can
>> give you any good advice:
>>
>>
>>
>> -  How much do you really want to help from a time/resource
>> perspective?  Most ISP’s would say the router is their demark and they
>> cannot troubleshoot beyond that and suggest a local computer tech to figure
>> it out.
>>
>> -  Now let’s assume this is the bosses next door neighbor… so
>> common sense goes out the window and help at all costs.  What router do you
>> have at the customer prem?  For instance, something like a Cambium R200
>> router would tell you what *device* has the heavy usage… and that might
>> narrow it down enough
>>
>> -  Do you have hardware lying around you could replace the
>> customer router to get better metrics?  Is that a step you want to take?
>> Mikrotik on the customer prem would give you a lot of information
>>
>> -  What resources do you have at the tower?  You can look at the
>> traffic to and from the customer… but what you’re really trying to identify
>> may be encrypted… this is where something like Sandvine/Procera would help
>>
>>
>>
>> To me – this is the perfect example of why to offer a managed WiFi
>> solution.  You control the router at the customer prem, you have more
>> resources to help troubleshoot some of this.  And the best part… your
>> collecting money every month for the privilege.
>>
>>
>>
>> Also –why is the customer concerned about the usage?  Do you do UBB a

Re: [AFMUG] documenting customer usage

2016-09-16 Thread Chuck McCown
I honestly don’t know the cost of the cloud control app.  I think you have to 
pay Calix something so parents can control the router.  

From: Ken Hohhof 
Sent: Friday, September 16, 2016 9:26 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

I wonder if people call the water company asking what is using so much water?  
Or the electric company?  Probably they refer you to a list of most common 
reasons like taking long showers, toilet always running, leaking garden hose.

Also, anybody currently using the Calix Gigacenters, is this something the 
customer can get from the cloud based user portal?  Data usage by device and/or 
application?  That really seems like the ultimate solution, charge the customer 
a monthly fee for a something they can use themselves to answer such questions.


From: That One Guy /sarcasm 
Sent: Friday, September 16, 2016 9:53 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

Its not something I want to drop a huge amount of time or effort into, I was 
hoping there was just a quick thing. We have fortigates we can drop in at the 
premise to log everything, but its no big deal. 
theyre on a 300 gb plan, usually use less than 100, but theyre sitting at 260 
today

On Fri, Sep 16, 2016 at 7:34 AM, Ken Hohhof <af...@kwisp.com> wrote:

  Or customer could check this from his end.  Problem is customers don’t want 
to do any work or learn any technology, and they don’t want to pay the guy.  
I’m sure there are computer techs who would come out and do this for a fee.

  If the data usage is making their Internet “slow”, there’s the tried and true 
method of turning devices off until the problem goes away.

  On  computers at least, there is software that can be used to see what 
application is using bandwidth:
  
http://www.howtogeek.com/howto/43713/how-to-monitor-the-bandwidth-consumption-of-individual-applications/

  That gets less useful as people use “devices” like phones, game consoles, 
streaming devices, and iOT instead of actual computers.

  I am sometimes willing to watch a realtime graph of bandwidth usage as the 
customer turns off various devices or unplugs them.  Again, unfortunately, this 
was easier when devices plugged in with an Ethernet cable instead of WiFi.  
Plus apps run all the time on portable devices.


  From: Daniel White 
  Sent: Friday, September 16, 2016 5:33 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] documenting customer usage

  Okay so outside of my snarky response – I’d first say Sandvine is about to 
get really exciting.  But I’ll leave that to our vendor session on October 10th 
at WISPAPALOOZA.



  Steve – my no budget friend with monkeys throwing poo at him.



  There are a few questions you have to ask before I think any of us can give 
you any good advice:



  -  How much do you really want to help from a time/resource 
perspective?  Most ISP’s would say the router is their demark and they cannot 
troubleshoot beyond that and suggest a local computer tech to figure it out.

  -  Now let’s assume this is the bosses next door neighbor… so common 
sense goes out the window and help at all costs.  What router do you have at 
the customer prem?  For instance, something like a Cambium R200 router would 
tell you what device has the heavy usage… and that might narrow it down enough

  -  Do you have hardware lying around you could replace the customer 
router to get better metrics?  Is that a step you want to take?  Mikrotik on 
the customer prem would give you a lot of information

  -  What resources do you have at the tower?  You can look at the 
traffic to and from the customer… but what you’re really trying to identify may 
be encrypted… this is where something like Sandvine/Procera would help



  To me – this is the perfect example of why to offer a managed WiFi solution.  
You control the router at the customer prem, you have more resources to help 
troubleshoot some of this.  And the best part… your collecting money every 
month for the privilege.



  Also –why is the customer concerned about the usage?  Do you do UBB and they 
are hitting their cap?



  Daniel White

  Managing Director – Hardware Distribution Sales

  ConVergence Technologies

  Cell: +1 (303) 746-3590

  dwh...@converge-tech.com



  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
  Sent: Friday, September 16, 2016 1:11 AM
  To: af@afmug.com
  Subject: Re: [AFMUG] documenting customer usage



  Well... sandvine, wind river, etc can cost more than a nice house in San 
Francisco. :)



  On Sep 15, 2016 11:40 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com> 
wrote:

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



On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <afmu...@gmail.com> wrote:

  Sandvine :-D



  Daniel White

  Managing Director – Hardware Distribution S

Re: [AFMUG] documenting customer usage

2016-09-16 Thread Ken Hohhof
I wonder if people call the water company asking what is using so much water?  
Or the electric company?  Probably they refer you to a list of most common 
reasons like taking long showers, toilet always running, leaking garden hose.

Also, anybody currently using the Calix Gigacenters, is this something the 
customer can get from the cloud based user portal?  Data usage by device and/or 
application?  That really seems like the ultimate solution, charge the customer 
a monthly fee for a something they can use themselves to answer such questions.


From: That One Guy /sarcasm 
Sent: Friday, September 16, 2016 9:53 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

Its not something I want to drop a huge amount of time or effort into, I was 
hoping there was just a quick thing. We have fortigates we can drop in at the 
premise to log everything, but its no big deal. 
theyre on a 300 gb plan, usually use less than 100, but theyre sitting at 260 
today

On Fri, Sep 16, 2016 at 7:34 AM, Ken Hohhof <af...@kwisp.com> wrote:

  Or customer could check this from his end.  Problem is customers don’t want 
to do any work or learn any technology, and they don’t want to pay the guy.  
I’m sure there are computer techs who would come out and do this for a fee.

  If the data usage is making their Internet “slow”, there’s the tried and true 
method of turning devices off until the problem goes away.

  On  computers at least, there is software that can be used to see what 
application is using bandwidth:
  
http://www.howtogeek.com/howto/43713/how-to-monitor-the-bandwidth-consumption-of-individual-applications/

  That gets less useful as people use “devices” like phones, game consoles, 
streaming devices, and iOT instead of actual computers.

  I am sometimes willing to watch a realtime graph of bandwidth usage as the 
customer turns off various devices or unplugs them.  Again, unfortunately, this 
was easier when devices plugged in with an Ethernet cable instead of WiFi.  
Plus apps run all the time on portable devices.


  From: Daniel White 
  Sent: Friday, September 16, 2016 5:33 AM
  To: af@afmug.com 
  Subject: Re: [AFMUG] documenting customer usage

  Okay so outside of my snarky response – I’d first say Sandvine is about to 
get really exciting.  But I’ll leave that to our vendor session on October 10th 
at WISPAPALOOZA.



  Steve – my no budget friend with monkeys throwing poo at him.



  There are a few questions you have to ask before I think any of us can give 
you any good advice:



  -  How much do you really want to help from a time/resource 
perspective?  Most ISP’s would say the router is their demark and they cannot 
troubleshoot beyond that and suggest a local computer tech to figure it out.

  -  Now let’s assume this is the bosses next door neighbor… so common 
sense goes out the window and help at all costs.  What router do you have at 
the customer prem?  For instance, something like a Cambium R200 router would 
tell you what device has the heavy usage… and that might narrow it down enough

  -  Do you have hardware lying around you could replace the customer 
router to get better metrics?  Is that a step you want to take?  Mikrotik on 
the customer prem would give you a lot of information

  -  What resources do you have at the tower?  You can look at the 
traffic to and from the customer… but what you’re really trying to identify may 
be encrypted… this is where something like Sandvine/Procera would help



  To me – this is the perfect example of why to offer a managed WiFi solution.  
You control the router at the customer prem, you have more resources to help 
troubleshoot some of this.  And the best part… your collecting money every 
month for the privilege.



  Also –why is the customer concerned about the usage?  Do you do UBB and they 
are hitting their cap?



  Daniel White

  Managing Director – Hardware Distribution Sales

  ConVergence Technologies

  Cell: +1 (303) 746-3590

  dwh...@converge-tech.com



  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
  Sent: Friday, September 16, 2016 1:11 AM
  To: af@afmug.com
  Subject: Re: [AFMUG] documenting customer usage



  Well... sandvine, wind river, etc can cost more than a nice house in San 
Francisco. :)



  On Sep 15, 2016 11:40 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com> 
wrote:

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



On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <afmu...@gmail.com> wrote:

  Sandvine :-D



  Daniel White

  Managing Director – Hardware Distribution Sales

  ConVergence Technologies

  Cell: +1 (303) 746-3590

  dwh...@converge-tech.com



  From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
  Sent: Thursday, September 15, 2016 9:37 PM
  To: af@afmug.com
 

Re: [AFMUG] documenting customer usage

2016-09-16 Thread That One Guy /sarcasm
Its not something I want to drop a huge amount of time or effort into, I
was hoping there was just a quick thing. We have fortigates we can drop in
at the premise to log everything, but its no big deal.
theyre on a 300 gb plan, usually use less than 100, but theyre sitting at
260 today

On Fri, Sep 16, 2016 at 7:34 AM, Ken Hohhof <af...@kwisp.com> wrote:

> Or customer could check this from his end.  Problem is customers don’t
> want to do any work or learn any technology, and they don’t want to pay the
> guy.  I’m sure there are computer techs who would come out and do this for
> a fee.
>
> If the data usage is making their Internet “slow”, there’s the tried and
> true method of turning devices off until the problem goes away.
>
> On  computers at least, there is software that can be used to see what
> application is using bandwidth:
> http://www.howtogeek.com/howto/43713/how-to-monitor-
> the-bandwidth-consumption-of-individual-applications/
>
> That gets less useful as people use “devices” like phones, game consoles,
> streaming devices, and iOT instead of actual computers.
>
> I am sometimes willing to watch a realtime graph of bandwidth usage as the
> customer turns off various devices or unplugs them.  Again, unfortunately,
> this was easier when devices plugged in with an Ethernet cable instead of
> WiFi.  Plus apps run all the time on portable devices.
>
>
> *From:* Daniel White <afmu...@gmail.com>
> *Sent:* Friday, September 16, 2016 5:33 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] documenting customer usage
>
>
> Okay so outside of my snarky response – I’d first say Sandvine is about to
> get really exciting.  But I’ll leave that to our vendor session on October
> 10th at WISPAPALOOZA.
>
>
>
> Steve – my no budget friend with monkeys throwing poo at him.
>
>
>
> There are a few questions you have to ask before I think any of us can
> give you any good advice:
>
>
>
> -  How much do you really want to help from a time/resource
> perspective?  Most ISP’s would say the router is their demark and they
> cannot troubleshoot beyond that and suggest a local computer tech to figure
> it out.
>
> -  Now let’s assume this is the bosses next door neighbor… so
> common sense goes out the window and help at all costs.  What router do you
> have at the customer prem?  For instance, something like a Cambium R200
> router would tell you what *device* has the heavy usage… and that might
> narrow it down enough
>
> -  Do you have hardware lying around you could replace the
> customer router to get better metrics?  Is that a step you want to take?
> Mikrotik on the customer prem would give you a lot of information
>
> -  What resources do you have at the tower?  You can look at the
> traffic to and from the customer… but what you’re really trying to identify
> may be encrypted… this is where something like Sandvine/Procera would help
>
>
>
> To me – this is the perfect example of why to offer a managed WiFi
> solution.  You control the router at the customer prem, you have more
> resources to help troubleshoot some of this.  And the best part… your
> collecting money every month for the privilege.
>
>
>
> Also –why is the customer concerned about the usage?  Do you do UBB and
> they are hitting their cap?
>
>
>
> Daniel White
>
> Managing Director – Hardware Distribution Sales
>
> ConVergence Technologies
>
> Cell: +1 (303) 746-3590
>
> dwh...@converge-tech.com
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Josh Reynolds
> *Sent:* Friday, September 16, 2016 1:11 AM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] documenting customer usage
>
>
>
> Well... sandvine, wind river, etc can cost more than a nice house in San
> Francisco. :)
>
>
>
> On Sep 15, 2016 11:40 PM, "That One Guy /sarcasm" <
> thatoneguyst...@gmail.com> wrote:
>
> I forgot to caveat the "I want to" with the "I have 0 funding from the
> boss purse"
>
>
>
> On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <afmu...@gmail.com> wrote:
>
> Sandvine :-D
>
>
>
> Daniel White
>
> Managing Director – Hardware Distribution Sales
>
> ConVergence Technologies
>
> Cell: +1 (303) 746-3590 <%2B1%20%28303%29%20746-3590>
>
> dwh...@converge-tech.com
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Josh Reynolds
> *Sent:* Thursday, September 15, 2016 9:37 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] documenting customer usage
>
>
>
> Procera :P
>
>
>
> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
> th

Re: [AFMUG] documenting customer usage

2016-09-16 Thread Ken Hohhof
Or customer could check this from his end.  Problem is customers don’t want to 
do any work or learn any technology, and they don’t want to pay the guy.  I’m 
sure there are computer techs who would come out and do this for a fee.

If the data usage is making their Internet “slow”, there’s the tried and true 
method of turning devices off until the problem goes away.

On  computers at least, there is software that can be used to see what 
application is using bandwidth:
http://www.howtogeek.com/howto/43713/how-to-monitor-the-bandwidth-consumption-of-individual-applications/

That gets less useful as people use “devices” like phones, game consoles, 
streaming devices, and iOT instead of actual computers.

I am sometimes willing to watch a realtime graph of bandwidth usage as the 
customer turns off various devices or unplugs them.  Again, unfortunately, this 
was easier when devices plugged in with an Ethernet cable instead of WiFi.  
Plus apps run all the time on portable devices.


From: Daniel White 
Sent: Friday, September 16, 2016 5:33 AM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

Okay so outside of my snarky response – I’d first say Sandvine is about to get 
really exciting.  But I’ll leave that to our vendor session on October 10th at 
WISPAPALOOZA.

 

Steve – my no budget friend with monkeys throwing poo at him.

 

There are a few questions you have to ask before I think any of us can give you 
any good advice:

 

-  How much do you really want to help from a time/resource 
perspective?  Most ISP’s would say the router is their demark and they cannot 
troubleshoot beyond that and suggest a local computer tech to figure it out.

-  Now let’s assume this is the bosses next door neighbor… so common 
sense goes out the window and help at all costs.  What router do you have at 
the customer prem?  For instance, something like a Cambium R200 router would 
tell you what device has the heavy usage… and that might narrow it down enough

-  Do you have hardware lying around you could replace the customer 
router to get better metrics?  Is that a step you want to take?  Mikrotik on 
the customer prem would give you a lot of information

-  What resources do you have at the tower?  You can look at the 
traffic to and from the customer… but what you’re really trying to identify may 
be encrypted… this is where something like Sandvine/Procera would help

 

To me – this is the perfect example of why to offer a managed WiFi solution.  
You control the router at the customer prem, you have more resources to help 
troubleshoot some of this.  And the best part… your collecting money every 
month for the privilege.

 

Also –why is the customer concerned about the usage?  Do you do UBB and they 
are hitting their cap?

 

Daniel White

Managing Director – Hardware Distribution Sales

ConVergence Technologies

Cell: +1 (303) 746-3590

dwh...@converge-tech.com

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
Sent: Friday, September 16, 2016 1:11 AM
To: af@afmug.com
Subject: Re: [AFMUG] documenting customer usage

 

Well... sandvine, wind river, etc can cost more than a nice house in San 
Francisco. :)

 

On Sep 15, 2016 11:40 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com> 
wrote:

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

   

  On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <afmu...@gmail.com> wrote:

Sandvine :-D

 

Daniel White

Managing Director – Hardware Distribution Sales

ConVergence Technologies

Cell: +1 (303) 746-3590

dwh...@converge-tech.com

 

From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
Sent: Thursday, September 15, 2016 9:37 PM
    To: af@afmug.com
    Subject: Re: [AFMUG] documenting customer usage

 

Procera :P

 

On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" 
<thatoneguyst...@gmail.com> wrote:




  so we got this:

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

   

   

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

   

   

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

   

   

  but, there is the one, w

Re: [AFMUG] documenting customer usage

2016-09-16 Thread Adam Moffett
Given the budget constraint, torch (yeah it's realtime only) might be 
all you've got without a lot of work.


If your CPE are SNMP aware, then you could poll for usage on everybody's 
interfaces every 10 minutes and store that in a database.  Then create a 
web form for yourself to query the database based on CPE MAC address and 
a specified time frame.  That would take zero cash, but either a very 
little or very lot of your time depending on your coding skill.  I think 
on UBNT you would have to query each CPE directly, and on Canopy you 
could either query the CPE or you can query just the AP's and get the 
bytes transferred for each LUID.




-- Original Message --
From: "That One Guy /sarcasm" <thatoneguyst...@gmail.com>
To: "af@afmug.com" <af@afmug.com>
Sent: 9/15/2016 10:45:46 PM
Subject: Re: [AFMUG] documenting customer usage

lol, for my requested purpose other than dpi, i dont think the mutli 
10k solution we were quoted was it.



not being a jerk, but if the unit is on your network, how does it 
mitigate a ddos? will it speak with my upstream that doesnt support 
blackholes with bgp?
is it working with powercode again since it broke operations with 
powercode?
will they provide me a document that says theyre legal with the whole 
"open internet" nonsense


I really liked them, til we priced them. We invested with netenforcer 
some time ago, it was great at the time because p2p was so destructive 
to a network at the time, but once we moved bandidth beyond a couple 
T1s they decided we needed a good old fashioned no spit raping. I say 
the same structure in procera... then the powercode break happenned, 
and I didnt care if it got resolved, it broke.



I can toss a sniifer on or dump a mirrored port. I think I may have 
indicated I care more than I do. I was primarily asking if my current 
environment had a tool that consiststed of this much work: what IP are 
you curious about? (I input the IP, maybe click my mouse less than 10 
times and key in less than ten more digits) and i come bak and have a 
torchish output saying what happenned.


if it doesnt stay within that simple of a solution with the gear I 
have, I dont really care to give the ten percent who arent dicks any 
different answer than the 90 who are



On Thu, Sep 15, 2016 at 8:52 PM, Josh Reynolds <j...@kyneticwifi.com> 
wrote:

Huh?

DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?

You talk a lot about a product it doesn't seem like you've ever used.


On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm" 
<thatoneguyst...@gmail.com> wrote:
yeah, crazy thing about that, not looking to drop multiple 10ks at 
once to have a nice guy on a product that quits working with the 
management system and is questionably legal beyond monitoring :-)


On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds <j...@kyneticwifi.com> 
wrote:

Procera :P


On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" 
<thatoneguyst...@gmail.com> wrote:


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

--"


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



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



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


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




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




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






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

Re: [AFMUG] documenting customer usage

2016-09-16 Thread Daniel White
Okay so outside of my snarky response – I’d first say Sandvine is about to get 
really exciting.  But I’ll leave that to our vendor session on October 10th at 
WISPAPALOOZA.



Steve – my no budget friend with monkeys throwing poo at him.



There are a few questions you have to ask before I think any of us can give you 
any good advice:



-  How much do you really want to help from a time/resource 
perspective?  Most ISP’s would say the router is their demark and they cannot 
troubleshoot beyond that and suggest a local computer tech to figure it out.

-  Now let’s assume this is the bosses next door neighbor… so common 
sense goes out the window and help at all costs.  What router do you have at 
the customer prem?  For instance, something like a Cambium R200 router would 
tell you what device has the heavy usage… and that might narrow it down enough

-  Do you have hardware lying around you could replace the customer 
router to get better metrics?  Is that a step you want to take?  Mikrotik on 
the customer prem would give you a lot of information

-  What resources do you have at the tower?  You can look at the 
traffic to and from the customer… but what you’re really trying to identify may 
be encrypted… this is where something like Sandvine/Procera would help



To me – this is the perfect example of why to offer a managed WiFi solution.  
You control the router at the customer prem, you have more resources to help 
troubleshoot some of this.  And the best part… your collecting money every 
month for the privilege.



Also –why is the customer concerned about the usage?  Do you do UBB and they 
are hitting their cap?



Daniel White

Managing Director – Hardware Distribution Sales

ConVergence Technologies

Cell: +1 (303) 746-3590

 <mailto:dwh...@converge-tech.com> dwh...@converge-tech.com



From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
Sent: Friday, September 16, 2016 1:11 AM
To: af@afmug.com
Subject: Re: [AFMUG] documenting customer usage



Well... sandvine, wind river, etc can cost more than a nice house in San 
Francisco. :)



On Sep 15, 2016 11:40 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com 
<mailto:thatoneguyst...@gmail.com> > wrote:

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



On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <afmu...@gmail.com 
<mailto:afmu...@gmail.com> > wrote:

Sandvine :-D



Daniel White

Managing Director – Hardware Distribution Sales

ConVergence Technologies

Cell: +1 (303) 746-3590 <tel:%2B1%20%28303%29%20746-3590>

 <mailto:dwh...@converge-tech.com> dwh...@converge-tech.com



From: Af [mailto:af-boun...@afmug.com <mailto:af-boun...@afmug.com> ] On Behalf 
Of Josh Reynolds
Sent: Thursday, September 15, 2016 9:37 PM
To: af@afmug.com <mailto:af@afmug.com>
Subject: Re: [AFMUG] documenting customer usage



Procera :P



On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com 
<mailto:thatoneguyst...@gmail.com> > wrote:




so we got this:

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





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





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





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



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







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




 
<https://www.avast.com/en-us/lp-safe-emailing-2270-a?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=oa-2270-a>

Virus-free.  
<https://www.avast.com/en-us/lp-safe-emailing-2270-a?utm_medium=email_source=link_campaign=sig-e

Re: [AFMUG] documenting customer usage

2016-09-15 Thread Josh Reynolds
Well... sandvine, wind river, etc can cost more than a nice house in San
Francisco. :)

On Sep 15, 2016 11:40 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com>
wrote:

> I forgot to caveat the "I want to" with the "I have 0 funding from the
> boss purse"
>
> On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <afmu...@gmail.com> wrote:
>
>> Sandvine :-D
>>
>>
>>
>> Daniel White
>>
>> Managing Director – Hardware Distribution Sales
>>
>> ConVergence Technologies
>>
>> Cell: +1 (303) 746-3590
>>
>> dwh...@converge-tech.com
>>
>>
>>
>> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Josh Reynolds
>> *Sent:* Thursday, September 15, 2016 9:37 PM
>> *To:* af@afmug.com
>> *Subject:* Re: [AFMUG] documenting customer usage
>>
>>
>>
>> Procera :P
>>
>>
>>
>> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
>> thatoneguyst...@gmail.com> wrote:
>>
>>
>> so we got this:
>>
>> "Can yotu help us somehow figure out what is using all of our data? We
>> have looked at the daily usage and can not figure it out. There are days
>> that we have been gone for several hours and the usage is VERY high. Then
>> days we are home have been extremely low. We are at a loss; can you help us
>> or recommend someone who can. Is there a way to break this down hourly?
>> Thanks!
>> --"
>>
>>
>>
>>
>>
>> this is the one in ten request, the other 9 are normally "we didnt do
>> this you people are lying,we never use the internet, our kids follow rules,
>> youre cheating us" in a real catty voice
>>
>>
>>
>>
>>
>> screw those 9 douches, its usually one of the spouses porn affliction,
>> the kids game console. or the fact they leave 5 units running in the house
>> with netflix on autoplay, if theyre not illegally torrenting some shit.
>>
>>
>>
>>
>>
>> but, there is the one, who arent cocks, they genuinely want to know. We
>> arent providing them a router, so monitoring from there directly is out
>>
>>
>>
>> we just recently moved DNS to us (huge value I have already found) So
>> whats the best way (to the account, not the individual machine) to track
>> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
>> edge, and for the firs time, I actually want to set up a tool to help the
>> 10 percent and if you guys who know more than me can spit out a script to
>> drop in to monitor this customer I can pretend I have value within th
>> company. .
>>
>>
>>
>>
>>
>>
>>
>> If you only see yourself as part of the team but you don't see your team
>> as part of yourself you have already failed as part of the team.
>>
>>
>>
>> <https://www.avast.com/en-us/lp-safe-emailing-2270-a?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=oa-2270-a>
>>  Virus-free.
>> www.avast.com
>> <https://www.avast.com/en-us/lp-safe-emailing-2270-a?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=oa-2270-a>
>>
>
>
>
> --
> If you only see yourself as part of the team but you don't see your team
> as part of yourself you have already failed as part of the team.
>


Re: [AFMUG] documenting customer usage

2016-09-15 Thread That One Guy /sarcasm
I forgot to caveat the "I want to" with the "I have 0 funding from the boss
purse"

On Thu, Sep 15, 2016 at 10:37 PM, Daniel White <afmu...@gmail.com> wrote:

> Sandvine :-D
>
>
>
> Daniel White
>
> Managing Director – Hardware Distribution Sales
>
> ConVergence Technologies
>
> Cell: +1 (303) 746-3590
>
> dwh...@converge-tech.com
>
>
>
> *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *Josh Reynolds
> *Sent:* Thursday, September 15, 2016 9:37 PM
> *To:* af@afmug.com
> *Subject:* Re: [AFMUG] documenting customer usage
>
>
>
> Procera :P
>
>
>
> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
> thatoneguyst...@gmail.com> wrote:
>
>
> so we got this:
>
> "Can yotu help us somehow figure out what is using all of our data? We
> have looked at the daily usage and can not figure it out. There are days
> that we have been gone for several hours and the usage is VERY high. Then
> days we are home have been extremely low. We are at a loss; can you help us
> or recommend someone who can. Is there a way to break this down hourly?
> Thanks!
> --"
>
>
>
>
>
> this is the one in ten request, the other 9 are normally "we didnt do this
> you people are lying,we never use the internet, our kids follow rules,
> youre cheating us" in a real catty voice
>
>
>
>
>
> screw those 9 douches, its usually one of the spouses porn affliction, the
> kids game console. or the fact they leave 5 units running in the house with
> netflix on autoplay, if theyre not illegally torrenting some shit.
>
>
>
>
>
> but, there is the one, who arent cocks, they genuinely want to know. We
> arent providing them a router, so monitoring from there directly is out
>
>
>
> we just recently moved DNS to us (huge value I have already found) So
> whats the best way (to the account, not the individual machine) to track
> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
> edge, and for the firs time, I actually want to set up a tool to help the
> 10 percent and if you guys who know more than me can spit out a script to
> drop in to monitor this customer I can pretend I have value within th
> company. .
>
>
>
>
>
>
>
> If you only see yourself as part of the team but you don't see your team
> as part of yourself you have already failed as part of the team.
>
>
>
> <https://www.avast.com/en-us/lp-safe-emailing-2270-a?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=oa-2270-a>
>  Virus-free.
> www.avast.com
> <https://www.avast.com/en-us/lp-safe-emailing-2270-a?utm_medium=email_source=link_campaign=sig-email_content=webmail_term=oa-2270-a>
>



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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread Daniel White
Sandvine :-D



Daniel White

Managing Director – Hardware Distribution Sales

ConVergence Technologies

Cell: +1 (303) 746-3590

 <mailto:dwh...@converge-tech.com> dwh...@converge-tech.com



From: Af [mailto:af-boun...@afmug.com] On Behalf Of Josh Reynolds
Sent: Thursday, September 15, 2016 9:37 PM
To: af@afmug.com
Subject: Re: [AFMUG] documenting customer usage



Procera :P



On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <thatoneguyst...@gmail.com 
<mailto:thatoneguyst...@gmail.com> > wrote:




so we got this:

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





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





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





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



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







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



---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus


Re: [AFMUG] documenting customer usage

2016-09-15 Thread Justin Wilson
My .02 this is a managed service type of thing.  If they are asking for this 
then you bill at standard hourly rate. Put a transparent PFsense box on their 
connection with BandwidthD http://bandwidthd.sourceforge.net/ 
 and NTopPNG.



Justin Wilson
j...@mtin.net

---
http://www.mtin.net Owner/CEO
xISP Solutions- Consulting – Data Centers - Bandwidth

http://www.midwest-ix.com  COO/Chairman
Internet Exchange - Peering - Distributed Fabric

> On Sep 15, 2016, at 11:10 PM, Jaime Solorza  wrote:
> 
> Doesn't Untangle professional version offer these options and traffic traps? 
> 
> 
> On Sep 15, 2016 9:00 PM, "Jeremy"  > wrote:
> You can run tcpdump and filter by their IP on the BMU.  It doesn't give much 
> for details, but I have used it before at a customer's request and I was able 
> to at least tell them what IP addresses their network was currently talking 
> to, and run whois on them.
> 
> On Thu, Sep 15, 2016 at 8:45 PM, That One Guy /sarcasm 
> > wrote:
> lol, for my requested purpose other than dpi, i dont think the mutli 10k 
> solution we were quoted was it.
> 
> 
> not being a jerk, but if the unit is on your network, how does it mitigate a 
> ddos? will it speak with my upstream that doesnt support blackholes with bgp?
> is it working with powercode again since it broke operations with powercode?
> will they provide me a document that says theyre legal with the whole "open 
> internet" nonsense
> 
> I really liked them, til we priced them. We invested with netenforcer some 
> time ago, it was great at the time because p2p was so destructive to a 
> network at the time, but once we moved bandidth beyond a couple T1s they 
> decided we needed a good old fashioned no spit raping. I say the same 
> structure in procera... then the powercode break happenned, and I didnt care 
> if it got resolved, it broke.
> 
> 
> I can toss a sniifer on or dump a mirrored port. I think I may have indicated 
> I care more than I do. I was primarily asking if my current environment had a 
> tool that consiststed of this much work: what IP are you curious about? (I 
> input the IP, maybe click my mouse less than 10 times and key in less than 
> ten more digits) and i come bak and have a torchish output saying what 
> happenned.
> 
> if it doesnt stay within that simple of a solution with the gear I have, I 
> dont really care to give the ten percent who arent dicks any different answer 
> than the 90 who are
> 
> 
> On Thu, Sep 15, 2016 at 8:52 PM, Josh Reynolds  > wrote:
> Huh?
> 
> DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?
> 
> You talk a lot about a product it doesn't seem like you've ever used.
> 
> 
> On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm"  > wrote:
> yeah, crazy thing about that, not looking to drop multiple 10ks at once to 
> have a nice guy on a product that quits working with the management system 
> and is questionably legal beyond monitoring :-)
> 
> On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds  > wrote:
> Procera :P
> 
> 
> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm"  > wrote:
> 
> so we got this:
> "Can yotu help us somehow figure out what is using all of our data? We have 
> looked at the daily usage and can not figure it out. There are days that we 
> have been gone for several hours and the usage is VERY high. Then days we are 
> home have been extremely low. We are at a loss; can you help us or recommend 
> someone who can. Is there a way to break this down hourly? Thanks!
> --"
> 
> 
> this is the one in ten request, the other 9 are normally "we didnt do this 
> you people are lying,we never use the internet, our kids follow rules, youre 
> cheating us" in a real catty voice
> 
> 
> screw those 9 douches, its usually one of the spouses porn affliction, the 
> kids game console. or the fact they leave 5 units running in the house with 
> netflix on autoplay, if theyre not illegally torrenting some shit.
> 
> 
> but, there is the one, who arent cocks, they genuinely want to know. We arent 
> providing them a router, so monitoring from there directly is out
> 
> we just recently moved DNS to us (huge value I have already found) So whats 
> the best way (to the account, not the individual machine) to track this down, 
> in our environment, We have mikrotik 1100ahx2 from to AP to the edge, and for 
> the firs time, I actually want to set up a tool to help the 10 percent and if 
> you guys who know more than me can spit out a script to drop in to monitor 
> this customer I can pretend I have value within th company. .
> 
> 
> 
> If you only see yourself as part of 

Re: [AFMUG] documenting customer usage

2016-09-15 Thread Jaime Solorza
Doesn't Untangle professional version offer these options and traffic
traps?

On Sep 15, 2016 9:00 PM, "Jeremy"  wrote:

> You can run tcpdump and filter by their IP on the BMU.  It doesn't give
> much for details, but I have used it before at a customer's request and I
> was able to at least tell them what IP addresses their network was
> currently talking to, and run whois on them.
>
> On Thu, Sep 15, 2016 at 8:45 PM, That One Guy /sarcasm <
> thatoneguyst...@gmail.com> wrote:
>
>> lol, for my requested purpose other than dpi, i dont think the mutli 10k
>> solution we were quoted was it.
>>
>>
>> not being a jerk, but if the unit is on your network, how does it
>> mitigate a ddos? will it speak with my upstream that doesnt support
>> blackholes with bgp?
>> is it working with powercode again since it broke operations with
>> powercode?
>> will they provide me a document that says theyre legal with the whole
>> "open internet" nonsense
>>
>> I really liked them, til we priced them. We invested with netenforcer
>> some time ago, it was great at the time because p2p was so destructive to a
>> network at the time, but once we moved bandidth beyond a couple T1s they
>> decided we needed a good old fashioned no spit raping. I say the same
>> structure in procera... then the powercode break happenned, and I didnt
>> care if it got resolved, it broke.
>>
>>
>> I can toss a sniifer on or dump a mirrored port. I think I may have
>> indicated I care more than I do. I was primarily asking if my current
>> environment had a tool that consiststed of this much work: what IP are you
>> curious about? (I input the IP, maybe click my mouse less than 10 times and
>> key in less than ten more digits) and i come bak and have a torchish output
>> saying what happenned.
>>
>> if it doesnt stay within that simple of a solution with the gear I have,
>> I dont really care to give the ten percent who arent dicks any different
>> answer than the 90 who are
>>
>>
>> On Thu, Sep 15, 2016 at 8:52 PM, Josh Reynolds 
>> wrote:
>>
>>> Huh?
>>>
>>> DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?
>>>
>>> You talk a lot about a product it doesn't seem like you've ever used.
>>>
>>> On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm" <
>>> thatoneguyst...@gmail.com> wrote:
>>>
>>> yeah, crazy thing about that, not looking to drop multiple 10ks at once
>>> to have a nice guy on a product that quits working with the management
>>> system and is questionably legal beyond monitoring :-)
>>>
>>> On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds 
>>> wrote:
>>>
 Procera :P

 On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
 thatoneguyst...@gmail.com> wrote:

>
> so we got this:
> "Can yotu help us somehow figure out what is using all of our data?
> We have looked at the daily usage and can not figure it out. There are 
> days
> that we have been gone for several hours and the usage is VERY high. Then
> days we are home have been extremely low. We are at a loss; can you help 
> us
> or recommend someone who can. Is there a way to break this down hourly?
> Thanks!
> --"
>
>
> this is the one in ten request, the other 9 are normally "we didnt do
> this you people are lying,we never use the internet, our kids follow 
> rules,
> youre cheating us" in a real catty voice
>
>
> screw those 9 douches, its usually one of the spouses porn affliction,
> the kids game console. or the fact they leave 5 units running in the house
> with netflix on autoplay, if theyre not illegally torrenting some shit.
>
>
> but, there is the one, who arent cocks, they genuinely want to know.
> We arent providing them a router, so monitoring from there directly is out
>
> we just recently moved DNS to us (huge value I have already found) So
> whats the best way (to the account, not the individual machine) to track
> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
> edge, and for the firs time, I actually want to set up a tool to help the
> 10 percent and if you guys who know more than me can spit out a script to
> drop in to monitor this customer I can pretend I have value within th
> company. .
>
>
>
> If you only see yourself as part of the team but you don't see your
> team as part of yourself you have already failed as part of the team.
>

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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread Jeremy
You can run tcpdump and filter by their IP on the BMU.  It doesn't give
much for details, but I have used it before at a customer's request and I
was able to at least tell them what IP addresses their network was
currently talking to, and run whois on them.

On Thu, Sep 15, 2016 at 8:45 PM, That One Guy /sarcasm <
thatoneguyst...@gmail.com> wrote:

> lol, for my requested purpose other than dpi, i dont think the mutli 10k
> solution we were quoted was it.
>
>
> not being a jerk, but if the unit is on your network, how does it mitigate
> a ddos? will it speak with my upstream that doesnt support blackholes with
> bgp?
> is it working with powercode again since it broke operations with
> powercode?
> will they provide me a document that says theyre legal with the whole
> "open internet" nonsense
>
> I really liked them, til we priced them. We invested with netenforcer some
> time ago, it was great at the time because p2p was so destructive to a
> network at the time, but once we moved bandidth beyond a couple T1s they
> decided we needed a good old fashioned no spit raping. I say the same
> structure in procera... then the powercode break happenned, and I didnt
> care if it got resolved, it broke.
>
>
> I can toss a sniifer on or dump a mirrored port. I think I may have
> indicated I care more than I do. I was primarily asking if my current
> environment had a tool that consiststed of this much work: what IP are you
> curious about? (I input the IP, maybe click my mouse less than 10 times and
> key in less than ten more digits) and i come bak and have a torchish output
> saying what happenned.
>
> if it doesnt stay within that simple of a solution with the gear I have, I
> dont really care to give the ten percent who arent dicks any different
> answer than the 90 who are
>
>
> On Thu, Sep 15, 2016 at 8:52 PM, Josh Reynolds 
> wrote:
>
>> Huh?
>>
>> DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?
>>
>> You talk a lot about a product it doesn't seem like you've ever used.
>>
>> On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm" <
>> thatoneguyst...@gmail.com> wrote:
>>
>> yeah, crazy thing about that, not looking to drop multiple 10ks at once
>> to have a nice guy on a product that quits working with the management
>> system and is questionably legal beyond monitoring :-)
>>
>> On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds 
>> wrote:
>>
>>> Procera :P
>>>
>>> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
>>> thatoneguyst...@gmail.com> wrote:
>>>

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


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


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


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

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



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

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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread Josh Reynolds
We acquired several python scripts that would drop traffic on it, but they
could also be configured to communicate to a router or other device via CLI
or API to black hole or tarpit. One of the perks of the platform.

No idea about power code. The sonar guys support it now I believe.

I vacated the fiber company and took on a contractor role with the USDA
National Information Technology Center (fed data center) - better benefits,
and greatly reduced stress.

Open Internet... We've talked about this. You should speak with your telco
aware lawyer... You have one on retainer, right? If not WISPA could likely
provide one of theirs for a reduced fee.

I'm sure you can find some hacky janky shit in mikrotik to get you 50% of
what you are looking for... Netflow doesn't really cut it though, for
several well documented reasons that 5 minutes googling NANOG presentations
can explain.

Mikrotik is a decent platform with a wide range of tools, but don't assume
its the best for any task. Then again, it may still meet your needs. If so,
great. YMMV.

On Sep 15, 2016 9:45 PM, "That One Guy /sarcasm" 
wrote:

> lol, for my requested purpose other than dpi, i dont think the mutli 10k
> solution we were quoted was it.
>
>
> not being a jerk, but if the unit is on your network, how does it mitigate
> a ddos? will it speak with my upstream that doesnt support blackholes with
> bgp?
> is it working with powercode again since it broke operations with
> powercode?
> will they provide me a document that says theyre legal with the whole
> "open internet" nonsense
>
> I really liked them, til we priced them. We invested with netenforcer some
> time ago, it was great at the time because p2p was so destructive to a
> network at the time, but once we moved bandidth beyond a couple T1s they
> decided we needed a good old fashioned no spit raping. I say the same
> structure in procera... then the powercode break happenned, and I didnt
> care if it got resolved, it broke.
>
>
> I can toss a sniifer on or dump a mirrored port. I think I may have
> indicated I care more than I do. I was primarily asking if my current
> environment had a tool that consiststed of this much work: what IP are you
> curious about? (I input the IP, maybe click my mouse less than 10 times and
> key in less than ten more digits) and i come bak and have a torchish output
> saying what happenned.
>
> if it doesnt stay within that simple of a solution with the gear I have, I
> dont really care to give the ten percent who arent dicks any different
> answer than the 90 who are
>
>
> On Thu, Sep 15, 2016 at 8:52 PM, Josh Reynolds 
> wrote:
>
>> Huh?
>>
>> DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?
>>
>> You talk a lot about a product it doesn't seem like you've ever used.
>>
>> On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm" <
>> thatoneguyst...@gmail.com> wrote:
>>
>> yeah, crazy thing about that, not looking to drop multiple 10ks at once
>> to have a nice guy on a product that quits working with the management
>> system and is questionably legal beyond monitoring :-)
>>
>> On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds 
>> wrote:
>>
>>> Procera :P
>>>
>>> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
>>> thatoneguyst...@gmail.com> wrote:
>>>

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


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


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


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

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



 If you only see yourself as part of the team but you don't see your
 team as part of yourself you 

Re: [AFMUG] documenting customer usage

2016-09-15 Thread That One Guy /sarcasm
lol, for my requested purpose other than dpi, i dont think the mutli 10k
solution we were quoted was it.


not being a jerk, but if the unit is on your network, how does it mitigate
a ddos? will it speak with my upstream that doesnt support blackholes with
bgp?
is it working with powercode again since it broke operations with powercode?
will they provide me a document that says theyre legal with the whole "open
internet" nonsense

I really liked them, til we priced them. We invested with netenforcer some
time ago, it was great at the time because p2p was so destructive to a
network at the time, but once we moved bandidth beyond a couple T1s they
decided we needed a good old fashioned no spit raping. I say the same
structure in procera... then the powercode break happenned, and I didnt
care if it got resolved, it broke.


I can toss a sniifer on or dump a mirrored port. I think I may have
indicated I care more than I do. I was primarily asking if my current
environment had a tool that consiststed of this much work: what IP are you
curious about? (I input the IP, maybe click my mouse less than 10 times and
key in less than ten more digits) and i come bak and have a torchish output
saying what happenned.

if it doesnt stay within that simple of a solution with the gear I have, I
dont really care to give the ten percent who arent dicks any different
answer than the 90 who are


On Thu, Sep 15, 2016 at 8:52 PM, Josh Reynolds  wrote:

> Huh?
>
> DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?
>
> You talk a lot about a product it doesn't seem like you've ever used.
>
> On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm" <
> thatoneguyst...@gmail.com> wrote:
>
> yeah, crazy thing about that, not looking to drop multiple 10ks at once to
> have a nice guy on a product that quits working with the management system
> and is questionably legal beyond monitoring :-)
>
> On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds 
> wrote:
>
>> Procera :P
>>
>> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
>> thatoneguyst...@gmail.com> wrote:
>>
>>>
>>> so we got this:
>>> "Can yotu help us somehow figure out what is using all of our data? We
>>> have looked at the daily usage and can not figure it out. There are days
>>> that we have been gone for several hours and the usage is VERY high. Then
>>> days we are home have been extremely low. We are at a loss; can you help us
>>> or recommend someone who can. Is there a way to break this down hourly?
>>> Thanks!
>>> --"
>>>
>>>
>>> this is the one in ten request, the other 9 are normally "we didnt do
>>> this you people are lying,we never use the internet, our kids follow rules,
>>> youre cheating us" in a real catty voice
>>>
>>>
>>> screw those 9 douches, its usually one of the spouses porn affliction,
>>> the kids game console. or the fact they leave 5 units running in the house
>>> with netflix on autoplay, if theyre not illegally torrenting some shit.
>>>
>>>
>>> but, there is the one, who arent cocks, they genuinely want to know. We
>>> arent providing them a router, so monitoring from there directly is out
>>>
>>> we just recently moved DNS to us (huge value I have already found) So
>>> whats the best way (to the account, not the individual machine) to track
>>> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
>>> edge, and for the firs time, I actually want to set up a tool to help the
>>> 10 percent and if you guys who know more than me can spit out a script to
>>> drop in to monitor this customer I can pretend I have value within th
>>> company. .
>>>
>>>
>>>
>>> If you only see yourself as part of the team but you don't see your team
>>> as part of yourself you have already failed as part of the team.
>>>
>>
>
>
> --
> If you only see yourself as part of the team but you don't see your team
> as part of yourself you have already failed as part of the team.
>
>
>


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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread Ken Hohhof
Most of the time it comes back as a CDN, so you still don’t know who hired the 
CDN.  Or something like AWS, and you still don’t know.  The exceptions perhaps 
are Apple, Google/Youtube, and some Netflix.


From: That One Guy /sarcasm 
Sent: Thursday, September 15, 2016 8:44 PM
To: af@afmug.com 
Subject: Re: [AFMUG] documenting customer usage

"Torch their IP. 
Find the IP that is sending them lots of data.
Punch that IP into bgp.he.net
It will tell you who is sending the data and that normally can give them a 
hint."

A. Is there a torch tool for long term monitoring, it seems real time to me" 
B, explain the HE thing, I have never seen anything in the looking glass that 
will tell me what our customers are soing, but then again I just learned how to 
read the routes

On Thu, Sep 15, 2016 at 8:38 PM, Jim Bouse [Brazos WiFi] <j...@brazoswifi.com> 
wrote:

  Torch their IP.
  Find the IP that is sending them lots of data.
  Punch that IP into bgp.he.net
  It will tell you who is sending the data and that normally can give them a 
hint.



  Jim Bouse

  Owner

  Brazos WiFi

  979-985-5912

  j...@brazoswifi.com



   Original message 
  From: That One Guy /sarcasm <thatoneguyst...@gmail.com> 
  Date: 9/15/16 8:36 PM (GMT-06:00) 
  To: af@afmug.com 
  Subject: [AFMUG] documenting customer usage 


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


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


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


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

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



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




-- 

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

Re: [AFMUG] documenting customer usage

2016-09-15 Thread George Skorup

Netflow (Traffic Flow in MT speak)

On 9/15/2016 8:44 PM, That One Guy /sarcasm wrote:

"Torch their IP.
Find the IP that is sending them lots of data.
Punch that IP into bgp.he.net 
It will tell you who is sending the data and that normally can give 
them a hint."


A. Is there a torch tool for long term monitoring, it seems real time 
to me"
B, explain the HE thing, I have never seen anything in the looking 
glass that will tell me what our customers are soing, but then again I 
just learned how to read the routes


On Thu, Sep 15, 2016 at 8:38 PM, Jim Bouse [Brazos WiFi] 
> wrote:


Torch their IP.
Find the IP that is sending them lots of data.
Punch that IP into bgp.he.net 
It will tell you who is sending the data and that normally can
give them a hint.



Jim Bouse

Owner

Brazos WiFi

979-985-5912 

j...@brazoswifi.com 



 Original message 
From: That One Guy /sarcasm >
Date: 9/15/16 8:36 PM (GMT-06:00)
To: af@afmug.com 
Subject: [AFMUG] documenting customer usage


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


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


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


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

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



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




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




Re: [AFMUG] documenting customer usage

2016-09-15 Thread Josh Reynolds
Huh?

DPI? QoS? DDOS Protection? CGNAT? Customer Support Tools?

You talk a lot about a product it doesn't seem like you've ever used.

On Sep 15, 2016 8:42 PM, "That One Guy /sarcasm" 
wrote:

yeah, crazy thing about that, not looking to drop multiple 10ks at once to
have a nice guy on a product that quits working with the management system
and is questionably legal beyond monitoring :-)

On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds  wrote:

> Procera :P
>
> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
> thatoneguyst...@gmail.com> wrote:
>
>>
>> so we got this:
>> "Can yotu help us somehow figure out what is using all of our data? We
>> have looked at the daily usage and can not figure it out. There are days
>> that we have been gone for several hours and the usage is VERY high. Then
>> days we are home have been extremely low. We are at a loss; can you help us
>> or recommend someone who can. Is there a way to break this down hourly?
>> Thanks!
>> --"
>>
>>
>> this is the one in ten request, the other 9 are normally "we didnt do
>> this you people are lying,we never use the internet, our kids follow rules,
>> youre cheating us" in a real catty voice
>>
>>
>> screw those 9 douches, its usually one of the spouses porn affliction,
>> the kids game console. or the fact they leave 5 units running in the house
>> with netflix on autoplay, if theyre not illegally torrenting some shit.
>>
>>
>> but, there is the one, who arent cocks, they genuinely want to know. We
>> arent providing them a router, so monitoring from there directly is out
>>
>> we just recently moved DNS to us (huge value I have already found) So
>> whats the best way (to the account, not the individual machine) to track
>> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
>> edge, and for the firs time, I actually want to set up a tool to help the
>> 10 percent and if you guys who know more than me can spit out a script to
>> drop in to monitor this customer I can pretend I have value within th
>> company. .
>>
>>
>>
>> If you only see yourself as part of the team but you don't see your team
>> as part of yourself you have already failed as part of the team.
>>
>


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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread That One Guy /sarcasm
"Torch their IP.
Find the IP that is sending them lots of data.
Punch that IP into bgp.he.net
It will tell you who is sending the data and that normally can give them a
hint."

A. Is there a torch tool for long term monitoring, it seems real time to
me"
B, explain the HE thing, I have never seen anything in the looking glass
that will tell me what our customers are soing, but then again I just
learned how to read the routes

On Thu, Sep 15, 2016 at 8:38 PM, Jim Bouse [Brazos WiFi]  wrote:

> Torch their IP.
> Find the IP that is sending them lots of data.
> Punch that IP into bgp.he.net
> It will tell you who is sending the data and that normally can give them a
> hint.
>
>
>
> Jim Bouse
>
> Owner
>
> Brazos WiFi
>
> 979-985-5912
>
> j...@brazoswifi.com
>
>
>  Original message 
> From: That One Guy /sarcasm 
> Date: 9/15/16 8:36 PM (GMT-06:00)
> To: af@afmug.com
> Subject: [AFMUG] documenting customer usage
>
>
> so we got this:
> "Can yotu help us somehow figure out what is using all of our data? We
> have looked at the daily usage and can not figure it out. There are days
> that we have been gone for several hours and the usage is VERY high. Then
> days we are home have been extremely low. We are at a loss; can you help us
> or recommend someone who can. Is there a way to break this down hourly?
> Thanks!
> --"
>
>
> this is the one in ten request, the other 9 are normally "we didnt do this
> you people are lying,we never use the internet, our kids follow rules,
> youre cheating us" in a real catty voice
>
>
> screw those 9 douches, its usually one of the spouses porn affliction, the
> kids game console. or the fact they leave 5 units running in the house with
> netflix on autoplay, if theyre not illegally torrenting some shit.
>
>
> but, there is the one, who arent cocks, they genuinely want to know. We
> arent providing them a router, so monitoring from there directly is out
>
> we just recently moved DNS to us (huge value I have already found) So
> whats the best way (to the account, not the individual machine) to track
> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
> edge, and for the firs time, I actually want to set up a tool to help the
> 10 percent and if you guys who know more than me can spit out a script to
> drop in to monitor this customer I can pretend I have value within th
> company. .
>
>
>
> If you only see yourself as part of the team but you don't see your team
> as part of yourself you have already failed as part of the team.
>



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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread That One Guy /sarcasm
yeah, crazy thing about that, not looking to drop multiple 10ks at once to
have a nice guy on a product that quits working with the management system
and is questionably legal beyond monitoring :-)

On Thu, Sep 15, 2016 at 8:37 PM, Josh Reynolds  wrote:

> Procera :P
>
> On Sep 15, 2016 8:36 PM, "That One Guy /sarcasm" <
> thatoneguyst...@gmail.com> wrote:
>
>>
>> so we got this:
>> "Can yotu help us somehow figure out what is using all of our data? We
>> have looked at the daily usage and can not figure it out. There are days
>> that we have been gone for several hours and the usage is VERY high. Then
>> days we are home have been extremely low. We are at a loss; can you help us
>> or recommend someone who can. Is there a way to break this down hourly?
>> Thanks!
>> --"
>>
>>
>> this is the one in ten request, the other 9 are normally "we didnt do
>> this you people are lying,we never use the internet, our kids follow rules,
>> youre cheating us" in a real catty voice
>>
>>
>> screw those 9 douches, its usually one of the spouses porn affliction,
>> the kids game console. or the fact they leave 5 units running in the house
>> with netflix on autoplay, if theyre not illegally torrenting some shit.
>>
>>
>> but, there is the one, who arent cocks, they genuinely want to know. We
>> arent providing them a router, so monitoring from there directly is out
>>
>> we just recently moved DNS to us (huge value I have already found) So
>> whats the best way (to the account, not the individual machine) to track
>> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
>> edge, and for the firs time, I actually want to set up a tool to help the
>> 10 percent and if you guys who know more than me can spit out a script to
>> drop in to monitor this customer I can pretend I have value within th
>> company. .
>>
>>
>>
>> If you only see yourself as part of the team but you don't see your team
>> as part of yourself you have already failed as part of the team.
>>
>


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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread Jim Bouse [Brazos WiFi]
Torch their IP.
Find the IP that is sending them lots of data.
Punch that IP into bgp.he.net
It will tell you who is sending the data and that normally can give them a hint.



Jim Bouse
Owner
Brazos WiFi
979-985-5912
j...@brazoswifi.com


 Original message 
From: That One Guy /sarcasm 
Date: 9/15/16 8:36 PM (GMT-06:00)
To: af@afmug.com
Subject: [AFMUG] documenting customer usage


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


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


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


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

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



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


Re: [AFMUG] documenting customer usage

2016-09-15 Thread Josh Reynolds
Procera :P

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

>
> so we got this:
> "Can yotu help us somehow figure out what is using all of our data? We
> have looked at the daily usage and can not figure it out. There are days
> that we have been gone for several hours and the usage is VERY high. Then
> days we are home have been extremely low. We are at a loss; can you help us
> or recommend someone who can. Is there a way to break this down hourly?
> Thanks!
> --"
>
>
> this is the one in ten request, the other 9 are normally "we didnt do this
> you people are lying,we never use the internet, our kids follow rules,
> youre cheating us" in a real catty voice
>
>
> screw those 9 douches, its usually one of the spouses porn affliction, the
> kids game console. or the fact they leave 5 units running in the house with
> netflix on autoplay, if theyre not illegally torrenting some shit.
>
>
> but, there is the one, who arent cocks, they genuinely want to know. We
> arent providing them a router, so monitoring from there directly is out
>
> we just recently moved DNS to us (huge value I have already found) So
> whats the best way (to the account, not the individual machine) to track
> this down, in our environment, We have mikrotik 1100ahx2 from to AP to the
> edge, and for the firs time, I actually want to set up a tool to help the
> 10 percent and if you guys who know more than me can spit out a script to
> drop in to monitor this customer I can pretend I have value within th
> company. .
>
>
>
> If you only see yourself as part of the team but you don't see your team
> as part of yourself you have already failed as part of the team.
>