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 ADSelfService Plus?

                    • Related Articles

                    • Query to show KPI report based on technician (PGSQL & MSSQL)

                      Working on Builds: 14500 Database: MSSQL, PGSQL This report is already available under Frequently asked reports under Reports->New Query Reports page. Below query can be used for date filter and filter by technicians name modifications. SELECT ...
                    • 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", ...
                    • Query to track technician activity on tickets (MSSQL & PGSQL)

                      Tested in build PGSQL (14300) and MSSQL (14306) Use case: This query will help you find what are all activities that the technicians have done on requests other than the assigned ones SELECT au.first_name "Technician" ,wo.WORKORDERID "Request ...
                    • Query report to extract Active Technician Login and IP Address (MSSQL & PGSQL)

                      Tested in builds PGSQL (14300) or MSSQL (14306) Go to Reports- New Query Report and execute this query. select DISTINCT ac.ACCOUNT_ID as "Login Account ID", au.FIRST_NAME as "Technician Name ( First Name )", count(acs.SESSION_ID) as "Number of ...
                    • Query to show Technician leave details (MSSQL & PGSQL)

                      Tested in build PGSQL (14300) and MSSQL (14306) select au.first_name "Technician", ltd.name "Leave type", longtodate(du.leavedate) "Leave date", ta.comments "Leave Comments" from techunavailability ta left join aaauser au on ...