How to identify list of active users in Bamboo
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
The purpose of this page is to provide a DB query that will help extract a list of all active users in Bamboo.
Environment
The query has been tested on Bamboo 8.2.4 but will be applicable to all supported versions. This query will work on all the DB versions available ( Oracle, PostgreSQL, MySQL, SQLServer )
Solution
List of active users in Bamboo
1
2
3
4
5
6
7
8
9
10
SELECT USER_NAME,
FIRST_NAME,
LAST_NAME,
DISPLAY_NAME,
EMAIL_ADDRESS,
DIRECTORY_NAME,
DIRECTORY_TYPE
FROM CWD_USER U
INNER JOIN CWD_DIRECTORY D ON (U.DIRECTORY_ID = D.ID)
WHERE U.ACTIVE = 'T' AND D.ACTIVE = 'T';List of Active users in Bamboo along with the groups which they belong to
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
SELECT DISTINCT USER_NAME,
FIRST_NAME,
LAST_NAME,
DISPLAY_NAME,
EMAIL_ADDRESS,
DIRECTORY_NAME,
DIRECTORY_TYPE,
PARENT_NAME AS GROUP_NAME
FROM CWD_USER U
INNER JOIN CWD_DIRECTORY D ON (U.DIRECTORY_ID = D.ID)
LEFT OUTER JOIN CWD_MEMBERSHIP M ON (U.LOWER_USER_NAME = M.LOWER_CHILD_NAME)
WHERE U.ACTIVE = 'T' AND D.ACTIVE = 'T'
AND M.DIRECTORY_ID = D.ID
ORDER BY USER_NAME,DIRECTORY_NAME,PARENT_NAME;Was this helpful?