Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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