Author Topic: how to get number of waiting interactions on a specific queue at given time?  (Read 138 times)

Offline mic

  • Newbie
  • *
  • Posts: 44
  • Karma: -1
I need to know the number of waiting interactions on a specific queue at given time, is it possible to know this from GIM or any other database.
I have email, Live Chat, and twitter channels.

appreciate any advise

Offline mic

  • Newbie
  • *
  • Posts: 44
  • Karma: -1
I mean on a specific virtual queue

Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 6821
  • Karma: 56331
?? StatServer will provide that...by a DB? That would mean any interaction is stored everytime...

Offline hsujdik

  • Sr. Member
  • ****
  • Posts: 295
  • Karma: 14
    • Genesys Brasil
Although it is possible to obtain from GIM, it is not straightforward.

You would need the Epoch Time of the second which you are looking for (number of seconds since 01/01/1970 00:00 UTC) and query the mediation_segment_fact table something as following:

select count(1) from mediation_segment_fact msf
inner join resource_ queue on queue.resource_key = msf.resource_key
where queue.resource_name = 'QUEUE_NAME’
and EPOCH_TIME between msf.start_ts and msf.end_ts


Offline cavagnaro

  • Administrator
  • Hero Member
  • *****
  • Posts: 6821
  • Karma: 56331
 :o  Seems this InfoMart does have much more info than I expected...
Hail hsujdik  8)

Offline hsujdik

  • Sr. Member
  • ****
  • Posts: 295
  • Karma: 14
    • Genesys Brasil
Well, it is a workaround to get that info. Not an oficial metric (: