cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

215
Views
0
Helpful
1
Replies
sandeepontop
Beginner

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

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 REPLY 1
jim
Beginner
Beginner

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

Create
Recognize Your Peers
Content for Community-Ad