Link to home
Avatar of ccorino1
ccorino1

asked on

Reporting Utilities for Cisco CDR Analysis and Reporting?

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.
Avatar of José Méndez
José Méndez

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".
Avatar of ccorino1

ASKER

Thanks willy...
Do you know any of those reports that I can do that by extension?
System reports > traffic > summary by extension > choose day of week (most helpful)
Thanks Willy...Question: Does that report only show internal calls?  
Not necessarily. Did you see all the checkbox filters in the section "Call types"?
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???
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.
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
ASKER CERTIFIED SOLUTION
Avatar of José Méndez
José Méndez

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
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.
Yeah cuz you were initially looking into raw ugly looking data LOL, but yes, Avotus is one alternative.