Get a first look at what's coming. The Developer Passport Australia Release Preview kicks off March 12. Dive in! 

Report of Catalog Item with no SLA

NtokozoEmmK
Tera Contributor

Hi

Which table source can I use to create a report of Catalog Items with no SLA?

 

Kind regards

5 REPLIES 5

Dr Atul G- LNG
Tera Patron

task_sla is the one that contains the information, with conditions like number, start, and RITM

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Tanushree Maiti
Tera Sage

Hi @NtokozoEmmK 

 

You can create a report based on the sc_req_item table

with related list condition as below:

 

TanushreeMaiti_0-1773841555091.png

 

Please also ensure to create a report that have the aggregation possibility:

TanushreeMaiti_1-1773841555600.png

 

 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin:

Yes, you are right, @Tanushree Maiti.

The question was that the RITM didn’t have an SLA, so your approach worked

 

@NtokozoEmmK 

*************************************************************************************************************
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/dratulgrover [ Connect for 1-1 Session]

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

Ankur Bawiskar
Tera Patron

@NtokozoEmmK 

this link has approach from @AndersBGS from 2024

How to get a list of all catalog items that does not have an SLA attached to it 

55.png

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  10x ServiceNow MVP  ||  ServiceNow Community Leader