Changes
Query to get all the requests associated to a change
Build (14200 and above): Postgres Query: select chd.ChangeID "Change ID", chd.title "Change name", wo.workorderid "Request ID", wo.title "Request Subject" from incidentcausedbychange incach left join ChangeDetails chd on incach.changeid = ...
Query to show change planning details with total worklog hours
MSSQL: SELECT cdt.changeid "Change ID", cr.rolloutplan "Roll Out Plan", cr.backoutplan "Back Out Plan", cr.checklist "Check List", ...
Query to show Detailed Report of Change requests Within an Account
Compatible with both POSTGRES and MS-SQL: SELECT chdt.CHANGEID "Change ID",chdt.TITLE "Title", longtodate(chdt.CREATEDTIME) "Created Time", longtodate(chdt.SCHEDULEDSTARTTIME)"Scheduled Start Time",longtodate(chdt.SCHEDULEDENDTIME) "Scheduled ...
Query to show an additional column action pending by in change request
MSSQL: SELECT "chdt"."CHANGEID" AS "Change ID", "chdt"."TITLE" AS "Title", LONGTODATE(chdt.CREATEDTIME) AS "Created Time", "ownaaa"."FIRST_NAME" AS "ChangeOwner", STUFF((SELECT ', '+ au.first_name + char(10) FROM changeroleusermapping crum left ...
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 ...
Query to show last notes added in change request.
Change Request: SELECT ad.ORG_NAME AS "Account", chdt.CHANGEID AS "Change ID", chdt.CREATEDTIME AS "Created Time", ownaaa.FIRST_NAME AS "Change Owner", priodef1.PRIORITYNAME AS "Priority", chdt.TITLE AS "Title", orgaaa.FIRST_NAME AS "Change ...
Query- Incidents caused by Change Request
SELECT chdt.CHANGEID "Change ID",chdt.TITLE "Change Title",longtodate(chdt.CREATEDTIME) "Change Created Time",longtodate(chdt.COMPLETEDTIME) "Change Completed Time",orgaaa.FIRST_NAME "Change Requested by",ownaaa.FIRST_NAME "Change ...
Query- Change Requests that were caused by Incidents
SELECT chdt.CHANGEID "Change ID",chdt.TITLE "Change Title",longtodate(chdt.CREATEDTIME) "Change Created Time",longtodate(chdt.COMPLETEDTIME) "Change Completed Time",orgaaa.FIRST_NAME "Change Requested by",ownaaa.FIRST_NAME "Change ...
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 ...
Query_ Changes approved by(approvals tab) and request ID associated to it.
These are in reference to change initiated due to Requests and who approved the change approval stage alone. MSSQL: SELECT "chdt"."CHANGEID" AS "Change ID", "chdt"."TITLE" AS "Title", LONGTODATE("chdt"."CREATEDTIME") AS "Created Time", ...