user login with details

[Former Member]

hi guys,

was need to come out a report for the user login details. which has to have the date and time of the user login to SAP, with the terminal ID access from and transaction has done. can any one tell me what table it is from? or is there existing report that i can view all this? thanks

[Former Member]

Execute transaction SM04.

Reward if useful.

[kesavadas_thekkillath]

USe table USR02...Everything is there

[Former Member]

Hi,

Pls refer USR02 table.

Thanks,

Sriram Ponna.

[Former Member]

hi,

you can find the transactions by a particular user from the transaction SM04.

SM04 gives you the details of the users logged in,terminals,transactions the user is working on, the time he has logged in,no of sessions user has opened, and the memory used by the user's programs... all of that w.r.t to the client we login. but we can't get info like date and number of times the user has logged in.

U can see tables:

USR01 User master record (runtime data)

USR02 Logon data

USR03 User address data

USR05 User Master Parameter ID

USR12 User master authorization values

You can also use transaction code ST03N.

1. Go to tx code - ST03N

2. Under "Workload" you can select your "Instance or Total" so that it expands and shows you Days, Week, Month.

3. If you want to look at the transactions executed for a particular day, lets say, then double click on any day.

4. At the bottom left you get "Analysis Views"

5. Select & expand "User and Settlement Statistics"

6. Double click on "User Profile"

7. On the right side of the window you get a list of all the users

8. Double click on a particular user you want to view the details of.

9. The new screen will display the "Transactions/Reports Utilized by User XXX"

If you want to track which users executed a particular transacation then follow this:

10. In "Analysis Views" expand "Transaction Profile"

11. Double click on "Standard"

You can view the list of Transactions and Reports.

12. Double click on the Tx Code or Report you wanna check and it will show the Use of it.

hope this is helpful

regards,

sravanthi

[Former Member]

hi,

go to USR02 table. it will give all your requirment.

Reward if find helpful.

Anirban Bhattacharjee

[Former Member]

hi ,

use these table

USR01 User master record (runtime data)

USR02 Logon data

USR03 User address data

USR05 User Master Parameter ID

USR12 User master authorization values

regards,

dilip

[Former Member]

hi,

u can refer table USR02 for your Report.The details you have mentioned in your query are avaliable in the table.

For any Master Record of a Particular User refer to table USR01.

reward if useful

regards

Sumit Agarwal

[Former Member]

hi All,

but i need the data to be select by dates, which is,

to display the user ID login using which work station(terminal ID), access what transaction code, or what process on selection date. the date can be any time for selection.

i need it because have to trace who and when a person done some thing.

SM04 only provide me instant access, and ST03N i was unable to find the terminal ID to be show in it.

[Former Member]

hi

in USR02 you have fields which gives you the logon date and last logon time of the person. Also u find the values of password changes.

You will find Host No and other host related info from USR01.

hope this will help.

reward if helpful.

Regards

Sumit Agarwal

[Former Member]

hi,

i want all the details( every time it access to SAP) of the login, but not the last login...