confluence account information

[Hsu Yao Chang]

Dear all, 

Would it be possible to know the login out time of each account in the confluence everyday?Or is there any plugin can support the function? Thank you.

[Chander Inguva]

Hi Hsu,

            Find the below Database table which stores the information.

select distinct(attribute_name) from cwd_user_attributes;

Result Set:

attribute_name

com.atlassian.jira.dvcs.invite.groups
invalidPasswordAttempts
lastAuthenticated
login.count
login.currentFailedCount
login.lastFailedLoginMillis
login.lastLoginMillis
login.previousLoginMillis
login.totalFailedCount
password.reset.request.expiry
password.reset.request.token
passwordLastChanged
requiresPasswordChange

select user_id,attribute_name,attribute_value from cwd_user_attributes where attribute_name = <'One of the above you are interested in'>;

Hope this helps

Regards

Chander