SQL Cookbook for ServiceDesk Plus - Chapter 2 - Request Process Management

SQL Cookbook for ServiceDesk Plus - Chapter 2 - Request Process Management

Requests based on SLA.





To make any changes to this query, refer to this  post .


SELECT wo.WORKORDERID AS "Request ID" , wo.TITLE AS "Subject" , aau.FIRST_NAME AS "Requester" , qd.QUEUENAME AS "Group" , cd.CATEGORYNAME AS "Category" , scd.NAME AS "Subcategory" , icd.NAME AS "Item" , ti.FIRST_NAME AS "Technician" , std.STATUSNAME AS "Request Status" , sla.slaname "SLA Name" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID = sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID = aau.USER_ID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID = woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID = qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID = wos.WORKORDERID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID = scd.SUBCATEGORYID LEFT JOIN ItemDefinition icd ON wos.ITEMID = icd.ITEMID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID = cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID = td.USERID LEFT JOIN AaaUser ti ON td.USERID = ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID = std.STATUSID LEFT JOIN sladefinition sla ON wo.slaid = sla.slaid WHERE (wo.ISPARENT = '1' )

              New to ADManager Plus?

                New to ADSelfService Plus?