Remove Duplicates from Report

[Travis Garris1]

I am trying to create a dashboard with all open change requests opened against a specific data center.  So, I build a report against task_ci.  I ask it for all CIs that have their location set to the data center in question and 'Task.Active[Change Request] is true'.  I get Task.Number and Task.Requested By and stuff, but if a change request cites two or more CIs at that location, they show up in the report for each CI.  That makes the list look much longer and confuses the users.

Group by won't work for this.  I want the dashboard to show the change request numbers, requesters, short descriptions, and such.

Also, I'm just the change manager.  I don't have access to do scripts or whatever in ServiceNow. 

[pavani_paluri]

Hi @Travis Garris1 

If you build the report on the task_ci table, you’ll naturally see duplicate records whenever a single change request is linked to multiple configuration items. To avoid that, create the report on the change_request table instead. Use the Configuration Item field on the change request to apply the same location filter. The only limitation is that the filter will only catch change requests where the primary CI has its location set to your data center — if the CI chosen doesn’t match the location, that request won’t appear in the report.

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for

Kind Regards,

Pavani P

[Travis Garris1]

Thank you for the reply.

Regrettably, we have a lot of customization.  We aren't using Primary Ci.  We also aren't using services.