Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: ajithmurary on July 15, 2015, 01:54:56 PM

Title: Call by Skill report Genaration
Post by: ajithmurary on July 15, 2015, 01:54:56 PM

Hi All,


I am not able to figure how to generate a report which shows me calls by skills
In our  environment we route calls using skill base routing and use virtual queues
There is infomart in our environment

I am not sure what keys to join in an sql query .
I am using toad to access the db


Please help me


thanks

Title: Re: Call by Skill report Genaration
Post by: nonny on July 16, 2015, 05:34:34 AM

Out of the box Info Mart/Interactive Insights reports should show calls sent to/through VQs, provided you have actually used those VQs in your routing.  Are you seeing any calls at all in Interactive Insights for VAGs?

Title: Re: Call by Skill report Genaration
Post by: ajithmurary on July 16, 2015, 01:10:23 PM

we are using VQ for routing but dont use interactive insights
just use TOAD to access Infomart schemas


just looking for a clue  fro a script to map all the calls by skill

Title: Re: Call by Skill report Genaration
Post by: Kubig on July 17, 2015, 07:45:06 AM

What is your current SQL query for these purposes? It depends on your GIM configuration, especially on what KVP are you collecting, etc.