Hardware and performance

You could always use custom SQL to access the data. I don't know if Moodle has a report for this purpose, but others here on Moodle.org might reply. You might want to mention the version of Moodle you are using.

Also, consider providing your definition of "online live users." Do you mean "logged in at least once within a day, month, or year?"  Also, what do you mean by "online?"  Are you suggesting online courses versus face-to-face?  And I am a little puzzled by "live."  Aren't all students "alive?"  Do you have "dead" students taking course, such as machines?  Do you want to include only students?  Teachers?  Administrators?

 

Consider exploring List of SQL Contributed reports for examples.

 

I believe every "login" is captured in the mdl_logstore_standard_log table.

 

As a starting point, below is my custom SQL that shows me who was logged in during the last 60 minutes.

 

 

 

# Shows users logged in the last 60 minutes.
#   I wonder if it would be helpful to show the course that the student is in?
# Modified 1/15/20 with an attempt to fix problems around midnight.  It should now work.

SELECT firstname,
       lastname,
       from_unixtime(lastaccess) AS LastClick,
       timediff(now(), from_unixtime(lastaccess)) AS lastaccess,
       timestampdiff(MINUTE, from_unixtime(lastaccess), now()) AS minutes_ago
FROM prefix_user HAVING minutes_ago < 60
order by lastaccess

You are probably better off using your web server logs for this type of information that the Moodle database. It will be more accurate and easier to deal with. Many APM system can extract this from standard Apache or nginx logs with little effort