Create report for all Change Requests that have touched or assigned to my list of assignment groups

[gvtri39]

Hi All,

I need to Create report for all Change Requests that have been touched or assigned to my list of assignment groups for a specific month? Also, I should be able to have columns for Created, Updated and Resolved/Closed.

Could someone please help me with this?

I have tried using the Change Request Metric Table, with Definition as Assignment group and Value is list of assignment groups using the OR condition. This does not fetch me any records. However, when I use the Change Request Table, I am able to get records but am not sure if the list of CRs are then ones that have been touched/updated/closed/resolved during a specific month.

Thanks!

[AJ-TechTrek]

Hi @gvtri39 ,

You need to use Metric Definitions and Instances.  Luckily Assignment Group already has a metric definition, so all you need to do is report on the metric instance table.  There should already be a database view that joins this with incidents.

There will be one record for each time an Incident was re-assigned and how long that group was assigned to the ticket.

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

ServiceNow Community Rising Star 2024

[Its_Azar]

Hey there @gvtri39 

To create a report for Change Requests

1. Navigate to the "Change Request" module in ServiceNow.
2. Click on the "Reports" tab or navigate to the "Reports" module.
3. Create a new report with the following parameters:
   • Table: Change Request [change_request]
   • Filter: Add filters for assignment groups. Use the "OR" condition to include multiple assignment groups.
   • Additional filters: Add filters for the specific month in the "Created", "Updated", and "Resolved/Closed" fields.
   • Columns: Include columns for "Created", "Updated", and "Resolved/Closed".
   • Grouping: You may group the results by any relevant field if needed.
   • Sorting: Sort the results by date or any other relevant field.
4. Save the report with an appropriate name and description.

Once the report is saved, you can run it whenever needed to view the desired Change Requests data.

If this helps kindly accept thr response thanks much.