We use this query to show all worklogs for all requests and projects.   It is grouped by technician can you update it to allow me to run it for only one technician?  Thank you.

SELECT COALESCE(wtk.WORKORDERID , wo.workorderid) "Module ID", 'Request' "Module",

CASE WHEN (tk.TASKID) IS NOT NULL THEN (wo2.TITLE) ELSE (wo.TITLE) END "Title",

(wof.UDF_CHAR2) "Ticket Type",

(pd.PRIORITYNAME) "Priority",

(wof.UDF_CHAR8) "Site",

(qd.QUEUENAME) "Group",

(scd.NAME) "Subcategory" ,

CAST((ct.TIMESPENT) AS FLOAT)/1000/3600 "Time Spent",

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ((ct.TS_ENDTIME)/1000),'1970-01-01 00:00:00') "Time Spent End time",

rctd.FIRST_NAME "Time Spent Technician" FROM ChargesTable ct

LEFT JOIN WorkOrderToCharge wotoc ON ct.CHARGEID=wotoc.CHARGEID

LEFT JOIN WorkOrder wo ON wotoc.WORKORDERID=wo.WORKORDERID

LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID

LEFT JOIN TaskDetails tk ON tkc.TASKID=tk.TASKID

LEFT JOIN WorkorderToTaskDetails wtk ON tk.TASKID=wtk.TASKID

LEFT JOIN Workorder wo2 ON wtk.WORKORDERID=wo2.WORKORDERID

LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID

LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID

LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID

LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID

LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID

WHERE (wtk.WORKORDERID IS NOT NULL OR wo.workorderid IS NOT NULL) AND

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (ct.TS_ENDTIME/1000),'1970-01-01 00:00:00') >= convert(varchar,'2015-12-01 00:00',21) and

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (ct.TS_ENDTIME/1000),'1970-01-01 00:00:00') <= convert(varchar,'2016-12-31 23:59',21)

UNION

SELECT tpr.PROJECTID "Module ID",'Project' "Module" , (pr.TITLE) "Title",

(projecttypedef.PROJECTTYPENAME) "Project Type",

(projectprior.PRIORITYNAME) "Priority",

(projectsitename.NAME) "Site" ,

'',

'',

CAST((ct.TIMESPENT) AS FLOAT)/1000/3600 "Time Spent",

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + ((ct.TS_ENDTIME)/1000),'1970-01-01 00:00:00') "Time Spent End time",

rctd.FIRST_NAME "Time Spent Technician" FROM ChargesTable ct

LEFT JOIN TaskToCharge tkc ON ct.CHARGEID=tkc.CHARGEID

LEFT JOIN  TaskDetails tk ON tkc.TASKID=tk.TASKID

LEFT JOIN TaskTOProjects tpr ON tk.taskid=tpr.taskid

LEFT JOIN ProjectDetails pr ON tpr.PROJECTID=pr.PROJECTID

 LEFT JOIN PriorityDefinition projectprior ON pr.PRIORITYID=projectprior.PRIORITYID

LEFT JOIN SiteDefinition projectsite ON pr.SITEID=projectsite.SITEID LEFT JOIN SDOrganization projectsitename ON projectsite.SITEID=projectsitename.ORG_ID

LEFT JOIN ProjectTypeDefinition projecttypedef ON pr.PROJECTTYPEID=projecttypedef.PROJECTTYPEID

LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID WHERE tk.MODULE IN ('project', 'milestone') AND dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (ct.TS_ENDTIME/1000),'1970-01-01 00:00:00') >= convert(varchar,'2015-12-01 00:00',21) and

dateadd(s,datediff(s,GETUTCDATE() ,getdate()) + (ct.TS_ENDTIME/1000),'1970-01-01 00:00:00') <= convert(varchar,'2016-12-31 23:59',21) order by 11