About Logon DATA

[Former Member]

hi all,

please give me specific table name to get details of logon information about user.......

means i can see which user logon to the system on specified date and time and which tcode used by user ...........

don't give me any standard program or tcodes ...... just give me table name....

full points will be definitely rewarded for helpful answer...........

Thanks,

Imran

[Former Member]

Hi Imran,

Check this link,

Thanks,

Reward If Helpful.

[Former Member]

Hi,

Check USR02.

Regards

Bala

[Former Member]

Hi,

<u><b>Tables:</b></u>

USR01 -- User master record (runtime data)

USR02 -- Logon data

USR04 -- User master authorizations

Regards,

Padmam.

[Former Member]

hi all,

thanks for the reply........

i know all this tables..........this tables only give information about last logon date......

but i want to details as on date....for example....if i m entering yesterday's date....

than i can see which user login on which client,server(prod,dev,quality),terminal id,tcode...

or any of the date.......

Thanks,

Imran

[Former Member]

hi all,

please dont give any tcodes......

i just want to table name........

Thanks,

Advance

[Former Member]

hi freinds,

please give me table names.............its urgent........

thanks,

Imran

[Former Member]

Hi Imara,

I have written code below for get logon user address details .

****get the user personal numnber

select single * from usr21 where bname eq sy-uname.

if sy-subrc eq 0.

• <b>Get the user first and last name</b>

select single * from adrp where PERSNUMBER eq usr21-PERSNUMBER.

****<b> Get the user Telephone numner and extenstion</b>

select single * from adcp where PERSNUMBER eq usr21-PERSNUMBER and

ADDRNUMBER eq usr21-ADDRNUMBER.

• <b>Get the user Email address</b>

select single * from adr6 where PERSNUMBER eq usr21-PERSNUMBER and

ADDRNUMBER eq usr21-ADDRNUMBER.

• <b>Get the user Fax number</b>

select single * from adr3 where PERSNUMBER eq usr21-PERSNUMBER and

ADDRNUMBER eq usr21-ADDRNUMBER.

endif.

If its useful reward the points

Regards,

D.prabhu

[S0025444845]

Hi,

You can use TCODE SM04 for this purpose.

regards,

sudha

[Former Member]

Hi,

Please check Tables USR41 & USERTRACE.

Regards

Bala

[Former Member]

hi BALA,

thanks for the reply but table which u have given is giving information based on last logon date............................

i want information as on date..........if i m entering date 01.01.2007

than i can see which user logon on that day....with details which i have specified earlier.

thanks,

Imran

[Former Member]

hi all,

hey freinds still not got the answer............do some help yaar.........

regards,

Imran

[Former Member]

hi all,

i thing there is no such table exist................

thanks to all for reply......

thanks,

Imran

[Former Member]

hi friends,

what happen gurus.......still not got the answer...........

Regards,

Imran