How to generate a report of a user with maximum usage in terms of viewing a Moodle system

How to generate a report of a user with maximum usage in terms of viewing a Moodle system

by Doulos Xavier -
Number of replies: 6

How to generate a report of a user with maximum usage in terms of viewing a Moodle system. Is this possible at all in the first place?

Average of ratings: -
In reply to Doulos Xavier

Re: How to generate a report of a user with maximum usage in terms of viewing a Moodle system

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
You might need to define what you mean by:
"maximum usage"
"viewing a Moodle system"
 
But, you might want to explore some SQL solutions.  See List of SQL Contributed reports.
In reply to Rick Jerz

Re: How to generate a report of a user with maximum usage in terms of viewing a Moodle system

by Doulos Xavier -

Thanks Rick. With Maximum usage I mean, the longest time among the all the users that an user has logged into the system. With no GUI installed for server management the SQL query option does not exist at the moment. Appreciate your inputs.

In reply to Doulos Xavier

Re: How to generate a report of a user with maximum usage in terms of viewing a Moodle system

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
"longest time"

Moodle doesn't log "elapsed time," if this is what you mean. It logs the "clock time" that an action took place.
In reply to Rick Jerz

Re: How to generate a report of a user with maximum usage in terms of viewing a Moodle system

by Doulos Xavier -

Thanks Rick. Yes, then If  there is a way to get the longest "clock time" among all the users which user has the longest "clock time"

In reply to Doulos Xavier

Re: How to generate a report of a user with maximum usage in terms of viewing a Moodle system

by Rick Jerz -
Picture of Particularly helpful Moodlers Picture of Testers
"Clock time" is an instance in time, such as 10:52:30 AM. It doesn't span any time. In other words, it has a length of 0.

The "clock time" is generally recorded when a Moodle user "clicks" on something. If you click on something, then go away from your computer to watch TV for an hour, and then return to your computer and click on something again, how long have you been doing something at your computer? An hour? Two seconds? Do you see the issue?