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 
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.
There are other, commercial methods for this. PM me if you are interested.