Change Implementation Query Report

Purpose

This report extracts Change, Task, and Worklog details specifically for changes in the Implementation stage.

It provides a consolidated view to track:

1. Change progress
2. Task execution
3. Ownership and priorities
4. Worklog activity
   

The report includes the following columns:

1. Change ID
2. Change Title
3. Task Title
4. Task Status
5. Priority
6. Task Owner
7. Scheduled Start Time
8. Scheduled End Time
9. Percentage of Completion
10. Task Order
11. Worklog description
12. Worklog start time
13. Worklog end time
    

Database: PostgreSQL

​

Please find the query below: 

1. SELECT chdt.changeid "Change ID",
2.  chdt.title "Change Title", 
3. td.title "Task Title", 
4. sd.statusname "Task Status", 
5. pd.priorityname "Priority", 
6. own.first_name "Task Owner", 
7. longtodate(td.SCHEDULEDSTARTTIME) "Scheduled Start Time", 
8. longtodate(td.SCHEDULEDENDTIME) "Scheduled End Time", 
9. td.PER_OF_COMPLETION "Percentage of Completion", 
10. td.taskindex "Task Order",
11. chargeTable.description as "Worklog description",
12. chargeTable.ts_starttime as "Worklog start time",
13. chargeTable.ts_endtime as "Worklog end time" FROM changedetails chdt 
14. LEFT JOIN changetotaskdetails chgtotd ON chdt.changeid = chgtotd.changeid 
15. LEFT JOIN taskdetails td ON chgtotd.taskid = td.taskid 
16. LEFT JOIN statusdefinition sd on td.statusid = sd.statusid 
17. LEFT JOIN prioritydefinition pd on pd.PRIORITYID = td.PRIORITYID 
18. LEFT JOIN aaauser own on td.ownerid = own.user_id 
19. LEFT JOIN ChangeToCharge changeCharge ON chdt.CHANGEID=changeCharge.CHANGEID 
20. LEFT JOIN ChargesTable chargeTable ON changeCharge.CHARGEID=chargeTable.CHARGEID left join change_Stagedefinition chg_Stg on chg_Stg.wfstageid = chdt.wfstageid where chg_Stg.name like '%Implementation%'
21. order by chdt.changeid
22. 
    

• Related Articles

• Project Details (Milestone and Task Tracking) Query Report

  Purpose This report extracts project-level details to provide a comprehensive overview of project performance and tracking. It helps monitor: Project progress Schedule adherence Cost performance Effort estimation vs actuals The report includes the ...

• List of Services Template Report

  Tthe below Query to list all service catalog in the system Database : PostgreSQL Server - Version: 10.5 SELECT serd.Name "Service Category", reqtl.templatename "Service catalog", sla.slaname "SLA" , sdo.name "Site", array_to_string(array_agg(CASE ...

• Error while saving the email server details : Duplicate entry for key

  This Problem may happen when the application is holding to different mail server details. 1- So go to Reports > New query report and execute the following query : select * from IncomingMailServer 2- If you see multiple mail server configured in this, ...

• Change Postgres Password

  Problem :- Need to change the default password for postgres. Solution :- 1- connect to the database. 2- execute the below steps. servicedesk=# \password Enter new password : Enter it again : 3- Once execute it, do the below. - Open ...

• Time Elapsed not avavilble on the Matrix report || Known issue at 15130 build || SD-136533

  Dear Team, Our client GCA is encountering an issue regarding the matrix reports, where the Time Elapsed column is not fetching and is not available as a selection when you try to create, so we referred to the support team, and after investigation, ...