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
  • 556 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