Oracle SQL Query to fetch Users from database

[Shaikh Moiz]

Hello folks,

I am not able to get users list from backend,

I am following the KB as,

https://confluence.atlassian.com/display/JIRAKB/How+to+Get+a+List+of+Active+Users+Counting+Towards+the+JIRA+License

and getting the error table or view does not exists,

we want to get the user list with thier last login details,

any help is appreciated,

Regards,

Moiz Shaikh.

[Nic Brough -Adaptavist-]

What user directory are you using? Are you sure your database is the right one? Are you looking in the right tables for your version of Jira?

[Shaikh Moiz]

Hello Nic,

we are using Jira's default internal directory. No external directory like crowd or LDAP we are using.

[Nic Brough -Adaptavist-]

Ok, and which version of Jira? It matters because the user handling changed between 2 and 3, and 4.2 and 4.3

[Nic Brough -Adaptavist-]

What user directory are you using? Are you sure your database is the right one? Are you looming in the right tables for your version of Jira?