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 ...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 ...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", ...Create multiple Child Requests - Depending on a Resource Question - Deluge
This is custom function script to automatically trigger the creation of multiple child requests from a parent request based on parent resource question values. The request ID of the child requests will be added as a Note in the parent request. This ...Software deployment in UEM when Service Request is approved
Use case: To initiate the software request from Service Catalog, approve the request and initiate the software deployment using the EC agent. Prerequisites: 1. To include required packages within a specific template, follow these steps: Begin by ...