How to differentoate sc_request table with REQ from different catalog items .

[MThomas1]

Hello,

we have REQ-RITM-SCTASK generation  configured with 2 different catalog items , 1 for access purpose used by 1 division and 1 for license management purpose used by another division. 

There are dasbhboards which has REQ reports. 

How can we differenciate REQ belong to different catalog items , in our case 1. access vs 2. license ? So the dashboards will reflect individual REQ numbers? 

What are the options? Best practice? 

Thank you.

[Ankur Bawiskar]

@MThomas1 

REQ doesn't hold catalog item name

So do reporting on RITM and show REQ number in list if you want

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Tanushree Maiti]

Hi @MThomas1 

To distinguish Requests (REQ) by specific Catalog Items and present them on separate dashboards, reporting should be done on the Requested Item [sc_req_item] table instead of the Request [sc_request] table.

Create two separate reports (one for Access, one for Licensing) using the following configuration:

(for Access division):

Source Table: Requested Item [sc_req_item]

Report Type: List 

Filter Conditions:

       Item is [Name of your Access Catalog Item]

Columns to Display:

• Request (This shows the REQ number)
• Item
• Requested For
• State
• Variables (Use the + to add specific variables like "Requested Access Type")

(for Licensing division):

Source Table: Requested Item [sc_req_item]

Report Type: List 

Filter Conditions:

 Item is [Name of your License Catalog Item]

Columns to Display:

• Request (This shows the REQ number)
• Item
• Requested For
• State
• Variables (Use the + to add specific variables like "License Name")

Once your reports creation done, you can add them to your dashboards:

• Access Dashboard: Add the "Access Requests" report.
• License Management Dashboard: Add the "License Requests" report