Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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"