Solved

Reporting Utilities for Cisco CDR Analysis and Reporting?

Posted on 2011-09-07
11
1,868 Views
Last Modified: 2013-12-07
Hello,

Hopefully I'm giving enough information with this, because Cisco CDR Reporting is new to me...

I am trying to run reporting using Cisco Unified Communications Manager CDR Analysis and Reporting For Cisco Unified Communications through Cisco Unified Serviceability (System version: 6.1.5.12900-7).  When I run an extension based report, it comes out in a very ugly format.  When I try to "Send Report", it it sent in an even uglier .txt format.

I'm sure there are utilities can make this look a lot nicer, but I'm not sure what is good out there.
0
Comment
Question by:ccorino1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 20

Expert Comment

by:José Méndez
ID: 36498311
I think you are dumping raw data by going into CDR > Search > By User/Extension.

You won't find pretty reports there. For the good looking ones use the first 3 menus on the left, that actually contain the word "Report".
0
 

Author Comment

by:ccorino1
ID: 36498354
Thanks willy...
Do you know any of those reports that I can do that by extension?
0
 
LVL 20

Expert Comment

by:José Méndez
ID: 36498487
System reports > traffic > summary by extension > choose day of week (most helpful)
0
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

Author Comment

by:ccorino1
ID: 36512603
Thanks Willy...Question: Does that report only show internal calls?  
0
 
LVL 20

Expert Comment

by:José Méndez
ID: 36513064
Not necessarily. Did you see all the checkbox filters in the section "Call types"?
0
 

Author Comment

by:ccorino1
ID: 36513248
Yes, I did.  This report does not show incoming calls, which kind of stinks.
Another thing I don't understand is the fact it has cells such as:
DateTimeOrigination
DateTimeConnect
DateTimeDisconnect

But they are written in a format I can't understand.  
Such as:
1312828323
1312994879
1313081949
1313275408
1313346146
1313427432
1313701439
1313772296
1314020573

I honestly have no clue how that correlates to the actual date and time.  Do you have any ideas???
0
 
LVL 20

Expert Comment

by:José Méndez
ID: 36513335
Based on that output description, you are not going to the menu option I posted. Try this:

System reports > traffic > summary by extension. Don't go to the CDR menu.

If you follow those steps, you should get a PDF or a CSV output with no mention of DateTimeOrigination,
DateTimeConnect, DateTimeDisconnect.
0
 

Author Comment

by:ccorino1
ID: 36513398
Ugh, I was working with a report that I did yesterday...

So I ran that report you suggested, thank you by the way, but it only gives me a very high level report.  As you know, it only displays stuff such as "On Monday, extension 5555 received 112 calls".  Is there anything a little more detailed that you know of?

Sorry for the confusion
0
 
LVL 20

Accepted Solution

by:
José Méndez earned 200 total points
ID: 36513549
Not from CAR. The front end is not very useful, although the CDR records contain enormous amounts of data. You may want to look for another Cisco compatible billing system such as Avotus Pro. If you have an account with Cisco, you may download a trial version. Search for "Third party billing" in Cisco.com.
0
 

Author Comment

by:ccorino1
ID: 36513568
LOL, the original question is exactly that:
"I'm sure there are utilities can make this look a lot nicer, but I'm not sure what is good out there."

I will look for Avotus.
0
 
LVL 20

Expert Comment

by:José Méndez
ID: 36513595
Yeah cuz you were initially looking into raw ugly looking data LOL, but yes, Avotus is one alternative.
0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this tutorial I will show you with short command examples how to obtain a packet footprint of all traffic flowing thru your Juniper device running ScreenOS. I do not know the exact firmware requirement, but I think the fprofile command is availab…
Many network operators, engineers, and administrators do not take several factors into consideration when troubleshooting network throughput and latency issues.  They often  measure the throughput by performing a measurement  by transferring a large…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question