Shared Request

Shared Request

This report is used to get the list of shared request. 


SELECT wo.WORKORDERID AS "Request ID",
       wo.TITLE AS "Subject",
       aau.FIRST_NAME AS "Requester",
       qd.QUEUENAME AS "Group",
       ti.FIRST_NAME AS "Technician",
       std.STATUSNAME AS "Request Status",
       sa.first_name "Shared to technician" 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 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 WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT JOIN WO_SHARE_LIST wsl ON wo.workorderid=wsl.workorderid
LEFT JOIN TECHNICIAN_SHARE_LIST tsl ON wsl.shareid=tsl.shareid
LEFT JOIN aaauser sa ON tsl.techid=sa.user_id
WHERE (wo.ISPARENT='1') and 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

                    • Query to show shared requests (MSSQL & PGSQL)

                      Tested in build PGSQL (14300) and MSSQL (14306) Shared to Tech: SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", LONGTODATE(wo.CREATEDTIME) AS "Created Time", ...
                    • Script to Auto share request

                      1. Download MSP_share_Request.zip from the attachment, extract it, and paste the same under ManageEngine\ServiceDesk Plus MSP\integrations\Custom_scripts.          # auto_share_MSP.py      # functions.py      # configuration.json 2. ...
                    • Shared Request - Group

                      SELECT wo.WORKORDERID AS "Request ID", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Requester", qd.QUEUENAME AS "Group", ti.FIRST_NAME AS "Technician", std.STATUSNAME AS "Request Status", qa.queuename "Shared to group" FROM WorkOrder wo LEFT JOIN SDUser ...
                    • How to Auto Share Request Upon Creation to All/Selected Technicians

                      NOTE:  This script is supported only for builds below 11.3 This post describes the use of a python script to share requests to technicians specified in a list variable in the script, which can be generated from an SQL query. This script can be ...
                    • How to auto share requests to groups specified in the request tasks.

                      This post described the use of a python script to share requests to groups specified in the tasks that are associated with a request.This script can be configured under Request custom triggers and you will find more information about this here. This ...