You can create a report that filters for a specific Item, and pulls in additional information from parent records (RITM and Request) by dot-walking. In the screenshot below, the report is based on task_sla, and then the task [+] field was expanded to show all fields available from any kind of task record related to task_sla. By doing this, you can access the Item field and the Request field from the RITM. However, assuming that your SLAs are attached to the RITM and not the catalog tasks, you cannot also pull in the sc_task information. If you need to do this, you will need to create a database view that ties together the Request, Requested Item, Task SLA, and Catalog Task tables.
Please mark as correct/helpful if this answered your question.
You can create a report that filters for a specific Item, and pulls in additional information from parent records (RITM and Request) by dot-walking. In the screenshot below, the report is based on task_sla, and then the task [+] field was expanded to show all fields available from any kind of task record related to task_sla. By doing this, you can access the Item field and the Request field from the RITM. However, assuming that your SLAs are attached to the RITM and not the catalog tasks, you cannot also pull in the sc_task information. If you need to do this, you will need to create a database view that ties together the Request, Requested Item, Task SLA, and Catalog Task tables.
Please mark as correct/helpful if this answered your question.
