Hi,

I have an SQL query (either taken from this forum of slight modification to the inbuilt queries, I'm not sure) to list all requests with as much information as I want except I can't find out how to add the Work Log to the report.

The query I use is :-

#####

SELECT wo.WORKORDERID 'Request ID',mdd.MODENAME 'Request Mode',qd.QUEUENAME 'Group',aau.FIRST_NAME 'Requester',dpt.DEPTNAME 'Department',cd.CATEGORYNAME 'Category',scd.NAME 'Sub Category',icd.NAME 'Item',wo.TITLE 'Subject',cri.FIRST_NAME 'Created By',wotodesc.FULLDESCRIPTION 'Description',rtdef.NAME 'Request Type',ti.FIRST_NAME 'Technician',pd.PRIORITYNAME 'Priority',lvd.LEVELNAME 'Level',sinfo.WORKSTATIONNAME 'Workstation',std.STATUSNAME 'Request Status',std.ISPENDING 'Pending Status',wo.CREATEDTIME 'Created Time',wo.RESPONDEDTIME 'Responded Date',wo.DUEBYTIME 'Dueby Time',wo.COMPLETEDTIME 'Completed Time',wo.TIMESPENTONREQ 'Time Spent',wos.ISOVERDUE 'Overdue Status',rrs.RESOLUTION 'Resolution',wof.UDF_CHAR3 'On-Call',wof.UDF_CHAR4 'Spare Issued?',wof.UDF_CHAR5 'Spare Asset details : -' FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN ModeDefinition mdd
ON wo.MODEID=mdd.MODEID 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 SDUser crd
ON wo.CREATEDBYID=crd.USERID LEFT JOIN AaaUser cri
ON crd.USERID=cri.USER_ID LEFT JOIN WorkOrderToDescription wotodesc
ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN SystemInfo sinfo
ON wo.WORKSTATIONID=sinfo.WORKSTATIONID LEFT JOIN WorkOrderStates wos
ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd
ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SubCategoryDefinition scd
ON wos.SUBCATEGORYID=scd.SUBCATEGORYID LEFT JOIN ItemDefinition icd
ON wos.ITEMID=icd.ITEMID LEFT JOIN SDUser td
ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti
ON td.USERID=ti.USER_ID LEFT JOIN RequestTypeDefinition rtdef
ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID LEFT JOIN PriorityDefinition pd
ON wos.PRIORITYID=pd.PRIORITYID LEFT JOIN LevelDefinition lvd
ON wos.LEVELID=lvd.LEVELID LEFT JOIN StatusDefinition std
ON wos.STATUSID=std.STATUSID LEFT JOIN WorkOrder_Queue woq
ON wo.WORKORDERID=woq.WORKORDERID LEFT JOIN QueueDefinition qd
ON woq.QUEUEID=qd.QUEUEID LEFT JOIN RequestResolver rrr
ON wo.WORKORDERID=rrr.REQUESTID LEFT JOIN RequestResolution rrs
ON rrr.REQUESTID=rrs.REQUESTID LEFT JOIN WorkOrder_Fields wof
ON wo.WORKORDERID=wof.WORKORDERID
WHERE  wot.THD_WOID=wot.WORKORDERID

######

Please can someone tell me the extra couple of lines I need to add, to add the related worklog to the resultant report?
I would like it to appear in the table in as a column similar to how the resolution appears.

I've even looked on the SQL DB end for the info & for the life of me I can't even find which table the worklog info is stored in!!

Thanks for any help!
Carl