Service Catalog - Sc_REQ table - how to differentiate REQs from different service catalogs

[MThomas1]

Hello, 

we have 1 service catalog for access requests - which creates REQ/RITM/SCTASKS.

we are in need of creating another catalog for license request purpose. 

Since both the REQs will be created in sc_request table with number "REQ0000000" format,  how can we differentiate 2 different catalogs requests for reporting/matrix purpose in the sc_request table ?

Rename REQ number is a recommended option? 

Any OOTB options available?

Thank you.

[SumanthDosapati · Accepted solution]

@MThomas1 

You cannot show catalog item name in list/form of your sc_request.

You need to create a database view with sc_request and sc_req_item for that.

If your logic is in a script that runs on sc_request then you can make a gliderecord call to sc_req_item to get the catalog item name.

Rename REQ number is a recommended option? - Definitely NOT Recommended

Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth

[yashkamde · Accepted solution]

Hello @MThomas1 ,

if your goal is reporting/matrix separation, the cleanest OOTB solution is to report by catalog or category rather than touching the REQ number.

[SumanthDosapati · Accepted solution]

@MThomas1 

You cannot show catalog item name in list/form of your sc_request.

You need to create a database view with sc_request and sc_req_item for that.

If your logic is in a script that runs on sc_request then you can make a gliderecord call to sc_req_item to get the catalog item name.

Rename REQ number is a recommended option? - Definitely NOT Recommended

Accept the solution and mark as helpful if it does, to benefit future readers.
Regards,
Sumanth

[SumanthDosapati]

@MThomas1 

Did the above solution solve your query? If yes, Accept the solution and mark as helpful to close the thread and benefit other readers.

Regards,
Sumanth

[yashkamde · Accepted solution]

Hello @MThomas1 ,

if your goal is reporting/matrix separation, the cleanest OOTB solution is to report by catalog or category rather than touching the REQ number.

[Ankur Bawiskar · Accepted solution]

@MThomas1 

I agree with what @SumanthDosapati  mentioned.

that's the way forward

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