Easy way to check lastlogin date for all users

[ejeong]

Could anyone explain me a way to export last login date for all users? by looking audit table, its taking too much time to query for all users..

[dgandhi]

Hi @ejeong 

Below queries should give you desired output. Check userlogins table.

Thanks

[ejeong]

I couldnt use this query it's taking very long time in our envrionment. 

don't you face any issue when querying all users with this query?

[dgandhi]

I didn't execute this in Prod so don't know about timing. But yes you can limit the output by adding some condition in the where clause.

Thanks

[rushikeshvartak]

select u.username,ul.logintime,ul.logoutdate from users u left join userlogins ul on u.userkey=ul.userkey group by ul.userkey order by ul.logintime desc

[ejeong]

@rushikeshvartak 

I tried to create report with query provided 

but its taking long time as mentioned.

[rushikeshvartak]

Last 30 days 

select u.username,ul.logintime,ul.logoutdate from users u left join userlogins ul on u.userkey=ul.userkey
and ul.logintime BETWEEN CURDATE() - INTERVAL 30 DAY AND CURDATE()

group by ul.userkey order by ul.logintime desc