topic Re: Monitoring Capacity Licences by user consumption in Management & Governance

Monitoring Capacity Licences by user consumption

stuwannop — Sat, 16 Nov 2024 01:31:21 GMT

HI Everyone

What is the best way of monitoring time spent by user when using capacity licencing? I know you can see total time used in the console but I need to find a way of monitoring which individuals are using the most allotted time in a given period/overall. I assume this is possible as it should be captured in the events log but wonder if anyone could tell me the best / easiest way of implementing this?

thanks

Stuart

Re: Monitoring Capacity Licences by user consumption

gandalfgray — Tue, 08 Sep 2020 11:43:54 GMT

Hi Stuart

I prefer to read the repository database QSR to find out things like this.

This query is an example that gives you AnalyzerTime data per user

select count(*) As sessions
    ,count(*)*6 As minutes_consumed
     ,min("UseStartTime") As first_session
     ,"ModifiedByUserName"
from "LicenseAnalyzerTimeAccessUsages"
group by "ModifiedByUserName"