Change Report help

[Gemma4]

Hi Everyone,

I need to create a basic list report to show active change requests with the impacted services. I am able to display the data either using change_request table or task_cmdb_ci_service. However, the problem is it is only displaying changes with a business service. For example, we have a total of 30 active changes, but the report is showing 20 and not displaying empty business services. I tried to even filter to display business service is not empty but had no luck. Attached are a couple examples to help explain. In the instance I'm using I don't have admin access, so I am limited on customizations.. not really sure why the data is not displaying. thanks for any feedback you can provide. 

[James Chun]

Hi @Gemma4,

Try something like the below:

To provide some context, you can set your Change Request conditions as per your need.

And within the Related List Conditions, select 'Impacted CIs'.

Right below the Related List Conditions label, there is a link you can select to modify the quantifier. Select it and set it to 'None'

For additional details refer to the official documentation - https://docs.servicenow.com/bundle/washingtondc-platform-user-interface/page/use/using-lists-v3/task...

I think that will display all the CHGs that have no impacted CIs associated with the record. Hope that works!

[AndersBGS]

Hi @Gemma4 ,

I can see from above that you have created your listview on task table. Why not create it based on the change_request table. If you will do this, and if business service is a related field on the form, then you should get all change requests. 

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

best regards

Anders