Hello,
Is there a table hidden somewhere that captures the last login date per user?
Thanks!
Arno
Hello,
Is there a table hidden somewhere that captures the last login date per user?
Thanks!
Arno
The User Account Maintenance has a Date Last Used field, which is from the following table.field:
SysUserFile.LastLogOnAttempt
ice.sysuserfile
Agree with
Hello again,
I am trying to write a BAQ with the last login information. When I select that SysUserFile I have no available fields to choose from. Am I missing something?
Thanks again!
Arno
Is the UserId you are creating the BAQ with, identified as a Security Manager?
Hi Glenn,
Yes, it is.
Arno
I just created this BAQ over the SysUserFile and have access to all fields. I am the Security Manager for our company. Any Field Level security on the SysUserFile?
Hey Glenn,
I am not sure, I would hope not. I inherited this system a year ago. I will check with the original implementer and see what I can find out.
Thanks for pointing me to the right direction!!
Arno
If all you want is their last login, why not just user “User Tracker”
No need to write anything.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.