SQL quarry to be run, Help reqd !!!!

Unanswered Question
Aug 26th, 2009
User Badges:

Hi,


I would need to run a SQL quary to generate Inbound Calls which have landed to the Skill Group. We do also need to the numbers from which the calls are coming ?? request you to help with the SQL script so that I could run it in Admin Workstation.


Regards,

Sandeep

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.

This works on CM 4.x where XXX is the extension called.


select callingpartynumber,finalcalledpartynumber,originalCalledPartyNumber,

datetimeorigination,datetimedisconnect,duration,DATEADD(ss, datetimeorigination,'Jan 1, 1970 00:00:00')

from calldetailrecord

where originalCalledPartyNumber='XXX'

order by dateTimeConnect

Actions

This Discussion