Change stage history

Change stage history




SELECT chdt.changeid                       "Change ID", 
       chdt.title                          "Title", 
       orgaaa.first_name                   "Requested by", 
       ownaaa.first_name                   "Technician", 
       Longtodate(chdt.createdtime)        "Created Time", 
       Longtodate(chdt.scheduledstarttime) "Scheduled Start Time", 
       Longtodate(chdt.scheduledendtime)   "Scheduled End", 
       Longtodate(chdt.completedtime)      "Completed Time", 
       stagedef.NAME                       "Change Status", 
       aau1.first_name                     "Changed By", 
       Longtodate(cdh.operationtime)       "Changed On", 
       stdp.NAME                           "Changed From", 
       stdc.NAME                           "Changed To" FROM   changedetails chdt 
       LEFT JOIN sduser orgsd 
              ON chdt.initiatorid = orgsd.userid 
       LEFT JOIN aaauser orgaaa 
              ON orgsd.userid = orgaaa.user_id 
       LEFT JOIN sduser ownsd 
              ON chdt.technicianid = ownsd.userid 
       LEFT JOIN aaauser ownaaa 
              ON ownsd.userid = ownaaa.user_id 
       LEFT JOIN change_stagedefinition stagedef 
              ON chdt.stageid = stagedef.wfstageid 
       LEFT JOIN changehistory cdh 
              ON chdt.changeid = cdh.changeid 
       LEFT JOIN changehistorydiff cdhd 
              ON cdh.historyid = cdhd.historyid 
       LEFT JOIN aaauser aau1 
              ON aau1.user_id = cdh.operationownerid 
       LEFT JOIN change_stagedefinition stdp 
              ON Cast(cdhd.prev_value AS VARCHAR) = Cast( 
                 stdp.wfstageid AS VARCHAR) 
       LEFT JOIN change_stagedefinition stdc 
              ON Cast(Cast(cdhd.current_value AS VARCHAR) AS 
                 INT) = stdc.wfstageid 
WHERE  cdhd.columnname IN ( 'WFSTAGEID' ) 
ORDER  BY 1 


                  New to ADSelfService Plus?

                    • Related Articles

                    • Change Status history

                      SELECT chdt.changeid                       "Change ID",         chdt.title                          "Title",         orgaaa.first_name                   "Requested by",         ownaaa.first_name                   "Technician",  ...
                    • 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 ...
                    • Remove change stage comment box and rename actions buttons

                      Is it possible to remove the comment boxes that appear when moving to the next stage? Yes, navigate to Admin->Change Template->Edit the necessary template->Field Status comments->Disable Mandatory option. Is it possible to rename the action buttons ...
                    • Change Auto closure

                      This will be helpful in auto closing change request after X days it is in review stage. This use case is more suitable in environments where ONLY Requesters (customers) are the Change Reviewers and they want the Change to be closed if no review is ...
                    • Change roles

                      SELECT chdt.changeid               "Change ID",         chdt.title                  "Title",         orgaaa.first_name           "Change Requester",         ownaaa.first_name           "Change Owner",  ...