Request Dependency

Request Dependency



SELECT wo.WORKORDERID "Request ID",
       wo.TITLE "Subject",
       ti.FIRST_NAME "Technician",
       pd.PRIORITYNAME "Priority",
       wo.CREATEDTIME "Created Time",
       wo.DUEBYTIME "DueBy Time",
       std.STATUSNAME "Request Status",
       CASE
           WHEN wos.ISOVERDUE='1' THEN 'Yes'
           ELSE 'No'
       END "Overdue Status",
       wodm.Dependsonid "Depends on" FROM WorkOrder wo
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 PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
INNER JOIN WODependency wod ON wo.workorderid=wod.workorderid
INNER JOIN WODependencyMarking wodm ON wod.Reqdependencyid=wodm.Reqdependencyid
WHERE (wo.ISPARENT='1')


      New to M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • Related Articles

                    • Request recipient email

                      This report is used to find the recipient email address.  Some requests are forward to others through the mail, this report helps to find the statistics how many requests are forward to others using the email address filter.  To make any changes to a ...

                    • Mark Request as Non-Billable

                      You can make use of Business Rules to set the Criteria as "Request Type is" (or any Criteria as per yours) and under Actions set "Mark Request as Non-Billable". So once the Request is marked as Non-Billable, the worklog added under that request will ...

                    • Request missing

                      Use case: In some cases, requests are missing. We would get the ID number from acknowledgement notification but we cannot find that in the tickets. In such cases, please follow below steps to find out the details. 1. Make sure to check the Request ...

                    • Service request approvers

                       This report helps to find the who all the service request approvers in the application.  SELECT aaauser.first_name "Approver Name", dpt.deptname "Department", sdo.name "Site", sd.jobtitle "Job Title" FROM srapproverdetails LEFT JOIN aaauser ON ...

                    • 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 ...

                      Related Products