Max Pri concurrent channel usage reports

[sammysammys]

Hi,

I am running cucm 7.1.3 and need to get some concurrent reports for my PRI's.  We are moving to sip and need to get an idea on the max number of channels we might use at any one time.  I've found the detail and utilization reports for gateways in the cdr tools, but haven't found anything that can give me a decent max concurrent port usage report.  Sorry if I'm reposting, I did some searches on both the web and this site and couldn't find anything close to what I need.

I have 5 pri's connected to Cisco 2811 gateways, and need to run reports on groups or individual pri's.

Thanks

[Jaime Valencia]

CUCM really doesn't have any historical info of this other than what you've found.

If you need this, you'll probably need to use RTMT to look at some perfmon counters about the GWs.

HTH

java

If this helps, please rate

www.cisco.com/go/pdihelpdesk

[sammysammys]

Here's what I did.  I can't see any logical holes, so maybe you guys can point them out if I missed them.  I ran daily detailed reports on all of the pri's that I wanted concurrent use stats for. I then stripped each daily down to start time, and end time, and applied the following equation to:

Assume Start_Time is Column_A and End_Time is Column_B

In another column, for example column C, enter this formula in row 2 (I assume row 1 has titles) and copy down your 30,000 lines:

=SUMPRODUCT(--($A$2:$A$30000A2))+1

This formula in plain English says: I am the call that is recorded in cell A2. Show me how many other calls in the list have a start time smaller than me AND an end time greater than my start time. Because the SUMPRODUCT formula only counts the OTHER calls, add a 1 for the call recorded in this row.

The result is a number. For each call you can see how many calls occurred in the same time window as this call.

The results seemed to match our rtmt numbers, but I can't help but think I'm missing something.  I didn't come up with the formula, it was one of my resident excel guys .

[gtechfred01]

Had same issue while waiting for a true CDR package to be installed....I could not get the sumproduct formula Sammy posted, but used it to create the attached. Results seem realistic based on the eyeball test and what I know of this customer's environment. Luckily this is a small number of lines/calls or I wouldn't be sure about calculations. Hope this helps!