- SAP Community
- Groups
- Interest Groups
- Application Development
- Discussions
- last login date of a deleted user
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
last login date of a deleted user
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2008 3:40 PM
Hi there,
Could you please let me know how to find the last login date of a deleted user in the SAP.
Thanks
Amit.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2008 6:30 PM
Hi Amit,
You can start by searching the forum for transactions like SM19 and SM20
-Abhishek
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2008 10:01 AM
Hi Abhishek,
Thanks for you immediate help.I have checked both the transaction Sm19,SM20 in the SAP system. Could you please explain in details as to how can you use to find the last login detail of a deleted user.
Regads
Amit
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-06-2008 8:56 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2008 8:24 AM
Hi Amit,
the problem is, that the last logon date is kept in table usr02 (field TRDAT). If you delete the user, the usr02-entry is deleted. Therefore the real last logondate is lost when deleting the user.
If you did not use the audit log (see above) to log logins, it will not be posssbile to find out, when this user had logged in the last time. Only one chance, if he had to change his password when logging in that time, then you have that date in the changelogs for users.
b.rgds, Bernhard
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2008 9:57 AM
Hi Bernhard,
Thanks a ton for the reply.
you are correct that they you cannot get the details of a deleted user from USR02 but they are ways in which you can still find the last login date of a deleted user.
One of the ways is using of transaction SUIM but i have no idea why this is not working in my system.
Anyways if you can find any relevant detail please let me know.
Regards
Amit
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2008 10:03 AM
>
> One of the ways is using of transaction SUIM but i have no idea why this is not working in my system.
Hi Amit,
I have never been able to use SUIM to get this data for deleted users in any system I have used. I would say that it is an exception that you have been able to get this data before.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2008 4:30 PM
So does it means that we cannot find the last login date of a deleted user in SAP.
Does this means it is a mistake or shortcoming on SAP Part.
- SAP Managed Tags:
- Security
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-07-2008 4:38 PM
>
> So does it means that we cannot find the last login date of a deleted user in SAP.
>
> Does this means it is a mistake or shortcoming on SAP Part.
It is possibly a shortcoming.
Another reason to retain ID's for a certain amount of time before deleting them.
- SAP Managed Tags:
- Security
