Filter out changes where an incident is attached

[sanjeevtanw]

Hi, can someone tell me how to create a filter to pull out the change request having an incident attached to them?

[GlideFather]

Hi @sanjeevtanw 

change the URI and navigate to this links

• For active incidents with associated change request:

https://your-instance.service-now.com/incident_list.do?sysparm_query=active%3Dtrue%5Erfc!%3DNULL

• For ALL incidents regardless their state with associated change request:

https://your-instance.service-now.com/incident_list.do?sysparm_query=rfc!%3DNULL

EDIT: updated links

[GlideFather]

@sanjeevtanw 

oh sorry, now I noticed that you want to filter these changes out...

then you can write a script with GlideRecord on the incident table (as per my link above) to get changes that are associated with incidents, and this query to apply to the change_request table, that the records are unfiltered in the secondary GR query

Please draft something and we can discuss it

[GlideFather]

@sanjeevtanw Any breakthroughs??