How to export Historical Queue report 15 min to a separate CSV file

Genesys Cloud Routing
1

Hello
How can one export Historical Queue report 15 min interval data to a separate CSV file for each interval for a whole week in the Genesys world
And select specific stats to be available.
eg
Date-13:00.csv
Date-13:15.csv
Date-13:30.csv

each file has something like this format..
Queue;Interval;CallVolume;ASA,AHT
Q1;13:00;4;5
Q2;13:00;2;1

any pointers where to start would be appreciated :slight_smile:

CB

2

from what ??

ccpulse, icon, gim, pulse

3

Hi Tambo
would be in GIM/icon

CB

4

do you use Business intelligence for historical report (for GIM), if you have it… its very easy , generate report for the day and drill with date raw first it will come with hour second it will come with 30 min third 15 min

5

if you’re using GI2 as Noufal says then there shouldn’t be any issues, or are you just wanting an export straight out from GIM?

6

Hi folks
Yes I can generate the report in the web interface..but what I am after is getting the csv files generated in the above mentioned format in separate files.. as I need this data for one month for example that has the break down for each days 15 min interval not sure how would u do this ..

CB

Sent from my SM-G925I using Tapatalk

7

Do a job in sql to export to csv.

Enviado de meu E6633 usando o Tapatalk

8

This way pointed by cavagnaro would be the easiest one. That can be done in GI2 as well, but it would be a pain to do so. If you need help, I can guide you on how you on how you need to build the queries.

9

Actually is the “easiest” but also the dummiest…I always reject this kind of requests due creating an extra point of failure.
Actually you have a 3rd party tool that will import this export of a DB, the correct solution is your 3rd party app to connect directly to the DB and avoid middle solutions with possible errors.

Enviado de meu E6633 usando o Tapatalk

10

Hi Cav
Yes agree in ideal situation then connecting to DB directly would be the way to go .. unfortunately we are under the mercy of 3rd party tool and how it works

CB

Sent from my SM-G925I using Tapatalk

11

Would be awesome if u can help me ..what would query look like

CB

Sent from my SM-G925I using Tapatalk