Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

SQL Query all inbound phone numbers

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
New Member

Re: SQL Query all inbound phone numbers

Nobody?

New Member

Re: SQL Query all inbound phone numbers

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

New Member

Re: SQL Query all inbound phone numbers

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.

430
Views
0
Helpful
3
Replies