Shared Request - Group

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 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
INNER JOIN GROUP_SHARE_LIST gsl ON wsl.shareid=gsl.shareid
LEFT JOIN queuedefinition qa ON gsl.queueid=qa.queueid
WHERE (wo.ISPARENT='1')




          • Related Articles

          • Shared Request

            This report is used to get the list of shared request.  To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT wo.WORKORDERID AS "Request ...
          • Request violated by Group

            This report used to find the group who violated the request. If the request/incident already has a violation and is reassigned to another group the new group assumes the violation instead of the group that the violation occurred. To make any changes ...
          • Group change from history

            This report is used to find who changed the group To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 SELECT wo.WORKORDERID "Request ID", ...
          • Automatically close request after successive approval reminders.

            This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...
          • Asset group

            SELECT max(resgrp.GROUPNAME) AS "Group Name", MAX(resource.RESOURCENAME) AS "Asset Name", MAX(state.DISPLAYSTATE) AS "Asset State", MAX(rCategory.CATEGORY) AS "Asset Category", MAX(product.COMPONENTNAME) AS "Product", ...