Need to audit & manage users

[Richard]

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 solution]

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

[Richard]

Thanks.  Its a good base. I can try and expand it when time allows.  The remember me function kinda throws a spanner in the works but hey ho.

Cheers