09-30-2010 01:32 PM - edited 03-14-2019 06:36 AM
Hey everybody, I need to pull a report that lists all of the Inbound phone numbers for everyone that called us over the last month and I'm having problems with UCCX 5 finding where the phone numbers might be kept. I thought it might be in dbo.contactcalliddetail and then origcallednumber or originatordn or something but I've gone through all of those fields and none of them seem to be it. Anybody know where that information might be kept in the database?
10-04-2010 09:26 AM
Nobody?
10-04-2010 09:45 AM
Run this on your UCM.
This will display all calls for extension XXXX.
run sql select callingpartynumber, originalcalledpartynumber, finalcalledpartynumber,datetimestamporigination,datetimeconnect,datetimedisconnect,duration from car:tbl_billing_data where originalcalledpartynumber in ('XXXX')
-B
10-04-2010 12:45 PM
originatorDN in ContactCallDetail should be the field. Unless you are not getting caller ID passed down your lines from the telco. Then you would be blank.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: