SQL Query all inbound phone numbers

Unanswered Question
Sep 30th, 2010
User Badges:

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?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
bburney Mon, 10/04/2010 - 09:45
User Badges:

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')


Steven Pawlak Mon, 10/04/2010 - 12:45
User Badges:

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.


This Discussion