Our LDAP users do not update login statistics

We migrated all our users from JIRA internal to our active directory over a year ago. I noticed after this migration that in login statistics for all users had "Not recorded" for all entries. I put it on a very low priority, since it did not really affect our operation. Users added to the active directory after the migration have their login statistics correctly updated.

Now this is becoming a bigger issue, because the lastComment/lastUpdate together with inRole/inGroup function (by works btw.) from ScriptRunner does not list any issues involving users existing before the migration.

So, what can we do to correct the existing users?

5 answers

1 accepted

This widget could not be displayed.

Issue has been resolved. Problem was in the database

This widget could not be displayed.

Could you provide the exact JQL you're using, plus details about an issue that should be included, but isn't?

This widget could not be displayed.

The JQL is: 

issueFunction in lastUpdated("inGroup jira-users")

This should show all issues in our DB (which is 10k+), but only 19 is shown. All 19 issues have been last updated by users added after the migration. If I do the following:

issueFunction in lastUpdated("by Mads")

Then I get all issues last updated by me.

This widget could not be displayed.

Hm. In your user management screen, are the old internal accounts still there as unlicensed users, without being part of the jira-users group?

This widget could not be displayed.

I have an update to this issue. Before the migration, each user had an entry in both the JIRA directory and the active directory. Unfortunately, the user names were different by using different rules. We had to change the user names of all users in the JIRA directory to match the user names in the active directory.

My colleague has found the following: Some tables are referencing the users in "app_user" table by "lower_user_name" instead of "id". He has updated these tables to the correct "lower_user_name" so that lastUpdated now works. We will change some other tables so that lastComment also works. You can resolve this issue.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted yesterday in United States

Local Atlassian Research Workshop opportunity on Sep. 28th

We're looking for participants for another workshop at Atlassian! We need Jira admins who have interesting custom workflows, issue views, or boards. Think you have a story to sh...

13 views 0 0
View post

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you