I have a rather big Jira database and would like to create a filter that displays users that haven’t been online for x amount of time. My problem is I don’t know how to import my Jira database to a sql server. Jira API’s does not provide any methods to retrieve last logged in information.
So my question is how do I start writing sql queries directly to my Jira database?
For what it’s worth, there are also add-ons like Atlassian Marketplace which allow you to export your users to CSV and then parse it from there. Disclosure: I am the author of that add-on.