User not available in cwd_user table but the UI shows full name, email etc...

[Aman]

Hello, I am trying looking at an issue against which a user logged time but then left the org. I am able to see the user's full name, email, etc.. but the cwd_user table does not have any info about this user.

I was able to pull the worklog for this user, the same user_key is available in the app_user table but not the cwd_user table. How can I get the full name other details of this user from the database?

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

Stop reading the database, it doesn't necessarily work the way you are guessing it might.  It's not designed for reporting, and looking at the database is the worst possible way you can get information out of the database.

Take a look at the REST APIs and reporting in Jira (and apps, for that matter)