This document was generated from CDN thread
Created by: Trevor Petersen on 12-02-2010 04:36:43 PM
In the CDR records, I can find the callingnumber, but not the caller ID of the received call.
On the phones, in the directories menu I can find both the number and the name that was received. Is this information stored anywhere in the CDR?
Subject: RE: Caller ID records in CDR?
Replied by: Mahmoud Ahmed on 12-02-2010 04:36:43 PM
Hi ...
No The CDR haven't this information
But
I think you can export all "users And Phones" info using "BAT" service in the callmanager
Select from Application >> BAT
Subject: RE: Caller ID records in CDR?
Replied by: Mayank Sharma on 12-02-2010 04:36:43 PM
I am not sure if you are still looking for this information but caller id is stored in field "Display" in DeviceNumPlanMap table. So you should use the OrigDeviceName in the CDR to find the device in Device table and then use the pkid of that device to pull the name from DeviceNumPlanMap table.
