Genesys CTI User Forum

Genesys CTI User Forum => Genesys CTI Technical Discussion => Topic started by: aur8l on October 18, 2016, 04:07:59 AM

Title: Extracting data form Infomart DB
Post by: aur8l on October 18, 2016, 04:07:59 AM

Hi all,

I currently am asked to gather data around peak licenses used in our contact centre. Problem is that I don't have access to the license server so can't get any data out of this. I have access to the Infomart DB though and I am pretty sure I can get what I need form there. Does anyone know what would be the best approach to have the max number of seats used at the same time by day for the last 6 months, just using the Infomart? is it even possible?

Thanks :)

Title: Re: Extracting data form Infomart DB
Post by: hsujdik on October 18, 2016, 06:54:31 PM

It could be possible, but it is not straightforward.

If you are looking for "logged in" agents, I would recommend looking into SM_RES_SESSION_FACT table. However, the only way I could think about it is to scan for each "second" and check the count of records that were active at that second. This wouldn't come in a friendly way... should need a script to iterate over each second.

Maybe there are easier ways, but its the only one I can think about.

Title: Re: Extracting data form Infomart DB
Post by: Adam G on October 18, 2016, 09:07:20 PM

There are other, commercial methods for this.  PM me if you are interested.