How do we find all Requested items that are Closed Complete where the associated Catalog Tasks are still open?

[Community Alums]

Hi,

I would like to create a report where I can find all Requested items that are Closed (Closed complete) but the associated Catalog Tasks are still open.

How can I create a report for this in ServiceNow? 

Thank you,

Preet

[Slava Savitsky · Accepted solution]

In a list of Catalog Tasks or a report based on [sc_task] table, apply the following filter:

Active = true AND Request Item.Active = false

Or if you are specifically interested in Closed Complete state:

Active = true AND Request Item.State = Closed Complete

[Community Alums]

Thank you for your help! It works!

[Malaya]

Use task table with below filters:

thanks

Malaya