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發表於
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?

評比平均分數: -
In reply to 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.
In reply to 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.

In reply to 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.
In reply to 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"

In reply to 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?