Change approval

Change approval


SELECT chdt.CHANGEID AS "Change ID", 
chdt.TITLE AS "Title", 
orgaaa.FIRST_NAME AS "Change Requester",
qd.QUEUENAME AS "Group", 
ownaaa.FIRST_NAME AS "Change Owner",
catadef.CATEGORYNAME AS "Category", 
priodef1.PRIORITYNAME AS "Priority",
longtodate(chdt.CREATEDTIME) AS "Created Time",
longtodate(chdt.COMPLETEDTIME) AS "Completed Time",
stageDef.DISPLAYNAME AS "Stage", 
statusDef.STATUSDISPLAYNAME AS "Status", 
approvaldef.STATUSNAME AS "Approval Status", 
appr.FIRST_NAME as "Approver",
al.name as "Approval level name",
longtodate(ad.action_date) as "Approval action taken on" ,
ad.COMMENTS as "Approval Comments",
appr_status_defn.statusname as "Approval status" 
 from changedetails chdt LEFT JOIN AaaUser orgaaa ON chdt.INITIATORID=orgaaa.USER_ID LEFT JOIN AaaUser ownaaa ON chdt.TECHNICIANID=ownaaa.USER_ID 
 LEFT JOIN PriorityDefinition priodef1 ON chdt.PRIORITYID=priodef1.PRIORITYID 
 LEFT JOIN ApprovalStatusDefinition approvaldef ON chdt.APPR_STATUSID=approvaldef.STATUSID 
 LEFT JOIN CategoryDefinition catadef ON chdt.CATEGORYID=catadef.CATEGORYID 
 LEFT JOIN QueueDefinition qd ON chdt.GROUPID=qd.QUEUEID  
 LEFT JOIN Change_StageDefinition stageDef ON chdt.WFSTAGEID=stageDef.WFSTAGEID 
 LEFT JOIN Change_StatusDefinition statusDef ON chdt.WFSTATUSID=statusDef.WFSTATUSID  
 LEFT JOIN AaaUser cmDef ON chdt.CHANGEMANAGERID=cmDef.USER_ID 
 LEFT JOIN Change_ApprovalLevel cal ON cal.ENTITYID = chdt.CHANGEID LEFT JOIN ApprovalLevel al ON al.ID = cal.LEVELID LEFT JOIN ApprovalDetails ad ON ad.APPROVAL_LEVEL_ID = al.ID LEFT JOIN AaaUser appr ON appr.USER_ID = ad.APPROVERID LEFT JOIN approvalStatusDefinition appr_status_defn on appr_status_defn.statusid = ad.statusid 
order by 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 Approval Details

                      This report is used to view the historical details of Approved and Denied approval processes and their individual steps. We can also use this report to display all details for which an approval decision is pending. To make any changes to a query, ...

                    • Change details

                      SELECT    chdt.changeid "Change ID",            chdt.title "Title",            Longtodate(chdt.createdtime) "Created Time",            Longtodate(chdt.scheduledstarttime) "Scheduled Start Time",  ...

                    • How to change status once a request has been approved or rejected

                      Prerequisite - A python environment should be configured in the SDP-MSP Server. Instructions here.  - Under Admin>Self Service Portal>Do you wish to enable On Hold scheduler when your requests are put on hold?>Should be set to 'NO' Instructions ...

                    • Query to retrieve the Change Details

                      Tested in: 14504, 14610 QUERY: SELECT chdt.CHANGEID AS "Change ID", cmDef.FIRST_NAME AS "Change Manager", ownaaa.FIRST_NAME AS "Change Owner", approvaldef.STATUSNAME AS "Approval Status", qd.QUEUENAME AS "Group", statusDef.STATUSDISPLAYNAME AS ...

                    • Automating change stage transition based on task completion

                      PURPOSE: To automatically move to the next change stage when all tasks are closed, using task custom function and task custom trigger. The attached script triggers upon the closure of each task, verifying whether all tasks within the current stage ...

                      Related Products