Trigger "Last Access"

Trigger Details

• Tracks course access of/with every role
• "Login as" does not trigger, the original/real user has to login

SQL

    SELECT
        la.courseid
    FROM
        m_user_enrolments ue
        JOIN m_enrol e ON ue.enrolid = e.id
        JOIN m_user_lastaccess la ON ue.userid = la.userid
    WHERE
        e.courseid = la.courseid
    GROUP BY
        la.courseid
    HAVING
        MAX(la.timeaccess) < 1755762501