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..
Go to Solution.
select u.username , max(logintime) from users u, userlogins l where l.userkey=u.userkey
group by u.userkey
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
@rushikeshvartak but I can make query from analytics
@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..