Hello, I have a customer that us runing the following query:

select  qd.queuename as "Support Group", sdo.name as "Site",  au.FIRST_NAME as "Technician Name ( First Name )", LONGTODATE(acs.OPENTIME) as "Last Login Time", al.NAME as "Login Name" from queuedefinition as qd left join sdorganization as sdo on qd.siteid=sdo.org_id left join queue_technician as qt on qd.queueid=qt.queueid left join SDUser as sd on qt.TECHNICIANID=sd.USERID left join aaauser au on sd.userid=au.user_id left join AaaUserContactInfo auci on au.USER_ID=auci.USER_ID left join AaaContactInfo aci on auci.CONTACTINFO_ID = aci.CONTACTINFO_ID left join UserDepartment ud on sd.USERID = ud.USERID left join DepartmentDefinition dd on ud.DEPTID=dd.DEPTID inner join portalusers pu on sd.USERID=pu.USERID inner join portaltechnicians pt on pu.ID = pt.ID inner join aaalogin al on au.USER_ID = al.USER_ID inner join aaaaccount ac on al.LOGIN_ID = ac.LOGIN_ID left join aaaaccsession acs on ac.ACCOUNT_ID = acs.ACCOUNT_ID left join aaauser repuser on repuser.USER_ID = sd.REPORTINGTO where pu.STATUS = 'ACTIVE' and (acs.SESSION_ID is NULL or acs.SESSION_ID in ( select max(acss.SESSION_ID) from AaaAccSession acss group by acss.ACCOUNT_ID )) group by sdo.name, qd.queuename, au.first_name, acs.opentime, al.name order by sdo.name

And given there are technicians that in "Last Logon Date" appear as "not assigned" or "null" (See te attached image), they want to know how much time has passed since those technicians haven't logged in?

Thank you