incident aging report for 15-60, 60-120 and 120+ days

vamshi2
Tera Contributor

HI Team, 

i used below filter for  15-60, 60-120 and 120+ days

active=true^state!=6^sys_created_onRELATIVELT@dayofweek@ago@14

 

with above filter count is 6589


and for  15-60

active=true^sys_created_onRELATIVELT@dayofweek@ago@14^state!=6^sys_created_onRELATIVEGT@dayofweek@ago@60
with above filter count is A

active=true^sys_created_onRELATIVELT@dayofweek@ago@59^state!=6^sys_created_onRELATIVEGT@dayofweek@ago@120
with above filter count is B

active=true^sys_created_onRELATIVELT@dayofweek@ago@119^state!=6
with above filter count is C

so A+B+C = 6956 which is not equal to 6589

so i need filter which shows equal count as like total count of individual report

or Please provide me conditions which get data for incidents which are created 15/60/90 days ago








6 REPLIES 6

Hi @vamshi2 

Out of the box (OOTB), these dates are available. You just need to write a script — or simply copy your existing code and convert it into a script.

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

****************************************************************************************************************

Dr Atul G- LNG
Tera Patron
Tera Patron

Have a look : https://www.youtube.com/watch?v=mjA4Qf6nynY

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

****************************************************************************************************************
This ServiceNow tutorial will demonstrate how to create incident aging report in ServiceNow and how to create aging report in ServiceNow. A ServiceNow aging report allows you to view the ServiceNow incident age. Incident age refers to how old a ServiceNow incident or ServiceNow request is and is ...