How to get SC_Task number, Assigned to and Assignment Group from Task SLA Table?

[ladrake]

How can I reference the fields in the sc_task table from the sc_req_item_sla or task_sla tables?

I built an SLA report using the Task SLA table and I need to add several fields of data to my report from the sc_task table.  The fields are as follows: (sc_task) number, Assigned to, and Assignment group.  Also, I need to use the Assignment group as a filter.

I've tried to navigate to this table with no success.  Any help would be greatly appreciated.  Thanks

Larry

[Michael Fry1]

Change your table to sc_task_sla. That's a database view that combines sc_task & task_sla tables together.

[ladrake]

Hi Michael,

Thanks for the prompt response.  It is helpful to know that a database view is needed in order to build this report.  The database view that was suggested does not produce any results.  I'm guessing that tracking SLAs at the RITM level is the reason why.  Is there a database view that allows me to pull data from the Task SLA, Catalog Task SLA, and the Request Item SLA fields?

Larry

[Michael Fry1 · Accepted solution]

Out of the box - no, but you could build a new database view or check if someone else has built one already.

[ladrake]

Thanks, Michael.  I'll pursue building our own database if I cannot find one that some else has already built.

Larry