[cisco-voip] PRI Utilization

[Candace Holman]

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:
> >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 at puck.nether.net
> >[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Voll, Scott
> >Sent: Thursday, June 09, 2005 11:09 AM
> >To: Court Schuett; cisco-voip at 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 at puck.nether.net
> >[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Court Schuett
> >Sent: Thursday, June 09, 2005 7:30 AM
> >To: cisco-voip at 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$10000<=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 at hprlogistics.com
> >
> >_______________________________________________
> >cisco-voip mailing list
> >cisco-voip at puck.nether.net
> >https://puck.nether.net/mailman/listinfo/cisco-voip
> >
> >_______________________________________________
> >cisco-voip mailing list
> >cisco-voip at puck.nether.net
> >https://puck.nether.net/mailman/listinfo/cisco-voip
> >
> >_______________________________________________
> >cisco-voip mailing list
> >cisco-voip at puck.nether.net
> >https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
>_______________________________________________
>cisco-voip mailing list
>cisco-voip at puck.nether.net
>https://puck.nether.net/mailman/listinfo/cisco-voip