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

Doulos Xavier -
回帖数：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?

平均分： -
回复Doulos Xavier

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

Rick Jerz -
Particularly helpful Moodlers的头像 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.
平均分： -
回复Rick Jerz

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

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.

平均分： -
回复Doulos Xavier

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

Rick Jerz -
Particularly helpful Moodlers的头像 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.
平均分： -
回复Rick Jerz

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

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"

平均分： -
回复Doulos Xavier

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

Rick Jerz -
Particularly helpful Moodlers的头像 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?
平均分： -