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

book

Article ID: 109843

calendar_today

Updated On:

Products

CA Agile Central On Premise (Rally) CA Agile Central SaaS (Rally)

Issue/Introduction



How can we get a report or a list of all users who are Team Members across all our projects in a workspace?

Environment

Release:
Component: ACSAAS

Resolution

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

<Please see attached file for image>

User-added image

Here is what your output will look like:

<Please see attached file for image>

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

Attachments

1558697938670000109843_sktwi1f5rjvs16j5w.png get_app
1558697936883000109843_sktwi1f5rjvs16j5v.png get_app