CDR Report

soma.india08 · ‎04-16-2008

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

Soma

htarra · ‎04-22-2008

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.

http://www.cisco.com/en/US/docs/voice_ip_comm/cucme/srnd/design/guide/managcme.html From this doc;

http://www.cisco.com/en/US/products/sw/voicesw/ps4625/products_implementation_design_guide_chapter09186a00805f07a8.html#wp1077193

Logging CDR to External Servers

http://www.cisco.com/en/US/docs/voice_ip_comm/cucme/srnd/design/guide/managcme.html#wp1076118

Adam Hinchliff · ‎05-04-2016

Did you ever get a clear answer to this?