LDAP と Jira 間で同期されるユーザーの合計数を調べる方法
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
目的
When investigating problems with user management, including slow directory sync, it can be useful to find the total number of users synchronized between LDAP and Jira.
ソリューション
Use the following queries to check the total number of users synchronized between LDAP and Jira.
PostgreSQL, MySQL, Oracle
SELECT DISTINCT count(lower_email_address)
AS user_count
FROM cwd_user;
Microsoft SQL Server
SELECT DISTINCT count(lower_email_address)
FROM [jiraschema].cwd_user;
最終更新日: 2022 年 1 月 24 日
Powered by Confluence and Scroll Viewport.