12-18-2009 8:44 AM
hi,
i Seek information on user activity in the SAP system (ECC 5.0):
- Date and time log on
- Date time log off
- Working time on the system
audit is turnoff, in which DB tables should I look for ? or which transaction ?
BR,
T.
12-18-2009 9:05 AM
Hi Tomasz Siedlecki,
- Date and time log on
- Date time log off
- Working time on the system
I don't think so we can get above information from SAP for each user.
I think we need third party tools like GRC to get such information.
Thanks & Regards,
Nagendra.
12-18-2009 9:08 AM
part of the requested info can be found in ST03N pay around with the reports
12-18-2009 9:13 AM
12-18-2009 9:22 AM
For these activities they are written to log files. Tables like USR02 contain last logon data but there is no history data there.
IAs Auke said, ST03N is a really good source of info. If you want to track user activities in more detail then you should activate audit logging. It will not have an impact on performance unless your system is sized incorrectly.
12-18-2009 9:32 AM
GRC uses the same data as ST03N, except it writes it's own log before ST03N aggregates the records and renames from transaction and reports.
The table you are looking for is MONI, but it will not help you much by just looking at the DB table...
There is no released function module to do this on your own. The closest thing to it is SAPWL_ACCNT_GET_SYSTEM_USAGE.
Cheers,
Julius
12-18-2009 9:32 AM
Did you try using STAT or STAD? It could provide some info for a short duration of time I think.
Regards,
CP