Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread ROZA, Ariel 
About Windows grep:

https://sourceforge.net/projects/grepwin/


De: cisco-voip  En nombre de Lelio Fulgenzi
Enviado el: jueves, 17 de octubre de 2019 10:55
Para: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Asunto: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)


What tools have others used to parse CDRs for reports for users/departments?

I've written a script, but would like to be able to Windows-a-fy this so others 
can do this easily.

Is there a good windows grep out there or something else?

Lelio

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.uoguelph.ca%2Fccs&data=02%7C01%7Cariel.roza%40la.logicalis.com%7C8556e88ff78d4b5322bd08d75309b64b%7C2e3290cb8d404058abe502c4f58b87e3%7C0%7C0%7C637069173487818472&sdata=qbZmTlYaH6fV7foORNFaPd%2F5tN6obpoB67pdbgT4bUc%3D&reserved=0>
 | @UofGCCS on Instagram, Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Kent Roberts 
I have a php script that will load  an ms sql  database. I can send it if I can 
figure out where I put it


Kent

> On Oct 17, 2019, at 10:12, Lelio Fulgenzi  wrote:
> 
> Sweet. Thanks again.
> 
> 
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
> 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
> 
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
> 
> 
> 
> -Original Message-
> From: Hunter Fuller  
> Sent: Thursday, October 17, 2019 12:10 PM
> To: Lelio Fulgenzi 
> Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
> 
> Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows 
> grep?)
> 
> Yes, in my case because it's debian, I would use 'wsl sudo apt install ...' 
> to install stuff.
> 
> Actually this is probably the easiest way to run Python on Windows now, in my 
> opinion, especially if the rest of your environment is Linux (like mine). The 
> scripts Just Work(tm).
> 
> --
> Hunter Fuller
> Router Jockey
> VBH Annex B-5
> +1 256 824 5331
> 
> Office of Information Technology
> The University of Alabama in Huntsville
> Network Engineering
> 
>> On Thu, Oct 17, 2019 at 11:05 AM Lelio Fulgenzi  wrote:
>> 
>> Interesting. How are the packages updated? Via wsl or whatever package 
>> updater tool exists on the linux host?
>> 
>> ---
>> Lelio Fulgenzi, B.A. | Senior Analyst
>> Computing and Communications Services | University of Guelph Room 037 
>> Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
>> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>> 
>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>> 
>> 
>> 
>> -----Original Message-
>> From: Hunter Fuller 
>> Sent: Thursday, October 17, 2019 11:45 AM
>> To: Lelio Fulgenzi 
>> Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
>> 
>> Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows 
>> (windows grep?)
>> 
>> You basically just get a Linux system (mine is Debian) that you can install 
>> whatever you want into. Then from Windows, you would run 'wsl ' and 
>> it runs it inside the Linux environment.
>> 
>> Example:
>> PS C:\Users\hf0002> wsl grep --version grep (GNU grep) 2.27
>> 
>> --
>> Hunter Fuller
>> Router Jockey
>> VBH Annex B-5
>> +1 256 824 5331
>> 
>> Office of Information Technology
>> The University of Alabama in Huntsville Network Engineering
>> 
>>> On Thu, Oct 17, 2019 at 10:40 AM Lelio Fulgenzi  wrote:
>>> 
>>> Oh... that might work. Will have to see how big of a footprint it leaves 
>>> and if my scripts work without editing.
>>> 
>>> Does it install things like ksh, sed, awk, etc?
>>> 
>>> ---
>>> Lelio Fulgenzi, B.A. | Senior Analyst Computing and Communications 
>>> Services | University of Guelph Room 037 Animal Science & Nutrition 
>>> Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
>>> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>>> 
>>> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>>> 
>>> 
>>> 
>>> -Original Message-
>>> From: Hunter Fuller 
>>> Sent: Thursday, October 17, 2019 11:33 AM
>>> To: Lelio Fulgenzi 
>>> Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
>>> 
>>> Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows 
>>> (windows grep?)
>>> 
>>> If you're just trying to run your script on Windows, try the Windows 
>>> Subsystem for Linux. You could even make it output a spreadsheet or 
>>> something with some Python-fu. WSL is very low-touch in my experience, not 
>>> a bear to support or anything.
>>> 
>>> --
>>> Hunter Fuller
>>> Router Jockey
>>> VBH Annex B-5
>>> +1 256 824 5331
>>> 
>>> Office of Information Technology
>>> The University of Alabama in Huntsville Network Engineering
>>> 
>>> On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:
>>>> 
>>>> 
>>>> What tools have others used to parse CDRs for reports for 
>>>> users/departments?
>>>> 
>>>> I've written a script, but would like to be able to Windows-a-fy this so 
>>>> others can do this easily.
>>>>

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Pawlowski, Adam 
We have an in house tool that parses the CDR records being loaded by the loader 
into a database.

The data is indexed so searching with a front end is pretty easy .

We're actually eliminating this tool as we do not want to store call detail 
records for liability and data storage reasons . We do not provide user 
reporting on call detail and this has yet to significantly impact anyone's 
business that I'm aware of .

Adam



From: cisco-voip  On Behalf Of Lelio 
Fulgenzi
Sent: Thursday, October 17, 2019 9:55 AM
To: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Subject: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)


What tools have others used to parse CDRs for reports for users/departments?

I've written a script, but would like to be able to Windows-a-fy this so others 
can do this easily.

Is there a good windows grep out there or something else?

Lelio

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Parker Pearson - Donoma 
Lelio:

We have a GUI based solution called OneView.  We wrote it because so many 
people asked for a better way to get the data from their Cisco call platforms. 
Plus you can automate the reports like you said you wanted.  It works for 
both Call Manager and UCCX data.  Demos available.  Just hit the information 
page (https://www.donomasoftware.com/donoma-oneview/)  and you can 
self-schedule from available demo times.

Cheers,

Parker


Parker
Pearson
Vice President, Marketing & Business Development
Donoma Software
t: 540.443.3577
e: par...@donomasoftware.com
Schedule with me online
From: cisco-voip  on behalf of Anthony 
Holloway 
Date: Thursday, October 17, 2019 at 11:31 AM
To: Lelio Fulgenzi 
Cc: "voyp list, cisco-voip (cisco-voip@puck.nether.net)" 

Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

The what now?

You want a GUI based app for end users to be able to view CDR reports?  So 
like, CAR? ... But better?

On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

What tools have others used to parse CDRs for reports for users/departments?

I've written a script, but would like to be able to Windows-a-fy this so others 
can do this easily.

Is there a good windows grep out there or something else?

Lelio

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca><mailto:le...@uoguelph.ca<mailto:le...@uoguelph.ca>>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs><http://www.uoguelph.ca/ccs> | 
@UofGCCS on Instagram, Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Lelio Fulgenzi 
Sweet. Thanks again.


---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook



-Original Message-
From: Hunter Fuller  
Sent: Thursday, October 17, 2019 12:10 PM
To: Lelio Fulgenzi 
Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

Yes, in my case because it's debian, I would use 'wsl sudo apt install ...' to 
install stuff.

Actually this is probably the easiest way to run Python on Windows now, in my 
opinion, especially if the rest of your environment is Linux (like mine). The 
scripts Just Work(tm).

--
Hunter Fuller
Router Jockey
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Network Engineering

On Thu, Oct 17, 2019 at 11:05 AM Lelio Fulgenzi  wrote:
>
> Interesting. How are the packages updated? Via wsl or whatever package 
> updater tool exists on the linux host?
>
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph Room 037 
> Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> -Original Message-
> From: Hunter Fuller 
> Sent: Thursday, October 17, 2019 11:45 AM
> To: Lelio Fulgenzi 
> Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
> 
> Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows 
> (windows grep?)
>
> You basically just get a Linux system (mine is Debian) that you can install 
> whatever you want into. Then from Windows, you would run 'wsl ' and 
> it runs it inside the Linux environment.
>
> Example:
> PS C:\Users\hf0002> wsl grep --version grep (GNU grep) 2.27
>
> --
> Hunter Fuller
> Router Jockey
> VBH Annex B-5
> +1 256 824 5331
>
> Office of Information Technology
> The University of Alabama in Huntsville Network Engineering
>
> On Thu, Oct 17, 2019 at 10:40 AM Lelio Fulgenzi  wrote:
> >
> > Oh... that might work. Will have to see how big of a footprint it leaves 
> > and if my scripts work without editing.
> >
> > Does it install things like ksh, sed, awk, etc?
> >
> > ---
> > Lelio Fulgenzi, B.A. | Senior Analyst Computing and Communications 
> > Services | University of Guelph Room 037 Animal Science & Nutrition 
> > Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> > 519-824-4120 Ext. 56354 | le...@uoguelph.ca
> >
> > www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
> >
> >
> >
> > -Original Message-
> > From: Hunter Fuller 
> > Sent: Thursday, October 17, 2019 11:33 AM
> > To: Lelio Fulgenzi 
> > Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
> > 
> > Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows 
> > (windows grep?)
> >
> > If you're just trying to run your script on Windows, try the Windows 
> > Subsystem for Linux. You could even make it output a spreadsheet or 
> > something with some Python-fu. WSL is very low-touch in my experience, not 
> > a bear to support or anything.
> >
> > --
> > Hunter Fuller
> > Router Jockey
> > VBH Annex B-5
> > +1 256 824 5331
> >
> > Office of Information Technology
> > The University of Alabama in Huntsville Network Engineering
> >
> > On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:
> > >
> > >
> > > What tools have others used to parse CDRs for reports for 
> > > users/departments?
> > >
> > > I've written a script, but would like to be able to Windows-a-fy this so 
> > > others can do this easily.
> > >
> > > Is there a good windows grep out there or something else?
> > >
> > > Lelio
> > >
> > > ---
> > > Lelio Fulgenzi, B.A. | Senior Analyst Computing and Communications 
> > > Services | University of Guelph Room 037 Animal Science & 
> > > Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> > > 519-824-4120 Ext. 56354 |
> > > le...@uoguelph.ca<mailto:le...@uoguelph.ca>
> > >
> > > www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on 
> > > Instagram, Twitter and Facebook
> > >
> > > [University of Guelph Cornerstone with Improve Life tagline]
> > >
> > > ___
> > > cisco-voip mailing list
> > > cisco-voip@puck.nether.net
> > > https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Hunter Fuller 
Yes, in my case because it's debian, I would use 'wsl sudo apt install
...' to install stuff.

Actually this is probably the easiest way to run Python on Windows
now, in my opinion, especially if the rest of your environment is
Linux (like mine). The scripts Just Work(tm).

--
Hunter Fuller
Router Jockey
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Network Engineering

On Thu, Oct 17, 2019 at 11:05 AM Lelio Fulgenzi  wrote:
>
> Interesting. How are the packages updated? Via wsl or whatever package 
> updater tool exists on the linux host?
>
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
> 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> -Original Message-
> From: Hunter Fuller 
> Sent: Thursday, October 17, 2019 11:45 AM
> To: Lelio Fulgenzi 
> Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
> 
> Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows 
> grep?)
>
> You basically just get a Linux system (mine is Debian) that you can install 
> whatever you want into. Then from Windows, you would run 'wsl ' and 
> it runs it inside the Linux environment.
>
> Example:
> PS C:\Users\hf0002> wsl grep --version
> grep (GNU grep) 2.27
>
> --
> Hunter Fuller
> Router Jockey
> VBH Annex B-5
> +1 256 824 5331
>
> Office of Information Technology
> The University of Alabama in Huntsville
> Network Engineering
>
> On Thu, Oct 17, 2019 at 10:40 AM Lelio Fulgenzi  wrote:
> >
> > Oh... that might work. Will have to see how big of a footprint it leaves 
> > and if my scripts work without editing.
> >
> > Does it install things like ksh, sed, awk, etc?
> >
> > ---
> > Lelio Fulgenzi, B.A. | Senior Analyst
> > Computing and Communications Services | University of Guelph Room 037
> > Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> > 519-824-4120 Ext. 56354 | le...@uoguelph.ca
> >
> > www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
> >
> >
> >
> > -Original Message-
> > From: Hunter Fuller 
> > Sent: Thursday, October 17, 2019 11:33 AM
> > To: Lelio Fulgenzi 
> > Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net)
> > 
> > Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows
> > (windows grep?)
> >
> > If you're just trying to run your script on Windows, try the Windows 
> > Subsystem for Linux. You could even make it output a spreadsheet or 
> > something with some Python-fu. WSL is very low-touch in my experience, not 
> > a bear to support or anything.
> >
> > --
> > Hunter Fuller
> > Router Jockey
> > VBH Annex B-5
> > +1 256 824 5331
> >
> > Office of Information Technology
> > The University of Alabama in Huntsville Network Engineering
> >
> > On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:
> > >
> > >
> > > What tools have others used to parse CDRs for reports for 
> > > users/departments?
> > >
> > > I've written a script, but would like to be able to Windows-a-fy this so 
> > > others can do this easily.
> > >
> > > Is there a good windows grep out there or something else?
> > >
> > > Lelio
> > >
> > > ---
> > > Lelio Fulgenzi, B.A. | Senior Analyst Computing and Communications
> > > Services | University of Guelph Room 037 Animal Science & Nutrition
> > > Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> > > 519-824-4120 Ext. 56354 |
> > > le...@uoguelph.ca<mailto:le...@uoguelph.ca>
> > >
> > > www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on
> > > Instagram, Twitter and Facebook
> > >
> > > [University of Guelph Cornerstone with Improve Life tagline]
> > >
> > > ___
> > > cisco-voip mailing list
> > > cisco-voip@puck.nether.net
> > > https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Lelio Fulgenzi 
Interesting. How are the packages updated? Via wsl or whatever package updater 
tool exists on the linux host?

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook



-Original Message-
From: Hunter Fuller  
Sent: Thursday, October 17, 2019 11:45 AM
To: Lelio Fulgenzi 
Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

You basically just get a Linux system (mine is Debian) that you can install 
whatever you want into. Then from Windows, you would run 'wsl ' and it 
runs it inside the Linux environment.

Example:
PS C:\Users\hf0002> wsl grep --version
grep (GNU grep) 2.27

--
Hunter Fuller
Router Jockey
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Network Engineering

On Thu, Oct 17, 2019 at 10:40 AM Lelio Fulgenzi  wrote:
>
> Oh... that might work. Will have to see how big of a footprint it leaves and 
> if my scripts work without editing.
>
> Does it install things like ksh, sed, awk, etc?
>
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph Room 037 
> Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> -Original Message-
> From: Hunter Fuller 
> Sent: Thursday, October 17, 2019 11:33 AM
> To: Lelio Fulgenzi 
> Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
> 
> Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows 
> (windows grep?)
>
> If you're just trying to run your script on Windows, try the Windows 
> Subsystem for Linux. You could even make it output a spreadsheet or something 
> with some Python-fu. WSL is very low-touch in my experience, not a bear to 
> support or anything.
>
> --
> Hunter Fuller
> Router Jockey
> VBH Annex B-5
> +1 256 824 5331
>
> Office of Information Technology
> The University of Alabama in Huntsville Network Engineering
>
> On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:
> >
> >
> > What tools have others used to parse CDRs for reports for users/departments?
> >
> > I've written a script, but would like to be able to Windows-a-fy this so 
> > others can do this easily.
> >
> > Is there a good windows grep out there or something else?
> >
> > Lelio
> >
> > ---
> > Lelio Fulgenzi, B.A. | Senior Analyst Computing and Communications 
> > Services | University of Guelph Room 037 Animal Science & Nutrition 
> > Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> > 519-824-4120 Ext. 56354 | 
> > le...@uoguelph.ca<mailto:le...@uoguelph.ca>
> >
> > www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on 
> > Instagram, Twitter and Facebook
> >
> > [University of Guelph Cornerstone with Improve Life tagline]
> >
> > ___
> > cisco-voip mailing list
> > cisco-voip@puck.nether.net
> > https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Hunter Fuller 
You basically just get a Linux system (mine is Debian) that you can
install whatever you want into. Then from Windows, you would run 'wsl
' and it runs it inside the Linux environment.

Example:
PS C:\Users\hf0002> wsl grep --version
grep (GNU grep) 2.27

--
Hunter Fuller
Router Jockey
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Network Engineering

On Thu, Oct 17, 2019 at 10:40 AM Lelio Fulgenzi  wrote:
>
> Oh... that might work. Will have to see how big of a footprint it leaves and 
> if my scripts work without editing.
>
> Does it install things like ksh, sed, awk, etc?
>
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
> 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook
>
>
>
> -Original Message-
> From: Hunter Fuller 
> Sent: Thursday, October 17, 2019 11:33 AM
> To: Lelio Fulgenzi 
> Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 
> 
> Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows 
> grep?)
>
> If you're just trying to run your script on Windows, try the Windows 
> Subsystem for Linux. You could even make it output a spreadsheet or something 
> with some Python-fu. WSL is very low-touch in my experience, not a bear to 
> support or anything.
>
> --
> Hunter Fuller
> Router Jockey
> VBH Annex B-5
> +1 256 824 5331
>
> Office of Information Technology
> The University of Alabama in Huntsville
> Network Engineering
>
> On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:
> >
> >
> > What tools have others used to parse CDRs for reports for users/departments?
> >
> > I've written a script, but would like to be able to Windows-a-fy this so 
> > others can do this easily.
> >
> > Is there a good windows grep out there or something else?
> >
> > Lelio
> >
> > ---
> > Lelio Fulgenzi, B.A. | Senior Analyst
> > Computing and Communications Services | University of Guelph Room 037
> > Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> > 519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>
> >
> > www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on
> > Instagram, Twitter and Facebook
> >
> > [University of Guelph Cornerstone with Improve Life tagline]
> >
> > ___
> > cisco-voip mailing list
> > cisco-voip@puck.nether.net
> > https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Lelio Fulgenzi 
Oh... that might work. Will have to see how big of a footprint it leaves and if 
my scripts work without editing.

Does it install things like ksh, sed, awk, etc?

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, Twitter and Facebook



-Original Message-
From: Hunter Fuller  
Sent: Thursday, October 17, 2019 11:33 AM
To: Lelio Fulgenzi 
Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

If you're just trying to run your script on Windows, try the Windows Subsystem 
for Linux. You could even make it output a spreadsheet or something with some 
Python-fu. WSL is very low-touch in my experience, not a bear to support or 
anything.

--
Hunter Fuller
Router Jockey
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Network Engineering

On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:
>
>
> What tools have others used to parse CDRs for reports for users/departments?
>
> I've written a script, but would like to be able to Windows-a-fy this so 
> others can do this easily.
>
> Is there a good windows grep out there or something else?
>
> Lelio
>
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph Room 037 
> Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>
>
> www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on 
> Instagram, Twitter and Facebook
>
> [University of Guelph Cornerstone with Improve Life tagline]
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Lelio Fulgenzi 
Yeah, I want to be able to input a few extensions with say two or three years’ 
worth of CDR data that has been exported to CSV files (simplified columns, just 
a few) and get output. I’d rather not give them raw data, so I’d probably 
import that into an excel.



---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca<mailto:le...@uoguelph.ca>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs> | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

From: Anthony Holloway 
Sent: Thursday, October 17, 2019 11:31 AM
To: Lelio Fulgenzi 
Cc: voyp list, cisco-voip (cisco-voip@puck.nether.net) 

Subject: Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

The what now?

You want a GUI based app for end users to be able to view CDR reports?  So 
like, CAR? ... But better?

On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

What tools have others used to parse CDRs for reports for users/departments?

I've written a script, but would like to be able to Windows-a-fy this so others 
can do this easily.

Is there a good windows grep out there or something else?

Lelio

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca<mailto:le...@uoguelph.ca><mailto:le...@uoguelph.ca<mailto:le...@uoguelph.ca>>

www.uoguelph.ca/ccs<http://www.uoguelph.ca/ccs><http://www.uoguelph.ca/ccs> | 
@UofGCCS on Instagram, Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

___
cisco-voip mailing list
cisco-voip@puck.nether.net<mailto:cisco-voip@puck.nether.net>
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Myron Young 
Variphy is a good product for that. It can pull directly from CUCM thru CDR 
billing application integration and digest CDR files from backup files and has 
a very user friendly reporting interface. You can also include Unity and CCX as 
well if you want one reporting tool for all your apps

On Oct 17, 2019, at 11:31 AM, Anthony Holloway 
 wrote:


The what now?

You want a GUI based app for end users to be able to view CDR reports?  So 
like, CAR? ... But better?

On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi 
mailto:le...@uoguelph.ca>> wrote:

What tools have others used to parse CDRs for reports for users/departments?

I've written a script, but would like to be able to Windows-a-fy this so others 
can do this easily.

Is there a good windows grep out there or something else?

Lelio

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | 
le...@uoguelph.ca>

www.uoguelph.ca/ccs | 
@UofGCCS on Instagram, Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Hunter Fuller 
If you're just trying to run your script on Windows, try the Windows
Subsystem for Linux. You could even make it output a spreadsheet or
something with some Python-fu. WSL is very low-touch in my experience,
not a bear to support or anything.

--
Hunter Fuller
Router Jockey
VBH Annex B-5
+1 256 824 5331

Office of Information Technology
The University of Alabama in Huntsville
Network Engineering

On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:
>
>
> What tools have others used to parse CDRs for reports for users/departments?
>
> I've written a script, but would like to be able to Windows-a-fy this so 
> others can do this easily.
>
> Is there a good windows grep out there or something else?
>
> Lelio
>
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 
> 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
> Twitter and Facebook
>
> [University of Guelph Cornerstone with Improve Life tagline]
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

Re: [cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Anthony Holloway 
The what now?

You want a GUI based app for end users to be able to view CDR reports?  So
like, CAR? ... But better?

On Thu, Oct 17, 2019 at 8:55 AM Lelio Fulgenzi  wrote:

>
> What tools have others used to parse CDRs for reports for
> users/departments?
>
> I've written a script, but would like to be able to Windows-a-fy this so
> others can do this easily.
>
> Is there a good windows grep out there or something else?
>
> Lelio
>
> ---
> Lelio Fulgenzi, B.A. | Senior Analyst
> Computing and Communications Services | University of Guelph
> Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON |
> N1G 2W1
> 519-824-4120 Ext. 56354 | le...@uoguelph.ca
>
> www.uoguelph.ca/ccs | @UofGCCS on Instagram,
> Twitter and Facebook
>
> [University of Guelph Cornerstone with Improve Life tagline]
>
> ___
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip

[cisco-voip] tools to parse CDR quickly on Windows (windows grep?)

2019-10-17 Thread Lelio Fulgenzi 

What tools have others used to parse CDRs for reports for users/departments?

I've written a script, but would like to be able to Windows-a-fy this so others 
can do this easily.

Is there a good windows grep out there or something else?

Lelio

---
Lelio Fulgenzi, B.A. | Senior Analyst
Computing and Communications Services | University of Guelph
Room 037 Animal Science & Nutrition Bldg | 50 Stone Rd E | Guelph, ON | N1G 2W1
519-824-4120 Ext. 56354 | le...@uoguelph.ca

www.uoguelph.ca/ccs | @UofGCCS on Instagram, 
Twitter and Facebook

[University of Guelph Cornerstone with Improve Life tagline]

<>___
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip