Create a JRS report on Users and Roles
3 answers
You can do this in JRS against the data warehouse, but you need to build a custom SQL report. All the data is available in the data warehouse if you know how to query for it.
You'll want to look in the RIODS schema for these tables: TEAM, TEAM_ASSIGNMENT, TEAM_MEMBER_LOOKUP, TEAM_RESOURCE_LOOKUP, TEAM_ROLE, TEAM_ROLE_MEMBER_LOOKUP
Here's a sample SQL query that will give you the Teams, Roles, and users who have these roles for a specific project
SELECT DISTINCT P.name as Project, T.NAME as Team, TR.NAME as TeamRole, R.name as Resource FROM RIODS.TEAM T, RIODS.TEAM_ROLE TR, RIODS.PROJECT P, RIODS.RESOURCE R, RIODS.TEAM_ROLE_MEMBER_LOOKUP L WHERE P.name = 'your project name here' and TR.TEAM_ID = T.TEAM_ID AND L.RESOURCE_ID = R.RESOURCE_ID AND L.TEAM_ROLE_ID = TR.TEAM_ROLE_ID AND P.project_id = T.project_id
Expanding on Davyd's answer ... I believe some teams use the Jazz Foundation API to pull the data directly. See https://jazz.net/wiki/bin/view/Deployment/CLMProductAPILanding