Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

CDR report for SIP trunks in CUCM 6.1.2

Is there a way in CDR reports to get a report of incoming calls on SIP trunks?

I was trying to do a gateway detail report which lists the calls on

selected gateways, and has the number called, the calling number, etc

but under gateway types there is not an option for a SIP trunk or any

kind of trunk anywhere. The gateway summary report only shows calls

for a remote H323 gateway, but we're looking for inbound calls on the

clients main telephone company trunks which are all SIP.

This is on a Call Manager version 6.1.2-1000.

3 REPLIES
Cisco Employee

Re: CDR report for SIP trunks in CUCM 6.1.2

Hi!

You can check this bug:

CSCsk87140

Symptom:

Calls through an H.323 or SIP Trunk do not show up in the gateway utilization

reports in the CDR Analysis and Reporting Tool on Cisco Unified Communications

Manager.

Conditions:

Using the Gateway Utilization report to monitor trunk utilization.

Workaround:

None

The bug is New and I believe there's no fix yet.

Regards, Tere. If you find this post helpful, please rate! :)

Re: CDR report for SIP trunks in CUCM 6.1.2

Thanks.

So, there is no option in CDR to get call reports on these calls without using a third party tool now?

Cisco Employee

I was working with a customer

I was working with a customer with the same issue/question, I found this support forums while researching the issue, but there wasn't enough info. I'd like to share the Steps Done/ Resolution of that case:

Problem Description:

Customer wants to get CDR reports for their SIP trunks specifically.

CUCM 10.5.1.10000-7

 

Actions Taken:

 

-From the CDR tool if we filter by "Gateways" we only see H323 and MGCP gateways, SIP trunks don't come up.

 

-If we try to filter by “Trunks” specifically, we only have the option to extract "Utilization" information, which only displays bandwidth usage info, not calls info.

 

-After further investigation, it looks like the only way to export SIP trunk calls information on CDR is to do a full export:

 

I provided these steps:

 

1-Go to CDR Analysis and Reporting> Export CDR/CMR> Enable CDR records only> Click on "Export file".

2-Go to Excel> Open > Look for that file. On the import wizard select "Delimited" instad of "Fixed width"> Next>  Check "Comma" as the Delimiter> Finish

3-You can use Control+F and navigate on the file, some filters that can be used are:

"callingPartyNumber"

"originalCalledPartyNumber"

 

910
Views
0
Helpful
3
Replies
CreatePlease to create content