Waiting time for abandoned call

[Noufal]

Dear Experts ,

I looking for DB query to list Abandoned call (raw data fro icon or GIM ) with below details

Queue Name , CAll ANI , Abandoned waiting time .

[hsujdik]

No other data (like, VQ enter date/time)? All of them or filter by specific group? If those fields are all that you want, and you want all of the calls that are on GIM database:

select
vq.resource_name as vq_name,
i.source_address as ani,
msf.end_ts - msf.start_ts as wait_time
from
mediation_segment_fact msf
inner join resource_ vq on vq.resource_key = msf.resource_key
inner join interaction_fact i on i.interaction_id = msf.interaction_id
inner join media_type mt on mt.media_type_key = msf.media_type_key
inner join technical_descriptor td on td.technical_descriptor_key = msf.technical_descriptor_key
where
mt.media_name_code = 'VOICE'
and vq.resource_type_code = 'QUEUE'
and vq.resource_subtype = 'VirtualQueue'
and td.technical_result_code in ('ABANDONED', 'CUSTOMERABANDONED');