Report on Technician Leaves with date filter
DB Compatibility : PGSQL & MSSQL
Build Compatibility : Builds above 10000
SELECT cre.FIRST_NAME "Created By",
LONGTODATE(TechUnavailability.CREATEDDATE) "Created Date",
avail.FIRST_NAME "Technician on Leave",
back.FIRST_NAME "Backup Technician",
LONGTODATE(DateUnAvailability.LEAVEDATE) "Leave Date",
LeaveTypeDefinition.NAME "Leave Type",
TechUnavailability.COMMENTS "Comments" FROM TechUnavailability
LEFT JOIN DateUnAvailability ON TechUnavailability.LEAVEID=DateUnAvailability.LEAVEID
LEFT JOIN LeaveTypeDefinition ON TechUnavailability.LEAVETYPEID=LeaveTypeDefinition.LEAVETYPEID
LEFT JOIN AaaUser cre ON TechUnavailability.CREATEDBY=cre.USER_ID
LEFT JOIN AaaUser avail ON TechUnavailability.TECHNICIANID=avail.USER_ID
LEFT JOIN AaaUser back ON TechUnavailability.Backuptechnicianid=back.USER_ID
WHERE
DateUnAvailability.LEAVEDATE >= DATETOLONG('2021-01-01 00:00:00') AND
DateUnAvailability.LEAVEDATE <=DATETOLONG('2021-06-31 00:00:00')
LONGTODATE(TechUnavailability.CREATEDDATE) "Created Date",
avail.FIRST_NAME "Technician on Leave",
back.FIRST_NAME "Backup Technician",
LONGTODATE(DateUnAvailability.LEAVEDATE) "Leave Date",
LeaveTypeDefinition.NAME "Leave Type",
TechUnavailability.COMMENTS "Comments" FROM TechUnavailability
LEFT JOIN DateUnAvailability ON TechUnavailability.LEAVEID=DateUnAvailability.LEAVEID
LEFT JOIN LeaveTypeDefinition ON TechUnavailability.LEAVETYPEID=LeaveTypeDefinition.LEAVETYPEID
LEFT JOIN AaaUser cre ON TechUnavailability.CREATEDBY=cre.USER_ID
LEFT JOIN AaaUser avail ON TechUnavailability.TECHNICIANID=avail.USER_ID
LEFT JOIN AaaUser back ON TechUnavailability.Backuptechnicianid=back.USER_ID
WHERE
DateUnAvailability.LEAVEDATE >= DATETOLONG('2021-01-01 00:00:00') AND
DateUnAvailability.LEAVEDATE <=DATETOLONG('2021-06-31 00:00:00')
New to ADSelfService Plus?
Related Articles
Technician
This report is used to find the Technician complete details. SELECT AaaUser.USER_ID, AaaUser.FIRST_NAME "FullName", AaaLogin.NAME "LoginName", AaaLogin.DOMAINNAME "Domain", AaaContactInfo.EMAILID "Email", DepartmentDefinition.DEPTNAME "Department", ...4. Date Filter
Custom Date Filter Format: PGSQL createdtime >= CAST(EXTRACT(EPOCH FROM TIMESTAMP '2019-01-01 00:00:00') * 1000 AS BIGINT) AND createdtime <= CAST(EXTRACT(EPOCH FROM TIMESTAMP '2019-01-30 00:00:00') * 1000 AS BIGINT) SELECT wo.WORKORDERID AS ...Technician group
This report is used to get the associated groups of the technicians. SELECT AaaUser.FIRST_NAME "FullName", (SDOrganization.NAME) "Site", (qd.queuename) "Group" FROM AaaUser LEFT JOIN UserDepartment ON AaaUser.USER_ID=UserDepartment.USERID LEFT JOIN ...Request violated by technician
This report used to find the technician who violated the request. If the request/incident already has a violation and is reassigned to another technician the new technician assumes the violation instead of the technician that the violation occurred. ...Technician change from history
This report is used to find who changed the Technician and how many technician handled the request. To make any changes to a query, refer to the KB article below. ...