How to identify users that have used a specific project
プラットフォームについて: Data Center のみ。 - This article only applies to Atlassian apps on the Data Center プラットフォーム。
この KB は Data Center バージョンの製品用に作成されています。Data Center 固有ではない機能の Data Center KB は、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。 Server* 製品のサポートは 2024 年 2 月 15 日に終了しました。Server 製品を実行している場合は、 アトラシアン Server サポート終了 のお知らせにアクセスして、移行オプションを確認してください。
*Fisheye および Crucible は除く
要約
In some specific migration use cases, Jira admins would need to identify the users that have used a specific project (Issues, comments, assign, reporter, permissions etc), so that all user profiles can be populated accordingly in the target instance.
ソリューション
It is possible to retrieve a list of users that have created/assigned/commented in an issue, or is a member of any project roles in this specific project:
SQL クエリ
SELECT u.lower_user_name as "Username", u.directory_id
FROM projectroleactor pra
JOIN projectrole pr ON pr.ID = pra.PROJECTROLEID
JOIN project p ON p.ID = pra.PID
JOIN app_user au ON au.user_key = pra.ROLETYPEPARAMETER
JOIN cwd_user u ON u.lower_user_name = au.lower_user_name
WHERE pra.roletype = 'atlassian-user-role-actor'
and p.pkey = 'project_key_here'
UNION
SELECT u.lower_user_name as "Username", u.directory_id
FROM projectroleactor pra
JOIN projectrole pr ON pr.ID = pra.PROJECTROLEID
JOIN project p ON p.ID = pra.PID
JOIN cwd_membership cmem ON cmem.parent_name = pra.roletypeparameter
JOIN app_user au ON au.lower_user_name = cmem.lower_child_name
JOIN cwd_user u ON u.lower_user_name = au.lower_user_name
WHERE pra.roletype = 'atlassian-group-role-actor'
and p.pkey = 'project_key_here'
UNION
SELECT u.lower_user_name as "Username", u.directory_id
FROM jiraissue I
JOIN project p ON p.ID = I.project
JOIN app_user au ON au.user_key = I.assignee or au.user_key = I.reporter or au.user_key = I.creator
JOIN cwd_user u ON u.lower_user_name = au.lower_user_name
where p.pkey = 'project_key_here'
UNION
SELECT u.lower_user_name as "Username", u.directory_id
FROM jiraaction JA
JOIN jiraissue I on JA.issueid = I.id
JOIN project p ON p.ID = I.project
JOIN app_user au ON au.user_key = JA.author
JOIN cwd_user u ON u.lower_user_name = au.lower_user_name
where p.pkey = ''
order by 1, 2;ℹ️ This query is looking for users that have used a specific project key, make sure to adjust the where p.pkey = '' to whichever project key you would like to search.
この内容はお役に立ちましたか?