Can someone help me with the below query.
I want to view all the requests pending for action by an user.
What is the backend I should use for it?
When you say a query are you looking to add something to a scoreboard or are you running something in SQL itself? Additionally, you would need to also need to define what classifies as a pending action for a user. In other words, what are the actions that you are looking for, and what determines if its pending for a user?
You can leverage the following to return the Catalog requests with a pending action for a user:
select distinct request_id from usm_request_pending_action where status in (1,5) and ( ( user_id = 'spadmin' ) or ( group_id in ( 'test group' ,'test group 2') ) )
If you are not interested in pending actions assigned to group(s) the user is part of you can remove that part of the condition, otherwise you can specify a particular group(s) or all groups as included in the 'User Group Membership' section of the user's profile in the Catalog UI.
This helps, Jason