User Logon History

[Former Member]

I want to write a script to pull user logon history. What tables or files holds that data?

Thanks,

Daniel

[marc_saulnier]

Hi, you can start your search on table USR02 ....

Regards

[Former Member]

USR02 only holds last logon data.

Thanks,

Daniel

[Former Member]

I think I need to turn security auditing on in sm19. What tables or files does sm19 store the data in?

Thanks,

Daniel

[marc_saulnier]

>> I think I need to turn security auditing on in sm19. What tables or files does sm19 store the data in?

Yes good idea ... When you activate the profile through sm19 and set the filter option, click on Environment => profile Parameter => DIR_AUDIT ...

You will have the path where the audit log are created at the OS Level.

You can also use the transaction sm20n to view the audit file

regards