Report for Technician Login / Logout time for a specific period.
DB : MySQL / MsSQL
Tested Build : 8116
Description :
The report will give the Login / Logout details for the technicians for the specified time range.
Report:
SELECT PRINCIPAL 'Technician Name', LongToDate(TIMESTAMP) 'Time', OPERATIONNAME 'Login / Logout' FROM AUDITRECORD LEFT JOIN OPERATIONAUDITRECORD ON OPERATIOnAUDITRECORd.AUDITID = AUDITRECORD.AUDITID INNER JOIN AAAACCSESSIONAUDIT ON AAAACCSESSIONAUDIT.AUDITID = AUDITRECORD.AUDITID INNER JOIN AAAAccSESSION ON AAAACCSESSION.SESSION_ID = AAAACCSESSIONAUDIT.SESSION_ID INNER JOIN AAAACCOUNT ON AAAACCOUNT.ACCOUNT_ID = AAAACCSESSION.ACCOUNT_ID INNER JOIN AAALOGIN ON AAALOGIN.LOGIN_ID = AAAACCOUNT.LOGIN_ID INNER JOIN AAAUSER ON AAAUSER.USER_ID = AAALOGIN.USER_ID INNER JOIN HELPDESKCREW ON HELPDESKCREW.TECHNICIANID = AAAUSER.USER_ID WHERE TIMESTAMP > <from_thisweek> and TIMESTAMP < <to_thisweek>
The range can be changed as per the requirement by making use of the below range values
Tested Build : 8116
Description :
The report will give the Login / Logout details for the technicians for the specified time range.
Report:
SELECT PRINCIPAL 'Technician Name', LongToDate(TIMESTAMP) 'Time', OPERATIONNAME 'Login / Logout' FROM AUDITRECORD LEFT JOIN OPERATIONAUDITRECORD ON OPERATIOnAUDITRECORd.AUDITID = AUDITRECORD.AUDITID INNER JOIN AAAACCSESSIONAUDIT ON AAAACCSESSIONAUDIT.AUDITID = AUDITRECORD.AUDITID INNER JOIN AAAAccSESSION ON AAAACCSESSION.SESSION_ID = AAAACCSESSIONAUDIT.SESSION_ID INNER JOIN AAAACCOUNT ON AAAACCOUNT.ACCOUNT_ID = AAAACCSESSION.ACCOUNT_ID INNER JOIN AAALOGIN ON AAALOGIN.LOGIN_ID = AAAACCOUNT.LOGIN_ID INNER JOIN AAAUSER ON AAAUSER.USER_ID = AAALOGIN.USER_ID INNER JOIN HELPDESKCREW ON HELPDESKCREW.TECHNICIANID = AAAUSER.USER_ID WHERE TIMESTAMP > <from_thisweek> and TIMESTAMP < <to_thisweek>
The range can be changed as per the requirement by making use of the below range values
- Today - <from_today> - <to_today>
- This week - <from_thisweek> - <to_thisweek>
- Last week - <from_lastweek> - <to_lastweek>
- This month - <from_thismonth> - <to_thismonth>
- Last month - <from_lastmonth> - <to_lastmonth>
- This quarter - <from_thisquarter> - <to_thisquarter>
- Last quarter - <from_lastquarter> - <to_lastquarter>
- Yesterday - <from_yesterday> - <to_yesterday>