Report

ArjunkumarE
Tera Contributor

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

8 REPLIES 8

Ankur Bawiskar
Tera Patron
Tera Patron

@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.

Regards,
Ankur
✨ Certified Technical Architect  ||  ✨ 9x ServiceNow MVP  ||  ✨ ServiceNow Community Leader

Mark Manders
Mega Patron

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).


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

YaswanthKurre
Giga Guru

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
Tera Patron
Tera Patron

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.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************