I am looking at creating a report that my technicians can run at the end of their shift that will show the following data:
-department
-category
-subject
-priority
-impact
-Technician
-Description
-Request Status
I have tried different variations of the custom reports and can only find a way to filter by technician and create a report for each individual tech, I would like to know if there is a native report for this or a way to get one that I can get created in order to have them run it at the end of their shift? Or to schedule it to automatically deliver at the different times.
This Is also the Query For the Report I have created for the Prior Day,I wish to have it setup for our different Shifts as we Run24/7:
SELECT ti.FIRST_NAME "Technician",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",dpt.DEPTNAME "Department",wo.TITLE "Subject",impdef.NAME "Impact",ti.FIRST_NAME "Technician",pd.PRIORITYNAME "Priority",std.STATUSNAME "Request Status",rrs.RESOLUTION "Resolution" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID LEFT JOIN ImpactDefinition impdef ON wos.IMPACTID=impdef.IMPACTID LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID LEFT JOIN RequestResolver rrr ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs ON rrr.REQUESTID=rrs.REQUESTID WHERE (((wo.CREATEDTIME >= 1420444800000) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= 1420531199000) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))) AND wo.ISPARENT='1' AND wo.IS_CATALOG_TEMPLATE='0' ORDER BY 1, 4