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.
A picture is worth a thousand words, especially when you're trying to find relationships and understand your data. Here, Dashboards play a vital role in gaining insights from a variety of dat...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events