Request with ServiceCatalog Additional fields
Service catalog additional fields are category specific fields. These fields are stored in a dynamic table, so we need to join the specific template to get the resultant.
To make any changes to a query, refer to the KB article below.
Run the below query to get the additional field name you need in the report.
SELECT * FROM columnaliases
You can find the column name and the table name from the above query and replace it in the below query.
SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", qd.QUEUENAME AS "Group", aau.FIRST_NAME AS "Requester", ti.FIRST_NAME AS "Technician", std.STATUSNAME AS "Request Status", sereq.UDF_CHAR1 "Location", sereq.UDF_CHAR2 "Floor", sereq.UDF_CHAR3 "City" 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 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 ServiceReq_301 sereq ON wo.workorderid=sereq.workorderid WHERE (wo.ISPARENT='1')
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
How to populate requester details in request additional field
Requirement: Populate requester additional field information into request additional field. Usecase: Let us consider a scenario where certain employee details are imported from the Active Directory into User - Additional Fields. The business ...How to populate user names in a request additional field
This sample script is to populate both technician and requester names in a request additional field Use Case: Populate all user name in a request additional field. Execution Steps: 1. Create a new 'Single Line' additional field and add them in the ...Additional field values
This report helps to find the picklist values in the additional fields. First you need to find the name of the table and the column holding the data, by executing the following SDP query report: SELECT Tablename, Columnname FROM ColumnAliases WHERE ...How to update Request Additional fields during request create/update using Custom Triggers (V3)
This is a sample python script to update the Request Additional Field Values during request create/update based on certain criteria using Custom Trigger Execution Steps: 1. Download the attached zip 2. Move the files to ...How to update Request Additional fields during request create/update using Business Rules
This is a sample python script to update the Request Additional Field Values during request create/update based on certain criteria using Business Rules Execution Steps: 1. Download the attached zip 2. Move the files to ...