Rally: How to Extract team members list from the entire workspace

Products

• Rally SaaS

Issue/Introduction

How to Extract team members list from the entire workspace?

Environment

Release : SAAS

Component : SAAS

Cause

Users cannot retrieve the list of team member reports using Rally UI, this is a known product limitation in Rally.

Resolution

Note: This custom code is developed by a third party that is outside of available Rally functionality (This workaround is not supported by Rally )

**(Only applicable) for Sub Admins/Workspace admins 

Please follow the below steps and test this workaround.

1. Please install Python's 3.10.7 version -( https://www.python.org/).
2. Open command prompt run pip install pyral

3. Copy the below script and save it in a dedicated location under c Drive (Sample files are attached below)

import sys
import urllib3
from pyral import Rally, rallyWorkset

urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning)

options = [arg for arg in sys.argv[1:] if arg.startswith('--')]
args    = [arg for arg in sys.argv[1:] if arg not in options]
server, user, password, apikey, workspace, project = rallyWorkset(options)

print("Starting run")

rally = Rally(server, user, password, workspace=workspace, project=project, verify_ssl_cert=False)
rally.enableLogging(dest=b'rallylog.log', attrget=True)

projects = rally.get("Project", fetch='Name,ObjectID')
print('Project Object ID,Project Name,Username')
for project in projects:
    team_members = rally.getCollection('https://rally1.rallydev.com/slm/webservice/v2.0/Project/{project_object_id}/TeamMembers'.format(project_object_id=project.ObjectID))
    for team_member in team_members:
        print('{project_object_id},{project_name},{username}'.format(project_object_id=project.ObjectID,project_name=project.Name,username=team_member.UserName))

print ("Finished run")

4. Create a config file in the same directory as the above file and plz name itrally-v2.0.cfg

SERVER=rally1.rallydev.com

USER=

PASSWORD=

WORKSPACE=

PROJECT=

Please update this file with the necessary information.

5. From the command prompt call the script via python <scriptname>

Here, Users will recieve all the requested details in your command screen.