Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: Noufal on March 21, 2018, 11:30:28 AM

Title: Answered calls
Post by: Noufal on March 21, 2018, 11:30:28 AM

Dears

Where i can find answered calls in Icon and GIM DB.

do you have any MS SQL query for this ?

Title: Re: Answered calls
Post by: hsujdik on March 21, 2018, 12:12:09 PM

Which information do you need?

The most raw query on GIM DB would be something like this:

select * from interaction_resource_fact irf
inner join technical_descriptor td on td.technical_descriptor_key = irf.technical_descriptor_key
where td.technical_result_code not in ('ABANDONED','CUSTOMERABANDONED');

But for a better result you must detail a bit more what you need

Title: Re: Answered calls
Post by: eduardosaito on March 26, 2018, 05:44:45 AM

IRF would be detailed calls (each line 1 interaction)

But if you only wants the numbers, there are several tables you could get it like the ag2_queue ones.

Agree with hsujdik, you have to put more details about it.