We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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
  • 527 Views
1 REPLY 1

Dr Atul G- LNG
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

 

 

*************************************************************************************************************
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

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