Question

Capture user last login

  • 25 February 2021
  • 10 replies
  • 314 views
A

Hello,

 

Is there a table hidden somewhere that captures the last login date per user?

 

Thanks!

Arno

10 replies

D
Userlevel 2

The User Account Maintenance has a Date Last Used field, which is from the following table.field:

SysUserFile.LastLogOnAttempt

Thanks! | David Inman | Cornell Pump Company | Clackamas OR
S
Userlevel 4

ice.sysuserfile

G
Userlevel 3

Agree with @dinman , the user security table (SysUserFile) contains the last logon date. (LastLogOnAttempt).

Glenn Owers Sr. Business Analyst Safran Electronics & Defense Canada Peterborough, ON Canada Version: 2021.2..23
A

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

G
Userlevel 3

Is the UserId you are creating the BAQ with, identified as a Security Manager?

Glenn Owers Sr. Business Analyst Safran Electronics & Defense Canada Peterborough, ON Canada Version: 2021.2..23
A

Hi Glenn,

 

Yes, it is.

 

Arno

A

 

G
Userlevel 3

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? 

 

Glenn Owers Sr. Business Analyst Safran Electronics & Defense Canada Peterborough, ON Canada Version: 2021.2..23
A

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

C
Userlevel 2

If all you want is their last login, why not just user “User Tracker”

No need to write anything.

 

Reply


Terms & Conditions