Moodle SQL for users online

This works for Postgresql:

select count(*) from mdl_user where
mdl_user.lastaccess > (date_part('epoch'::text, now())::bigint - 300);

or

select firstname,lastname  from mdl_user where
mdl_user.lastaccess > (date_part('epoch'::text, now())::bigint - 300)
order by 2,1;

Comments

Comments powered by Disqus