How to create a report for change requests and related change tasks

[Rama Rao]

Hello,

I want to create a report for all the change requests and change tasks where configuration item is service management.

I have created a report on change_task table but we have some change requests has no change tasks. I need to show all the change requests with or without tasks in the report. Is that possible?

Can anyone please help me on this?

Thanks in advance,

[AndersBGS]

Hi @Rama Rao ,

You have stated " I need all change requests(new, asses,...etc)." - Why then not "just" create the report based on the change_request table? 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Jitendra Diwak1 · Accepted solution]

Hi @Rama Rao,

This can be achieved by using the Database View. here database view is used to combine two table into one and then you report on it. here I am attaching the snapshot as per your requirement.

To create the database view please navigate like type database view in navigator>System Definition>Database View

Please click on New and fill the name and save the form then in related list there is View Table and click on new button and Table name, Variable prefix and where clause and save them after saving both table there is button on database view then click on related links under Try it button then you will be able get all the change request with Ctask and where no task has created. After you need to report on this table u_change_request(it is name from database view field(Name). Please try this.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Thanks

Jitendra

[Tsura Andreeva]

I think you can use the Task table with filter similar to this

[Jitendra Diwak1]

Hi @Tsura Andreeva,

I appreciate this but here you can get the record only and you cannot get which CTASK is associate with which CHANGE. And if you run this database view then you can easily identify this and I think its not hard one to create the database view. OOB is good but somewhere we have to customize it.

Thanks

Jitendra

[ellencarpen]

Similar question. I manage reports and dashboards (no admin roles), and I noticed one report hasn't been generating any data for the past few months.  The goal was to see open and closed Changed Tasks (2 reports) for last month, but they are pulling from the Change Task table which I believe might be the issue. The person that created the report used the following criteria:

ACTIVE is TRUE

ASSIGNED TO is (Name)

Can you assist?