Is CWD_USER.UPDATED_DATE the same as the "Last Login Date"?

[Benjamin Dains]

If you look at https://developer.atlassian.com/server/jira/platform/database-user-and-group-tables/ it references the CWD_USER table and it has a column called UPDATED_DATE. 

Is the updated date the same as the latest login date for a user?

[David A · Accepted solution]

Hi @Benjamin Dains 

I think no! Updated date  not is the same as the latest login date.

  Check this url https://confluence.atlassian.com/jirakb/find-the-last-login-date-for-a-user-in-jira-server-363364638.html

I hope this helps!

[Nic Brough -Adaptavist-]

@David A is right - the last updated date is the last time data for the account was changed (name, email, etc), it's not a record of any activity.

[Benjamin Dains]

Thanks @Nic Brough -Adaptavist- & @David A , I'm trying to run the Oracle query but it keeps telling me the view or table doesn't exist and it's erroring out during the select * portion, not exactly sure why.

[Benjamin Dains]

Nevermind I got it, thanks for the help! 

PS anyone doing this, you just need to update the schema in front of the table name to get it going.

[Benjamin Dains]

One last thing @Nic Brough -Adaptavist- , the reason I asked this question is because the updated date for my user was today, and I haven't updated anything for my user in a couple months, so that's why I was confused.

[Nic Brough -Adaptavist-]

Yes, that's a good reason to ask.  Maybe they updated part of it, like the password, or maybe you have an external user directory and something there changed?

[Benjamin Dains]

@Nic Brough -Adaptavist- ahh yes, I didn't even think of that, we do have it hooked up to our AD, so that must be the case.

Thanks!