Identify JIRA users from Active Directory who have not logged in recently.

Question

Hi there folks,

I have been using the Postgres query in the following article to identify users on my dev instance who haven’t logged in within 90 days - all of the users on this instance are local users and it works great:

https://confluence.atlassian.com/jirakb/identify-users-in-jira-who-haven-t-logged-in-for-the-past-90-days-695241569.html

However now that I am looking at our production instance, where the majority of users are pulled in from AD - I have noticed that this query is only identifying local users, not AD users.

Is there a way to (ideally) have it show both local and AD users, or even just AD users? I am not a big database person, and haven’t been able to successfully edit the query myself, so any help would be much appreciated.

Thanks!

Yeahdj · Answer

Hi there,

Sadly I don’t have script runner and apparently it’s too expensive.

Currently I am using Jenkins to run the db query in one stage, outputting the usernames to a file. Then in the next stage, using the JIRA API to remove each of the usernames contained in the file from the group we use to assign licenses.

This works pretty good - if I could get it to output AD users to a file also.

Thanks!

Juan José Marchal Gómez · Answer

Hello @Yeahdj ,

do you have scriptrunner?

If you have scriptrunner you can access to AD to read the information of it.

Best regards.