|
Home > Archive > Voice over IP Cisco > June 2005 > PRI Utilization
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Court Schuett 2005-06-09, 5:45 pm |
| I thought I've seen this request go out before and just wanted to let
people who were looking for it know that I've got a solution. It's an
ugly one, but it does work.
Here's how it goes.
Go to CAR
Device-Reports -> Gateway -> Detail
Export the data you're looking for to a CSV.
In Excel, strip out everything you don't need until your columns look
like this:
Column A: Date
Column B: Start Time
Column C: End Time
Then, in Column E, starting in Row 2, put in the minutes of the day in
number (I use Decimal 10) format. It should look like this:
0.0000000000
0.0006944444
0.0013888889
0.0020833333
0.0027777778
0.0034722222
0.0041666667
0.0048611111
0.0055555556
0.0062500000
0.0069444444
0.0076388889
0.0083333333
0.0090277778
0.0097222222
0.0104166667
0.0111111111
0.0118055556
0.0125000000
0.0131944444
Expand that down all the way until it reaches 1.
In Column E, Row 1, enter the date you want to study.
In Column F, put this function:
=SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$100
00<=E2+1/1440)*(C$1:C$10000>=E2+
1/1440))
That will analyze the first 10,000 calls for the day you put in E1.
In Column G, I put =MAX(F2:F1441) to give me the max concurrent calls
for the day.
Management really likes this information because it gives them a good
idea if they need to buy more PRIs or cancel some.
The analysis is not perfect. It only analyzes by minute so it can miss
some connections, but it is pretty good. Usually good enough. If you
wanted to take it out to the second, it wouldn't be that difficult
either.
I have plans to create a php or PERL script that will perform better
analysis but this is what I have for now.
Hope that helps!
Court Schuett
630-909-5560
cschuett@hprlogistics.com
| |
| John Lange 2005-06-09, 5:45 pm |
| Something that might be of use to you; Arezqui Bela=EFd has written an
excellent call detail reporting system for use with the Asterisk PBX:
http://www.areski.net/asterisk-stat-v2/about.php?s=3D0
Included is the ability to report on "max load". Example here:
http://www.areski.net/asterisk-stat...creenshot05.png
This system uses the start and end times of each call to determine load
and therefore is not reliant on any given time interval for reporting
meaning it shows the true load no matter how short the calls are.
I would suggest they easiest way to get the reporting you want would be
to write a small PERL script which takes your existing call detail
records and inserts them into a mysql database in the same format
Asterisk uses.
-- =
John Lange
President OpenIT ltd. www.Open-IT.ca (204) 885 0872
VoIP, Web services, Linux Consulting, Server Co-Location
On Thu, 2005-06-09 at 09:30 -0500, Court Schuett wrote:
> I thought I've seen this request go out before and just wanted to let
> people who were looking for it know that I've got a solution. It's an
> ugly one, but it does work.
> =
> Here's how it goes.
> =
> Go to CAR
> Device-Reports -> Gateway -> Detail
> =
> Export the data you're looking for to a CSV.
> =
> In Excel, strip out everything you don't need until your columns look
> like this:
> Column A: Date
> Column B: Start Time
> Column C: End Time
> =
> Then, in Column E, starting in Row 2, put in the minutes of the day in
> number (I use Decimal 10) format. It should look like this:
> 0.0000000000
> 0.0006944444
> 0.0013888889
> 0.0020833333
> 0.0027777778
> 0.0034722222
> 0.0041666667
> 0.0048611111
> 0.0055555556
> 0.0062500000
> 0.0069444444
> 0.0076388889
> 0.0083333333
> 0.0090277778
> 0.0097222222
> 0.0104166667
> 0.0111111111
> 0.0118055556
> 0.0125000000
> 0.0131944444
> =
> Expand that down all the way until it reaches 1. =
> =
> In Column E, Row 1, enter the date you want to study. =
> In Column F, put this function:
> =3DSUMPRODUCT((A$1:A$10000=3DE$1)*(B$1:B
$10000<=3DE2+1/1440)*(C$1:C$10000=
>=3DE2+
> 1/1440))
> =
> That will analyze the first 10,000 calls for the day you put in E1. =
> In Column G, I put =3DMAX(F2:F1441) to give me the max concurrent calls
> for the day. =
> =
> Management really likes this information because it gives them a good
> idea if they need to buy more PRIs or cancel some. =
> =
> The analysis is not perfect. It only analyzes by minute so it can miss
> some connections, but it is pretty good. Usually good enough. If you
> wanted to take it out to the second, it wouldn't be that difficult
> either.
> =
> I have plans to create a php or PERL script that will perform better
> analysis but this is what I have for now. =
> =
> Hope that helps!
> =
> Court Schuett
> =
> 630-909-5560
> cschuett@hprlogistics.com
> =
> ________________________________________
_______
> cisco-voip mailing list
> cisco-voip@puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> =
| |
| Marc Hering 2005-06-09, 5:45 pm |
| MINDIPS has a utilization tracker that does this nicely 
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Court Schuett
Sent: Thursday, June 09, 2005 10:30 AM
To: cisco-voip@puck.nether.net
Cc: Drew Achterhof
Subject: [cisco-voip] PRI Utilization
I thought I've seen this request go out before and just wanted to let
people who were looking for it know that I've got a solution. It's an
ugly one, but it does work.
Here's how it goes.
Go to CAR
Device-Reports -> Gateway -> Detail
Export the data you're looking for to a CSV.
In Excel, strip out everything you don't need until your columns look
like this:
Column A: Date
Column B: Start Time
Column C: End Time
Then, in Column E, starting in Row 2, put in the minutes of the day in
number (I use Decimal 10) format. It should look like this:
0.0000000000
0.0006944444
0.0013888889
0.0020833333
0.0027777778
0.0034722222
0.0041666667
0.0048611111
0.0055555556
0.0062500000
0.0069444444
0.0076388889
0.0083333333
0.0090277778
0.0097222222
0.0104166667
0.0111111111
0.0118055556
0.0125000000
0.0131944444
Expand that down all the way until it reaches 1.
In Column E, Row 1, enter the date you want to study.
In Column F, put this function:
=SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$100
00<=E2+1/1440)*(C$1:C$10000>=E2+
1/1440))
That will analyze the first 10,000 calls for the day you put in E1.
In Column G, I put =MAX(F2:F1441) to give me the max concurrent calls
for the day.
Management really likes this information because it gives them a good
idea if they need to buy more PRIs or cancel some.
The analysis is not perfect. It only analyzes by minute so it can miss
some connections, but it is pretty good. Usually good enough. If you
wanted to take it out to the second, it wouldn't be that difficult
either.
I have plans to create a php or PERL script that will perform better
analysis but this is what I have for now.
Hope that helps!
Court Schuett
630-909-5560
cschuett@hprlogistics.com
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Voll, Scott 2005-06-09, 5:45 pm |
| Thank You..... I'm going to cancel a PRI. Wish I would have had this a
year ago. PRI's aren't cheap.
Scott
PS. Something so easy and cisco can't do it? Switch packets by the
millions but can't write a simple ASP. Cisco, are you listening. The
works done you just need to make the ASP. :-)
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Court Schuett
Sent: Thursday, June 09, 2005 7:30 AM
To: cisco-voip@puck.nether.net
Cc: Drew Achterhof
Subject: [cisco-voip] PRI Utilization
I thought I've seen this request go out before and just wanted to let
people who were looking for it know that I've got a solution. It's an
ugly one, but it does work.
Here's how it goes.
Go to CAR
Device-Reports -> Gateway -> Detail
Export the data you're looking for to a CSV.
In Excel, strip out everything you don't need until your columns look
like this:
Column A: Date
Column B: Start Time
Column C: End Time
Then, in Column E, starting in Row 2, put in the minutes of the day in
number (I use Decimal 10) format. It should look like this:
0.0000000000
0.0006944444
0.0013888889
0.0020833333
0.0027777778
0.0034722222
0.0041666667
0.0048611111
0.0055555556
0.0062500000
0.0069444444
0.0076388889
0.0083333333
0.0090277778
0.0097222222
0.0104166667
0.0111111111
0.0118055556
0.0125000000
0.0131944444
Expand that down all the way until it reaches 1.
In Column E, Row 1, enter the date you want to study.
In Column F, put this function:
=SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$100
00<=E2+1/1440)*(C$1:C$10000>=E2+
1/1440))
That will analyze the first 10,000 calls for the day you put in E1.
In Column G, I put =MAX(F2:F1441) to give me the max concurrent calls
for the day.
Management really likes this information because it gives them a good
idea if they need to buy more PRIs or cancel some.
The analysis is not perfect. It only analyzes by minute so it can miss
some connections, but it is pretty good. Usually good enough. If you
wanted to take it out to the second, it wouldn't be that difficult
either.
I have plans to create a php or PERL script that will perform better
analysis but this is what I have for now.
Hope that helps!
Court Schuett
630-909-5560
cschuett@hprlogistics.com
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
| Lelio Fulgenzi 2005-06-09, 5:45 pm |
| Under CAR > Device Reports > Gateway Utilization, I've created graphical reports of the gateways that tell me how often they are used.
It doesn't provide those fancy numbers required for erlang and busy time of day calculations, but it does show when a PRI isn't being used at all and how often a PRI is used.
----- Original Message -----
From: Voll, Scott
To: Court Schuett ; cisco-voip@puck.nether.net
Sent: Thursday, June 09, 2005 2:09 PM
Subject: RE: [cisco-voip] PRI Utilization
Thank You..... I'm going to cancel a PRI. Wish I would have had this a
year ago. PRI's aren't cheap.
Scott
PS. Something so easy and cisco can't do it? Switch packets by the
millions but can't write a simple ASP. Cisco, are you listening. The
works done you just need to make the ASP. :-)
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Court Schuett
Sent: Thursday, June 09, 2005 7:30 AM
To: cisco-voip@puck.nether.net
Cc: Drew Achterhof
Subject: [cisco-voip] PRI Utilization
I thought I've seen this request go out before and just wanted to let
people who were looking for it know that I've got a solution. It's an
ugly one, but it does work.
Here's how it goes.
Go to CAR
Device-Reports -> Gateway -> Detail
Export the data you're looking for to a CSV.
In Excel, strip out everything you don't need until your columns look
like this:
Column A: Date
Column B: Start Time
Column C: End Time
Then, in Column E, starting in Row 2, put in the minutes of the day in
number (I use Decimal 10) format. It should look like this:
0.0000000000
0.0006944444
0.0013888889
0.0020833333
0.0027777778
0.0034722222
0.0041666667
0.0048611111
0.0055555556
0.0062500000
0.0069444444
0.0076388889
0.0083333333
0.0090277778
0.0097222222
0.0104166667
0.0111111111
0.0118055556
0.0125000000
0.0131944444
Expand that down all the way until it reaches 1.
In Column E, Row 1, enter the date you want to study.
In Column F, put this function:
=SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$100
00<=E2+1/1440)*(C$1:C$10000>=E2+
1/1440))
That will analyze the first 10,000 calls for the day you put in E1.
In Column G, I put =MAX(F2:F1441) to give me the max concurrent calls
for the day.
Management really likes this information because it gives them a good
idea if they need to buy more PRIs or cancel some.
The analysis is not perfect. It only analyzes by minute so it can miss
some connections, but it is pretty good. Usually good enough. If you
wanted to take it out to the second, it wouldn't be that difficult
either.
I have plans to create a php or PERL script that will perform better
analysis but this is what I have for now.
Hope that helps!
Court Schuett
630-909-5560
cschuett@hprlogistics.com
________________________________________
_______
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
| |
| Luxem, Doug 2005-06-09, 5:45 pm |
| I extended your calculations to see peak usage by second, and after a
*very* long time Excel finally kicked out some numbers. For the most
part, it looks like the "by minute" peaks where 0-2 calls below the "by
second" peaks per PRI per day.
Thanks for the formulas though. Time to put a spreadsheet together that
does a 10-day rolling peak usage.
-Doug
-----Original Message-----
From: cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Court Schuett
Sent: Thursday, June 09, 2005 9:30 AM
To: cisco-voip@puck.nether.net
Cc: Drew Achterhof
Subject: [cisco-voip] PRI Utilization
I thought I've seen this request go out before and just wanted to let
people who were looking for it know that I've got a solution. It's an
ugly one, but it does work.
Here's how it goes.
Go to CAR
Device-Reports -> Gateway -> Detail
Export the data you're looking for to a CSV.
In Excel, strip out everything you don't need until your columns look
like this:
Column A: Date
Column B: Start Time
Column C: End Time
Then, in Column E, starting in Row 2, put in the minutes of the day in
number (I use Decimal 10) format. It should look like this:
0.0000000000
0.0006944444
0.0013888889
0.0020833333
0.0027777778
0.0034722222
0.0041666667
0.0048611111
0.0055555556
0.0062500000
0.0069444444
0.0076388889
0.0083333333
0.0090277778
0.0097222222
0.0104166667
0.0111111111
0.0118055556
0.0125000000
0.0131944444
Expand that down all the way until it reaches 1.
In Column E, Row 1, enter the date you want to study.
In Column F, put this function:
=SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$100
00<=E2+1/1440)*(C$1:C$10000>=E2+
1/1440))
That will analyze the first 10,000 calls for the day you put in E1.
In Column G, I put =MAX(F2:F1441) to give me the max concurrent calls
for the day.
Management really likes this information because it gives them a good
idea if they need to buy more PRIs or cancel some.
The analysis is not perfect. It only analyzes by minute so it can miss
some connections, but it is pretty good. Usually good enough. If you
wanted to take it out to the second, it wouldn't be that difficult
either.
I have plans to create a php or PERL script that will perform better
analysis but this is what I have for now.
Hope that helps!
Court Schuett
630-909-5560
cschuett@hprlogistics.com
________________________________________
_______
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
| |
|
|
| Candace Holman 2005-06-29, 5:45 pm |
| If they are all on trunks between CM you can monitor the trunks. Device
Reports -> Gateways -> Details -> H323 Gateways. Otherwise there might be
a gateway type listed there that you can use. If there are no gateways
between sites, you might be out of luck or have to use CDRs based on
extensions.
Candace
At 02:36 PM 6/29/2005, Voll, Scott wrote:
>New question. How do I find out how many concurrent calls I have between
>locations? IE. central site to remote site. We are getting fiber and I
>want to know how much I really need to support our on net calls.
>
>Thanks
>
>Scott
>
>-----Original Message-----
>From: cisco-voip-bounces@puck.nether.net
>[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Voll, Scott
>Sent: Thursday, June 09, 2005 11:09 AM
>To: Court Schuett; cisco-voip@puck.nether.net
>Subject: RE: [cisco-voip] PRI Utilization
>
>Thank You..... I'm going to cancel a PRI. Wish I would have had this a
>year ago. PRI's aren't cheap.
>
>Scott
>
>PS. Something so easy and cisco can't do it? Switch packets by the
>millions but can't write a simple ASP. Cisco, are you listening. The
>works done you just need to make the ASP. :-)
>
>
>
>-----Original Message-----
>From: cisco-voip-bounces@puck.nether.net
>[mailto:cisco-voip-bounces@puck.nether.net] On Behalf Of Court Schuett
>Sent: Thursday, June 09, 2005 7:30 AM
>To: cisco-voip@puck.nether.net
>Cc: Drew Achterhof
>Subject: [cisco-voip] PRI Utilization
>
>I thought I've seen this request go out before and just wanted to let
>people who were looking for it know that I've got a solution. It's an
>ugly one, but it does work.
>
>Here's how it goes.
>
>Go to CAR
>Device-Reports -> Gateway -> Detail
>
>Export the data you're looking for to a CSV.
>
>In Excel, strip out everything you don't need until your columns look
>like this:
>Column A: Date
>Column B: Start Time
>Column C: End Time
>
>Then, in Column E, starting in Row 2, put in the minutes of the day in
>number (I use Decimal 10) format. It should look like this:
>0.0000000000
>0.0006944444
>0.0013888889
>0.0020833333
>0.0027777778
>0.0034722222
>0.0041666667
>0.0048611111
>0.0055555556
>0.0062500000
>0.0069444444
>0.0076388889
>0.0083333333
>0.0090277778
>0.0097222222
>0.0104166667
>0.0111111111
>0.0118055556
>0.0125000000
>0.0131944444
>
>Expand that down all the way until it reaches 1.
>
>In Column E, Row 1, enter the date you want to study.
>In Column F, put this function:
> =SUMPRODUCT((A$1:A$10000=E$1)*(B$1:B$100
00<=E2+1/1440)*(C$1:C$10000>=E2+
>1/1440))
>
>That will analyze the first 10,000 calls for the day you put in E1.
>In Column G, I put =MAX(F2:F1441) to give me the max concurrent calls
>for the day.
>
>Management really likes this information because it gives them a good
>idea if they need to buy more PRIs or cancel some.
>
>The analysis is not perfect. It only analyzes by minute so it can miss
>some connections, but it is pretty good. Usually good enough. If you
>wanted to take it out to the second, it wouldn't be that difficult
>either.
>
>I have plans to create a php or PERL script that will perform better
>analysis but this is what I have for now.
>
>Hope that helps!
>
>Court Schuett
>
>630-909-5560
>cschuett@hprlogistics.com
>
> ________________________________________
_______
>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
| |
| Candace Holman 2005-06-29, 5:45 pm |
| If there are no gateways between sites you can report on utilization via
Route Pattern, List, or Group too.
Candace
At 02:40 PM 6/29/2005, Candace Holman wrote:
>If they are all on trunks between CM you can monitor the trunks. Device
>Reports -> Gateways -> Details -> H323 Gateways. Otherwise there might be
>a gateway type listed there that you can use. If there are no gateways
>between sites, you might be out of luck or have to use CDRs based on
>extensions.
>
>Candace
>
>At 02:36 PM 6/29/2005, Voll, Scott wrote:
>
>
> ________________________________________
_______
>cisco-voip mailing list
>cisco-voip@puck.nether.net
>https://puck.nether.net/mailman/listinfo/cisco-voip
|
|
|
|
|