Report

[ArjunkumarE]

How to track RITM requests for a "catalog item" "requested by" group members belong to a particular group

[Ankur Bawiskar]

@ArjunkumarE 

sorry your requirement is not clear.

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Mark Manders]

Please elaborate on your question, because it's not clear what you are trying to achieve. What is it exactly that you are looking for?

If you need to combine a lot of tables, database views are the way to go (if that's what you are trying to achieve).

[YaswanthKurre]

Hi @ArjunkumarE ,

If I assumed properly, here is what you can try.

Report Configuration by creating a database view:

• Table: sc_req_item (Requested Item)

• Join Table: sys_user_grmember

  • Join Condition: requested_for (on sc_req_item) → user (on sys_user_grmember)

Filter Conditions:

1. cat_item = [CATALOG_ITEM_SYS_ID]

2. sys_user_grmember.group = [GROUP_SYS_ID].

3. Replace [CATALOG_ITEM_SYS_ID] and [GROUP_SYS_ID] with the actual sys_id values of your catalog item and user group.

Columns to Display:

• number (RITM number)

• requested_for (User name)

• cat_item (Catalog item name)

sample query:

cat_item =  [CATALOG_ITEM_SYS_ID]^JOINsys_user_grmember.user=requested_for^sys_user_grmember.group=[GROUP_SYS_ID]

Mark this as helpful and correct if this helps you.

Thanks,

Yaswanth.

[Dr Atul G- LNG]

Hi @ArjunkumarE 

What you're looking for may not be a good use case. The reason is that the requested user is essentially an end user—meaning they don’t have any specific roles or groups assigned. In such cases, it's not easy (or even possible) to determine which group the end user belongs to, as there is technically no group mapped or attached to their profile.