Dears
Where i can find answered calls in Icon and GIM DB.
do you have any MS SQL query for this ?
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
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.