Changes
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 ...
Query to get all the requests associated to a change (MSSQL & PGSQL)
Tested in builds PGSQL (14300) or MSSQL (14306) 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 ...
Query to show change planning details with total worklog hours
Working on Build: 14500 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 (Not working )
Compatible with both POSTGRES and MS-SQL: Tested in build PGSQL (14300) and MSSQL (14306) SELECT chdt.CHANGEID "Change ID",chdt.TITLE "Title", longtodate(chdt.CREATEDTIME) "Created Time", longtodate(chdt.SCHEDULEDSTARTTIME)"Scheduled Start ...
Query to show an additional column action pending by in change request
Database: 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 ...
Change Submission and Planning stage details (PGSQL)
Tested in build PGSQL (14300) 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 ...
Query to show last notes added in change request. (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 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 ...
Query to list Incidents caused by Change Request (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 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 ...
Query to list the Change Requests that were caused by Incidents (MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) 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 ...