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?
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.
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.
[Note: So it was my turn for Friday Fun and sadly I was sick thanks to rubbish sinus infection... so apologies to most of Europe and Asia for the delayed post. However, I finally got out of bed for t...
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!
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