目的

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. 

SELECT DISTINCT count(lower_email_address) 
AS user_count
FROM cwd_user; 

SELECT DISTINCT count(lower_email_address) 
FROM [jiraschema].cwd_user;