Query returning list of IFS Cloud users and their group

@PGNPROXSVE you could try with the below query:

select fu.identity
        , fu.web_user Directory_ID
        , fug.user_group_id 
        , user_group_api.Get_Name(fug.user_group_id) User_Group_Name
from fnd_user fu
     LEFT JOIN Fnd_User_By_Group fug
     ON fu.identity = fug.identity

thank you very much @Marcel.Ausan for your answer. Your proposal requires me to have access to the IFS database. To date, I have not yet have such access, but we are in the process of obtaining it. 

Could I create this table using IFS Cloud’s Query Designer instead ?

Wonderful. It was a matter of adding the permission to Quick Reports and thx to your query, I have my listing now. Thanks a lot. You have been a great help.

@PGNPROXSVE glad I could help. Would have been useful if you would have marked my answer as solution and not yours 😁.

fair point @Marcel.Ausan , I meant to mark you answer as the right one, obviously, but I clicked the wrong one. I’m trying to figure out how to undo it, but no luck so far. I’ll reach out to the moderator.

Hello @PGNPROXSVE  I have unchecked the best answer for you. You can know select the correct one you wished to :)

Thank you both for great contributions :)

Many thanks,
Grzegorz