User Last Login Date

[ejeong]

Is there a way we can query user's last login date to revoke all previliged sav_role if user didn't login over 90days?

I checked schema of users' table but couldn't find anything..

[rushikeshvartak · Accepted solution]

select u.username , max(logintime) from users u, userlogins l where l.userkey=u.userkey

group by u.userkey

[ejeong]

@rushikeshvartak 

Is "UserLogin" table hidden? I can't see the table name in data analyzer page and also I am not able to make query with that table in data analyzer

[ejeong]

@rushikeshvartak but I can make query from analytics

[ejeong]

@rushikeshvartak UserLogin table seems huge to search.. I want to apply filter to narrow down the scope? Any better idea? I am searching one person now.. but it is taking huge amount of time to search..