Looking for reports

[vikramkhatr]

Hello Team,

We have a requirement where we need to create two reports as:

1. List of Incidents for which ticket reassignment happened between group A and other partner assignment groups. (November 2023 - MTD)
2. List of Incidents in which restoration SLA was breached in Group A and moved to other partner groups.

I am not able to understand how we can achieve this requirement and looking for your help.

Kindly suggest a possible solution to achieve the requirement.

Note: We need to achieve it without creating any custom fields.

Thanks in advance,

Vikram.

[Jitendra Diwak1]

Hi @vikramkhatr

To create the reports you described in ServiceNow, you'll need to use the Reporting module and create two separate reports based on your requirements. Here's how you can approach each report:

### 1. List of Incidents for which ticket reassignment happened between Group A and other partner assignment groups (November 2023 - Month-to-Date):

#### Steps:

1. **Create a New Report**:

   - Navigate to `Reports` > `Create New`.

   - Choose the appropriate report type (e.g., List Report).

2. **Define Report Criteria**:

   - Set the date range to November 2023 to Month-to-Date.

   - Add filters to include incidents where the assignment group changed from Group A to other partner assignment groups.

3. **Select Fields**:

   - Include fields such as Incident Number, Short Description, Assignment Group, Reassignment Information, etc.

4. **Save and Run the Report**:

   - Save the report with a meaningful name.

   - Run the report to verify the results.

### 2. List of Incidents in which restoration SLA was breached in Group A and moved to other partner groups:

#### Steps:

1. **Create a New Report**:

   - Navigate to `Reports` > `Create New`.

   - Choose the appropriate report type (e.g., List Report).

2. **Define Report Criteria**:

   - Add filters to include incidents where the restoration SLA was breached in Group A.

   - Further filter to include only those incidents that were moved to other partner groups.

3. **Select Fields**:

   - Include fields such as Incident Number, Short Description, Assignment Group, SLA Breach Information, Reassignment Information, etc.

4. **Save and Run the Report**:

   - Save the report with a meaningful name.

   - Run the report to verify the results.

Ensure that the filters and fields selected in each report align with your specific requirements. You can customize the reports further based on additional criteria or fields needed for analysis.

Please accept my solution if it resolves your issue or thumbs up 

Thanks 

Jitendra 

[vikramkhatr]

Hello @Jitendra Diwak1 ,

Thank for your response.

Sorry but I know how to create reports in servicenow, my question is, how can we achieve the requirements and what should be the filter criteria as I don't see any fields to determine it.

1. In report one, how to get the reassigned group names.

2. In report two, how can we determine in SLA was breached in group A only since it is already assigned to a diff groups.

Please Suggest.