Hi @Mansi roy
Your query is not clear
There are 2 cases..
1. You need the records which are on hold currently..if yes then better create separate reports on Inc, change, prb etc., it is straightforward.
2 case , you want all records which were on hold before move to closed state. In this case you neec to create metrics on each table and then Database View and then report.
*************************************************************************************************************
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]
****************************************************************************************************************
