Task report that shows tasks with related change requests

[david_wilhelm]

Good morning all,

We have to create a change request for each task that may need a change request. These changes need to go through a CAB to decide if the work will be done for the change/task.

My issue is I have my lists of tasks but have no easy way to see a list of tasks that have no related change requests. I don't want to have to go search through each change request I have and check the related tasks list to verify the task has a change request.

Is there a way to create a report or list that will show the task details as well as any change requests related to any of the tasks?

Thanks

[Rama Chandra D]

The database view seems to me, the best option. I remember doing this sort of thing, with Problem and Problem task table. I created a database view to include Problems with no tasks.

Darshak

[shrija10]

Hi ,

Even I have the same issue. Can you please tell me how did you include both Problems which have problem tasks in Related Items and Problems which doesn't have problem tasks in Related Items . Because if we are creating a database view(task_rel_task & problem table) and use it for running a report it shows only Problems which has problem task in related items.

Thanks in advance!

[pagdenl]

Hello,

I have the opposite problem, I would like to find tasks that do not have a change request associated with it.   We are trying to find out who is not creating a change request from a catalog task or incident, etc..   Would we have to create a database view to pull in the data?