Report on Technician Leaves with date filter

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')

                New to ADManager Plus?

                  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. ...