Need catalog tasks report that shows me all (OPEN) records that HAVE NOT been updated > 48 hours.

DominionA007 · ‎01-06-2025

Runjay Patel · ‎01-06-2025

Follow below steps.

1. Navigate to reports module and create new.

2. Select sc_task table and put below filter condition.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

View solution in original post

Bhavya11 · ‎01-06-2025

Hi @DominionA007 ,

You can just create a report based on updated is more than relative 48 hours ago.

Thanks,

BK

Viraj Hudlikar · ‎01-06-2025

Hello @DominionA007

You can create report on Catalog Task [sc_task] table, by putting conditions as per below snip:
Report Filter.png

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.

DominionA007 · ‎01-07-2025

Is relative, means not updated?

Viraj Hudlikar · ‎01-07-2025

Hello @DominionA007 - No.

To clear how to use relative operator and its use-cases have a look on this video done by @Uncle Rob 😇
https://youtu.be/VaFUWcmQ6l4?si=4JdfHaFxJ2LLxzqx

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.