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

[sandeepontop]

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

[jim]

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