We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

how to report on SLA definition linked to requested item?

RockP
Mega Contributor

I'm trying to join the 3 tables sc_req_item,  task_sla, sc_cat_item to report on the SLA definition linked to the requested item without success. is there something wrong with the database view I created?

1 REPLY 1

AndersBGS
Tera Patron

Hi @RockP ,

 

why don’t you just dot-walk from task_sla —> sc_req_item —> sc_cat_item instead of creating a database view and joining all of them?

 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/