users groups reporting

Question ID: 106916
0
0

Is there a report or a query that can be run to provide a list of users and the groups to which they belong for a project?

Marked as spam
Posted by (Questions: 122, Answers: 3)
Asked on June 21, 2016 7:48 pm
6 views
Answers (1)
0
Private answer

There is not a report built in to Quality Center to show this. However, you can build a report to query this information or pull directly from the database if you have access (or run from Site Admin - Site Projects tab). The data comes from the USERS table and the GROUPS table in the project. In the USERS table, the US_GROUP field is a bit mask of the GR_GROUP_ID field in the GROUPS table. So, character 1 in the USERS.US_GROUP represents the first group in the GROUPS table, etc. Using a substring query against the US_GROUP field can provide you the users and the groups they are in.

**EXAMPLE:**

SELECT US_USERNAME, GR_GROUP_NAME
FROM GROUPS, USERS
WHERE SUBSTRING (US_GROUP, GR_GROUP_ID+1, 1) = '1'

Marked as spam
Posted by (Questions: 3, Answers: 168)
Answered on June 21, 2016 7:50 pm