Request Management - service template resource questions

Service templates resource questions. This report helps to find the resource questions and values chosen in the request.

SELECT WO_Resources.WOID "RequestID",
       CatalogResource.TITLE "Resource Question",
       Questions.QUESTION "Question",
       ResourcesQAMapping.ANSWER "Answer" FROM WO_Resources
LEFT JOIN ResourcesQAMapping ON WO_Resources.UID=ResourcesQAMapping.MAPPINGID
LEFT JOIN CatalogResource ON wo_resources.RESOURCEID=CatalogResource.UID
LEFT JOIN Questions ON Questions.QUESTIONID=ResourcesQAMapping.QUESTIONID
LEFT JOIN RequestTemplate_List ON CatalogResource.SERVICEID=RequestTemplate_List.TEMPLATEID
LEFT JOIN Workorder wo ON WO_Resources.WOID=wo.WORKORDERID WHERE wo.CREATEDTIME >= <from_thisweek> and wo.CREATEDTIME <= <to_thisweek>

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

Click this link to navigate to the next report.

Sticky Posts
Configuration Management - view/export the list of preventive maintenance tasks with their next scheduled time
This report helps to view/export the list of preventive maintenance tasks with their next scheduled time configured in the application. SELECT swo.WORKORDERID "Scheduled WOID", ti.SCHEDULE_TIME "Next Schedule Time", aau.FIRST_NAME "Requester", sdo.NAME "Site", dpt.DEPTNAME "Department", cd.CATEGORYNAME "Category", scd.NAME "Subcategory", icd.NAME "Item", qd.QUEUENAME "Group", ati.FIRST_NAME "Technician", swo.TITLE "Subject",
Request Management - number of requests submitted per hour
Count of request inflow per hour - provides an insight on monthly opened incidents per hour. It provides you a quick determination on timeframe that received a large number of incidents. This information can then be used by an incident management administrator to determine if a particular department requires additional resources to efficiently manage the number of incidents. PGSQL: SELECT EXTRACT(YEAR FROM (to_timestamp(wo.createdtime/1000)::TIMESTAMP)) "created time", CASE WHEN EXTRACT(MONTH FROM
Request Management - service template resource questions
Service templates resource questions. This report helps to find the resource questions and values chosen in the request. SELECT WO_Resources.WOID "RequestID", CatalogResource.TITLE "Resource Question", Questions.QUESTION "Question", ResourcesQAMapping.ANSWER "Answer" FROM WO_Resources LEFT JOIN ResourcesQAMapping ON WO_Resources.UID=ResourcesQAMapping.MAPPINGID LEFT JOIN CatalogResource ON wo_resources.RESOURCEID=CatalogResource.UID LEFT JOIN Questions ON Questions.QUESTIONID=ResourcesQAMapping.QUESTIONID LEFT
SQL Cookbook for ServiceDesk Plus - Chapter 1 - SQL basics
SQL Basics: SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", ti.FIRST_NAME AS "Technician", cd.CATEGORYNAME AS "Category", std.STATUSNAME AS "Request Status" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID=cd.CATEGORYID LEFT JOIN SDUser td
Request Management - overview of all conversations of technician and requester in a request
This report gives an overview of all conversations of technician and requester in a request. SELECT wo.WORKORDERID "Request ID", (aau.FIRST_NAME) "Requester", (wo.TITLE) "Subject", (ti.FIRST_NAME) "Technician", longtodate(wo.CREATEDTIME) "Created Time", longtodate(c.createdtime)"Conversation CreatedOn", c.title "Conversation title", longtodate(n.notificationdate)"Technician reply CreatedOn", c.first_name "conversation by", c.description "conversation Description", n.notificationtitle "NOtification