cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
722
Views
0
Helpful
3
Replies

SQL Query all inbound phone numbers

sturcott9891
Level 1
Level 1

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?

3 Replies 3

sturcott9891
Level 1
Level 1

Nobody?

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

Steven Pawlak
Level 1
Level 1

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.

Getting Started

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: