Create Report for Request, Request Items and Change that are overdue

StacyLen
Mega Guru

I need to created a report showing all Req, Ritms and Change that are overdue by 3 or more days.    I have created such a report for Incidents, using the ootb view "Tasks.Breached SLAs (Task SLA)" as my only data source.  

 

But I have not found an ootb datasource that covers task types where there is no SLA (no breached field), leveraging the Due Date or other such fields.

 

Any help appreciated, including step by step on how to build the necessary dbase view (if that is, as I suspect) what is needed.

 

Thanks much to any who can assist

StacyLen

2 ACCEPTED SOLUTIONS

Hi @StacyLen 

 

LearnNGrowAtul_0-1702575386493.png

Or

Go to Reports --> All

LearnNGrowAtul_1-1702575416112.png

LearnNGrowAtul_2-1702575437632.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]

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

View solution in original post

Thanks @StacyLen  for marking my answer as helpful, Now you can mark multiple answers as Solution accepted. 

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

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

View solution in original post

13 REPLIES 13

Hi @StacyLen 

 

A table which is created by user is start either with u_ or X_ 

 

LearnNGrowAtul_0-1702575723287.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]

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

Yes, I know this.  But my question is:

There are OOTB Tables in ServiceNow

There are OOTB dbviews in ServiceNow

But I think the OOTB dbviews could easily be mistaken for just Tables (it seems for all practical purposes, they ARE tables).  But how to tell if it is actually a Table or a View of Table or Tables?

@StacyLen 

 

Sorry, for the confusion, DB is nothing but the tables (logically built) and there is no differentiation of the table and DB other than by a good name of the table. 

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

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

Thanks @StacyLen  for marking my answer as helpful, Now you can mark multiple answers as Solution accepted. 

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

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