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

DominionA007
Tera Contributor

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

1 ACCEPTED SOLUTION

Runjay Patel
Giga Sage

Hi @DominionA007 ,

 

Follow below steps.

1. Navigate to reports module and create new.

2. Select sc_task table and put below filter condition.

RunjayPatel_0-1736231299208.png

 

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

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

7 REPLIES 7

Bhavya11
Kilo Patron

Hi @DominionA007 ,

 

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

 

Thanks,

BK

If this information proves useful, kindly mark it as helpful or accepted solution.

Thanks,
BK

Viraj Hudlikar
Tera Sage

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.

Is relative, means not updated? 

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.