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

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

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

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

144
Views
0
Helpful
1
Replies
CreatePlease to create content