RE: [development-axapta] Date/Time of last login

2005-02-02 Thread Matt Benic
SysUserLog is what you want: select firstonly * from SysUserLog order by createdDate desc, createdTime desc where (SysUserLog.UserId == MY_ID) (SysUserLog.Type == SysLogType::login) You can check the createdDate/time for the actual login time. Regards, Matt Benic Axapta Developer UTi

Re: [development-axapta] Date/Time of last login

2005-02-02 Thread wb
Hello Daniel static void ew_lastLogin(Args _args) { SysUserLog userLog; ; select userLog order by logoutDate desc, logoutTime desc where userLog.UserId == curUserId() userLog.TerminatedOk == true; info(strfmt('%1 %2', userLog.createdDate, time2str(userLog.createdTime, 1, 1))); }

RE: [development-axapta] Date/Time of last login

2005-02-02 Thread Daniel Redelinghuys
@yahoogroups.com Subject: RE: [development-axapta] Date/Time of last login SysUserLog is what you want: select firstonly * from SysUserLog order by createdDate desc, createdTime desc where (SysUserLog.UserId == MY_ID) (SysUserLog.Type == SysLogType::login) You can check the createdDate/time