How to get the session login hours of SAP User IDs to get SAP Utilization?

[Former Member]

Hi,

We want to analyze the SAP Utilization by a SAP User ID in terms of SAP session login hours.

This will be calculating as the SAP session login hours from a SAP session = difference between Logoff time and Login Time of that SAP Session.

Hence we required session wise user ID, Login Time, Logoff time in a line item. as given below -

==================================================================

User ID Logon Date Logon Time Logoff Date Logoff Time

XYZ 14.12.2011 07:00:00 14.12.2011 12:44:00

==================================================================

Please suggest the way to get the relevant information for analyzing the SAP utilization.

Regards

Swapnesh Patria

[Former Member · Accepted solution]

Hello Swapnesh,

Hence we required session wise user ID, Login Time, Logoff time in a line item. as given below

You can check the last logon date and time for a user by going to the transaction SE16 and checking the fields TRDAT and LTIME in the USR02 table

Also Activate sm19 which enable the audit log filters. Once the filter is applied, the system will start tracking all the activities of the users-- You can further use SM20 transaction code to analyze the audit logs where you can find the user login/logout time, transaction executed by the user, amount of time he spent in each screen etc

Thanks,

Arjun

[Former Member]

go to the table TSTC and go to CINF there u can see login hrs og sap users

[Former Member]

Hi Nagarjuna

I didn't fnd the no. of hours for the session login hours for any User IDs.

Can you give some of the records / examples for this.

Regards

Swapnesh

[Former Member]

Hi,

Go to t-code SM20 select the instance and then give the date & time.

Give the client no., which user u want to see give the user name.

And click on Reread Audit log.

It will show u.

Regards,

Anil