how can we find incident numbers assigned to a change request number?

[himangi1]

I need to make a report which contains all the incidents assigned to that change request.

What filters and which table i need to select in order to find that,please suggest me as i am not finding the number of incidents?

[nitin_kumar]

Hi,

You can create the required report by

1. Navigate to Reports

2. Click 'Create New'

3. Replicate the image.

4. Save and Click Run.

Thanks,

Nitin.

PS: Hit like, Helpful or Correct depending on the impact of the response

[sumeet_n]

Select the change number in highlighted field for which you want to find all the related incidents.

[nitin_kumar]

1. If you select 'Change Request' in the group by field without any filter conditions, the report will show you the Incidents numbers grouped by the Change Request for all the Change Requests. You can add the filter condition as Change Request is not empty as you don't need the incidents without a change request.

Example:

2. If select the 'Group By' as empty and use the filter conditions, select the change request number for which you have to find the Incidents, the report will show you the Incidents numbers grouped by the selected Change Request

Example :

[himangi1]

Hi Nitin,

Thanks for the reply but actually i am not getting the result by putting these filters also.

I have a change request no. , assignment group,and the duration for which i need to calculate the number of incidents are logged.

Is there any other way of finding it out?

Many thanks in advance.

Cheers,

Himangi Gautam