question Re: Service Catalog - Sc_REQ table - how to differentiate REQs from different service catalogs in Community Central forum

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

MThomas1 — Fri, 16 Jan 2026 16:49:50 GMT

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.

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

SumanthDosapati — Fri, 16 Jan 2026 17:36:04 GMT

@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

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

yashkamde — Fri, 16 Jan 2026 17:46:43 GMT

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.

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

SumanthDosapati — Mon, 19 Jan 2026 10:06:56 GMT

@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

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

Ankur Bawiskar — Mon, 19 Jan 2026 10:22:08 GMT

@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! 🙏