how to join sc_task, task_sla and sc_req_item tables

[steveturley]

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]

Hi @steveturley,

I have only connected the REQ, RITM and SC TASK table only. So you can now add one task_sla table and link it to like I have linked the all table together.

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

Thanks

Jitendra

[steveturley]

Could you advise what the 'where clause' would be when linking the task_sla table please?

[Jitendra Diwak1 · Accepted solution]

Hi @steveturley,

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

[steveturley]

That's it! Thanks for the help.