Need to audit & manage users

Question

HI, looking to audit our users by core/software users and when they last logged in but I cannot find the data I need in the tables.
Can you please advise what tables I need construct my T-SQL query from. I have identified the below but I cannot find where the login details come from that I see in the GUI user edit screen. Is that all encrypted?

[jiraschema].[app_user]
[jiraschema].[cwd_user_attributes]
[jiraschema].[cwd_user]

Ideally I'd have the user statistics from the
 user screen (show in attached) and showing if they're core/software users.

Thanks

Daniel Ebers · Accepted Answer

Hi Richard,

I am not absolutely sure for the distinction between Software/Core. At least for the last login there is an article in knowledge base which might be of help - depending on your database and version.

Cheers,
Daniel