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

CDR Report

Hii all,

I am using 2 CCM 5.1( MCS7835 server)in different cluster and 7906G IP phone. some IP Phones registered in 1st cluster and some ip phones registered in 2nd cluster. Now when I am going to generate the call report by CDR, it is displaying unspecified user in user name column for those call which came form another cluster.though every Ip phone having a User ID.

I am attaching the report which I generated through CDR. please find the attachment.

and I also want to display the destination name in report sheet.

is it possible? if possible , please suggest me as soon as possible.

thanks & regards



Re: CDR Report

Depending on the verison of CCM that you are running and if you have CDR recording turned on, you should be able to pull this information directly out of SQL.

If you ran the query against the CDR database: select * from CallDetailRecord where callingPartyNumber = '122'

This should give you all of the outgoing calls that this extension made. You can even narrow it down by adding in some time constraints to the query.

Also, you could use CAR if you have that enabled. It will give you a nice GUI to use instead of doing a direct query on the DB. From this doc;

Logging CDR to External Servers

Community Member

Did you ever get a clear

Did you ever get a clear answer to this? 

CreatePlease to create content