Technician Leave report

Technician Leave report

Query

select au.first_name "Technician", ltd.name "Leave type", longtodate(du.leavedate) "Leave date"  from techunavailability ta
left join aaauser au on au.user_id=ta.technicianid
left join leavetypedefinition ltd on ltd.leavetypeid=ta.leavetypeid
left join dateunavailability du on du.leaveid=ta.leaveid
where du.leavedate >= <from_thisquarter> and du.leavedate <= <to_thisquarter>
order by 1

Krishna Bharat

ServiceDesk Plus - MSP Support team.