JIRA user details

Question

I want to take following details for a JIRA user.

* User-Name
* No. of Filters subscribed by the user
* No. of Dashboards subscribed by the user
* No. of issues modified by the user
* No. of issues commented by the user
* User custom field references In which Database tables I can find these data?

In which Database tables I can find these data?

Chander Inguva · Answer

Hi Ruwan,

* User-Name: cwd_user
* No. of Filters subscribed by the user: filtersubscription
* No of Dashboards subscribed by the user: Not sure of this. You can 
* No. of Issues modified by user: jiraaction
* No of issues commented by user: jiraaction
* Customfield: customfield and customfieldoption

Refer to https://developer.atlassian.com/jiradev/files/4227160/JIRA61_db_schema.pdf for more details.

Hope this helps

Regards

Chander Inguva

Gabor Nagy _Midori_ · Answer

Hi Ruwan,

I think it's much easier and less error-prone to access these data through the REST API.

I recommend using the REST API browser in your JIRA instance to experiment before writing any code, its URL should look like this: http://localhost:2990/jira/plugins/servlet/restbrowser

For example, "api-2-user" endpoint can be used to answer your first question.