Need Help to make SQL Query

[4deepakkaushikk]

Dear Experts,

Request your help to create a SQL Query in ICM DB

i have a list of of 10 agents i want to know these agents transfer how many call to perticalar vdn(skillsets).

BR,

Deepak

[Sasikumar Divvela]

From Termination_Call_Detail separate you can filter

1) Those 10 agents

2) Separate call disposition 28 (Blind transfer) & 29(Consult Transfer) for those agents

3) Then filter Digits Dialed column in those records.

That should be the Dial Number agent used to transfer call. That could be a post route VDN or service VDN or direct skill extension.

Hope this helps.

Sasikumar.