Agile Central - Excel: How to get a list of all Team Memberships in a workspace

Document ID : KB000109843
Last Modified Date : 06/08/2018
Show Technical Document Details
Question:
How can we get a report or a list of all users who are Team Members across all our projects in a workspace?
Answer:
You can use the Excel add-in to get that report.

- Create a Query to the Workspace Permission type.
- Select the columns you need. 
- Additionally, manually add/type "User.TeamMemberships".

User-added image

Here is what your output will look like:
User-added image
Additional Information:
More on Excel add-in: https://help.rallydev.com/rally-add-excel-installation-user-guide
Video on how to use Excel add-in: https://help.rallydev.com/rally-add-excel