Script to retrieve the latest login timestamp of a user in Venio

select * from (

select 

UI.username,

pld.logintime as logindatetime,

pld.LogoutTime as logoutdatetime,

ld.LoginFrom,

ld.ipAddress,

p.ProjectName,

row_number() over(partition by username order by logindatetime desc) as sn

from 

tbl_pj_userinfo ui,

tbl_pj_LoginDetails ld,

tbl_pj_ProjectLoginDetails pld,

tbl_pj_ProjectSetup p




where




pld.DetailsID=ld.DetailsID and

ui.IsUserDeactivated=0 and 

ui.UserID=ld.UserId and

p.ProjectID =pld.ProjectID

)a

where sn=1 and logoutdatetime is null order by logindatetime desc