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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide