Hi Nivi,
Thanks for clarifying. You should be able to get what you are asking for using the Excel add-in.
You can learn on the Excel add-in here if you are unfamiliar with it:
CA Agile Central Add-in for Excel Installation & User Guide | CA Agile Central Help
Excel | CA Agile Central Help
What you can do is use the add-in to export a query for your 'Workspace Permission' object. My Screenshot below is showing you how. Please note, that I manually typed at end of the Columns line the string: "User.TeamMemberships", so the full string of the Columns line is:
Role,Subscription,Workspace,User,User.TeamMemberships
Note that this Filter I'm adding here is just to filter it by one workspace. You don't have to add a filter, but you may cause if you have too many workspaces then this export may take long.
This shall export for you something like that:
Please let me know if that answered your question.
Thanks,
Sagi