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?
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"
