Extracting data form Infomart DB

[aur8l]

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

[hsujdik]

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.

[Adam G]

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