Tracking the usage by employee on ERPNEXT

ERPNext
1

so i tried creating the Activity checker for the employees to know which all employees have logged and which all haven’t to the system , for which i took two factors

Activity log> Status(Sucess) + Operation(Login) +Subject (%in%)

the above gave me a list of all employees logged in the system and then i vlooked up the same data with all the users available in the system through if or if not and created a QUERY REPORT
with below code

SELECT DISTINCT
u.name AS User,
CASE
WHEN al.user IS NOT NULL
AND al.operation = ‘Login’
AND al.status = ‘Success’
AND DATE(al.communication_date) = CURDATE()
THEN ‘Present’
ELSE ‘Absent’
END AS Remark
FROM
tabUser u
LEFT JOIN
(SELECT DISTINCT user, operation, status, communication_date
FROM tabActivity Log
WHERE operation = ‘Login’
AND status = ‘Success’
AND DATE(communication_date) = CURDATE()) al
ON
u.name = al.user
WHERE
u.enabled = 1
AND u.user_type != ‘Website User’
ORDER BY
u.name;

this gave me a report for all users which are logged in today for today timespan.

Now my issue is

  1. Users which haven’t logged out from system yesterday and still continuing from same login from yesterday , means they did’t have to log in again