Request with ServiceCatalog Additional fields

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. 


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 ...
                      • Update request additional field with Custom Request ID

                        Requirement: Each Organization's request ID format may differ. In the current model, replacing the existing request id with these is not possible; however, the same can be replaced in an additional field. Custom Format : Script 1: 202305221125001 ...