Change Submission and Planning stage details

Change Submission and Planning stage details

PGSQL:

SELECT  cdt.changeid "Change Request ID", orgaaa.FIRST_NAME AS "Change Requester", ownaaa.FIRST_NAME AS "Change Owner", cmDef.FIRST_NAME AS "Change Manager", manager.name "Line Manager", implementer.name "Change Implementer", Reviewer.name "Change Reviewer", Approver.name "Change Approver", cr.rolloutplan "Roll Out Plan", 
          cr.backoutplan "Back Out Plan", 
          cr.impactdesc "Impact Descritpion", 
          cr.checklist "Check List", LONGTODATE(cdd.starttime) "Downtime Start", LONGTODATE(cdd.endtime) "Downtime End", Csc.comments "Status comments"  FROM ChangeDetails cdt   LEFT JOIN (SELECT role.changeid, array_to_string(array_agg(us.first_name),',') AS name FROM changeroleusermapping ROLE LEFT JOIN aaauser us ON ROLE.userid=us.user_id WHERE ROLE.roleid=8 GROUP BY ROLE.changeid)implementer ON cdt.changeid=implementer.changeid LEFT JOIN (SELECT role.changeid, array_to_string(array_agg(us.first_name),',') AS name FROM changeroleusermapping ROLE LEFT JOIN aaauser us ON ROLE.userid=us.user_id WHERE ROLE.roleid=9 GROUP BY ROLE.changeid)Reviewer ON cdt.changeid=reviewer.changeid LEFT JOIN (SELECT role.changeid, array_to_string(array_agg(us.first_name),',') AS name FROM changeroleusermapping ROLE LEFT JOIN aaauser us ON ROLE.userid=us.user_id WHERE ROLE.roleid=5 GROUP BY ROLE.changeid)Approver ON cdt.changeid=Approver.changeid LEFT JOIN (SELECT role.changeid, array_to_string(array_agg(us.first_name),',') AS name FROM changeroleusermapping ROLE LEFT JOIN aaauser us ON ROLE.userid=us.user_id WHERE ROLE.roleid=7 GROUP BY ROLE.changeid)manager ON cdt.changeid=manager.changeid LEFT JOIN SDUser orgsd ON cdt.INITIATORID=orgsd.USERID LEFT JOIN AaaUser orgaaa ON orgsd.USERID=orgaaa.USER_ID LEFT JOIN SDUser ownsd ON cdt.TECHNICIANID=ownsd.USERID LEFT JOIN AaaUser ownaaa ON ownsd.USERID=ownaaa.USER_ID LEFT JOIN AaaUser cmDef ON cdt.CHANGEMANAGERID=cmDef.USER_ID LEFT JOIN changeresolution cr ON  cdt.changeid=cr.changeid LEFT JOIN Changestatuscomments csc ON cdt.changeid=csc.changeid LEFT JOIN change_downtimedetails cdd ON cdt.changeid=cdd.changeid ORDER BY 1
          • Related Articles

          • Query to show Change Roles in change requests

            MSSQL: SELECT "chdt"."CHANGEID" AS "Change ID", "chdt"."TITLE" AS "Title", LONGTODATE("chdt"."CREATEDTIME") AS "Created Time", LONGTODATE("chdt"."SCHEDULEDSTARTTIME") AS "Scheduled Start Time", LONGTODATE("chdt"."SCHEDULEDENDTIME") AS "Scheduled ...
          • 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 ...
          • Query to find status change, its time and comments.

            Execute this query under Reports->New Query Report. Date filter is highlighted, you can modify it as per the need. PGSQL: SELECT wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", std.STATUSNAME "Request Status", wo.TITLE "Subject", ...
          • Query to show both task comments and worklog comments

            MSSQL: SELECT "taskdet"."TASKID" AS "Task ID", "taskdet"."TASKID" AS "Task ID", "wotask"."WORKORDERID" AS "RequestID", cd.CATEGORYNAME AS "Request Category",  "taskgroup"."QUEUENAME" AS "Group", "taskowner"."FIRST_NAME" AS "Owner", "taskdet"."TITLE" ...
          • 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 ...