total users/groups in jira and confluence

[Padmasree P]

how to get the total user list from db for Jira and confluence 

like internal users, ldap users, groups, 

[Pete Singleton]

The table CWD_USER contains all the users regardless of which directory.

To map to directory use the CWD_DIRECTORY table.

Similarly, use CWD_GROUP table for the groups.