Report to show the RITM's closed 'yesterday'

tiasha123
Tera Contributor

‎03-26-2025 04:40 AM

Hi all,

 

I want to create a report show the RITM's closed 'yesterday' by a particular assignment group. I want to schedule it to run everyday. How do we do that?

 

 

Regards,

Tiasha

0 Helpfuls
  • 175 Views
1 REPLY 1

Dr Atul G- LNG
Tera Patron
Tera Patron

‎03-27-2025 12:30 PM

Hi @tiasha123 

 

Create a report on the sc_req_item table like this

AGLearnNGrow_0-1743103765527.png

 

 

Closed by is always a user NOT A GROUP.

 

AGLearnNGrow_1-1743103805355.png

 

Schedule like this

AGLearnNGrow_2-1743103841101.png

 

 

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************
0 Helpfuls