Need help with SQL Query

Need help with SQL Query

Looking to add a custom service request field to a report:

 

Currently here is my query

SELECT serdef.NAME "Service Category",serdef.NAME "Service Category",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wotodesc.FULLDESCRIPTION "Description",appStDef.STATUSNAME "Approval Status",wo.TITLE "Subject" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN ServiceDefinition serdef ON wo.SERVICEID=serdef.SERVICEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN ApprovalStatusDefinition appStDef ON wos.APPR_STATUSID=appStDef.STATUSID WHERE  ((serdef.NAME = 'Security Request') AND (((wo.CREATEDTIME >= datetolong('1265004000000') AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= datetolong('1360735199000') AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))))  AND wo.ISPARENT=1 AND wo.IS_CATALOG_TEMPLATE=1  ORDER BY 1

 

I would like to add an Employee Name field:

19 ServiceReq_User UDF_CHAR1 Employee Name           Text Field 1         Single Line

 

Any help would be appreciated.

                  New to ADSelfService Plus?