Service catalog Resource Questions
This report helps to find the resource questions and values chosen in the request.
To make any changes to a query, refer to the KB article below.
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>
Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report.
New to ADSelfService Plus?
Related Articles
Create multiple Child Requests - Depending on a Resource Question(13002) - Deluge
This is same requirement as in https://pitstop.manageengine.com/portal/en/kb/articles/create-multiple-child-requests-depending-on-a-resource-question , but for SDP builds 13002 and above. With the latest update, the global functions and custom ...
Query to show service catalog template details (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) select sd.name "Service Name", rtl.templatename "Service Template Name", rtl.comments "Template description", rtf.description "Description field" from requesttemplate_list rtl LEFT JOIN ...
Query that shows Service catalog SLA (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) select slad.slaname "SLA NAME", sdo.name "SITE", slad.duebydays "Resolved within Days", slad.duebyhours "Resolved within Hours", slad.duebyminutes "Resolved within Mins", slad.fr_duebydays "Responded ...
Create an incident request in place of a service request depending on a resource question value.
Requirement: Create an incident request in place of a service request depending on a resource question value. Usecase: In many companies, same service template is used for both requesting for a "New Laptop" and "Replacement for the existing laptop", ...
Resource Section breakage after upgrading to 14505
There exists an issue where the resorouce section in Service Catalog requests gets aligned to the left as in the below screenshot and is not rendered properly. Breakage in build: 14505 Issue ID: SD-115268. Kindly add the below-quoted CSS code in the ...