how to join sc_task, task_sla and sc_req_item tables

steveturley · ‎05-21-2024

Hi.

I need to report on an sla that is on the REQ from an sc_task perspective (i.e. filtering on the 'Assigned To' of the sc_task)

I think I need to create a database view similar to this - how to join sc_task, task_sla and sc_req_item tabl... - ServiceNow Community but using sc_req rather than ritm

Can anyone advise please?

Jitendra Diwak1 · ‎05-21-2024

If you want to combine this table as well then you have to create the new record under View Tables below:

So if you want to add the Incident then you can do same thing.

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

Thanks

Jitendra

Please accept my solution if it works for and thumps up.

DhanashreeM · ‎05-21-2024

@steveturley so your SLA is on request table?

You just need to replace sc_req_item table with sc_request as on SLA table in task field you will get request number if SLA is on request table only.

Please let me know if it is helpful.

Regards,

Dhanashree

steveturley · ‎05-21-2024

Yes, that's correct. I've replaced sc_request as you've suggested, but nothing returns

Jitendra Diwak1 · ‎05-21-2024

You can create the database view as per the screenshot below:

You can also refer this post below:

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

Thanks

Jitendra

Please accept my solution if it works for and thumps up.

steveturley · ‎05-21-2024

I need to report on the sla attached to the sc_req. Your example above doesn't link to the task_sla table?