" /> Call by Skill report Genaration - Genesys CTI User Forum

Author Topic: Call by Skill report Genaration  (Read 2172 times)

Offline ajithmurary

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
Call by Skill report Genaration
« on: July 15, 2015, 01:54:56 PM »
Advertisement
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

Offline nonny

  • Full Member
  • ***
  • Posts: 218
  • Karma: 2
Re: Call by Skill report Genaration
« Reply #1 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?

Offline ajithmurary

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
Re: Call by Skill report Genaration
« Reply #2 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

Offline Kubig

  • Hero Member
  • *****
  • Posts: 2755
  • Karma: 44
Re: Call by Skill report Genaration
« Reply #3 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.