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

[StacyLen]

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

[Dr Atul G- LNG · Accepted solution]

Hi @StacyLen 

Or

Go to Reports --> All

[Dr Atul G- LNG]

Hi @StacyLen 

In this case you need to create database view for Change & SLA , Sc task and SLA and run this report with conditions. 

OOTB these are available

[StacyLen]

Thank you.  I will try to leverage this info

[Dr Atul G- LNG]

Hi @StacyLen 

Please share the feedback.

[StacyLen]

Thank you Giga Sage.  I will eval this to see if it addresses my need.  If so, I will indeed accept it as solution

thanks