10-22-2008 7:43 PM
Gurus,
How can we know who has locked the transaction code in a system?
Thanks,
Saga
10-24-2008 6:52 AM
Hi Sagarika,
As mentioned by Julius, you can configure the audit log.
Or you can try the following to narrow down your search.
1) Use STAD/ST03N.
I am considering STAD for the following steps.
2) Get the list of the users executing SM01 using Transaction=SM01.
3) Go to Edit-> Select output fields.
4) Select only User & Update requests.
Non-zero value under Update requests indicates the user has made some changes.
Still I am finding a way
1) to differentiate between the update requests for locking & unlocking & then
2) to relate a request with the transaction.
Regards,
Sachhidanand Rankhambe
10-22-2008 7:52 PM
Hi,
Use Tcode SM12 with * in user field. You will get the list of user names.
Rakesh
10-22-2008 8:16 PM
Rakesh,
I am just wondering how we can see the tcodes locked. Here I can see only tables locked.
Could you please let me know if I am wrong?
Thanks,
saga
10-22-2008 8:20 PM
Hi Sagarika,
Go to SM01 and then key in the t-code that you want to check and then enter.
If the t-code is locked you will see the box checked beside it.
Thanks,
Saby..
10-22-2008 8:24 PM
10-22-2008 8:32 PM
This also give only list of tcodes locked but not showing who locked the tcode.
Thanks,
saga
10-22-2008 9:00 PM
There is no standard easy way to do this.
If this is a once off investigation based on an event, then you can use the audit logs (SM20, etc) to see who used transaction SM01 since the last time the transaction which is locked was last successfully used.
There is a complicated way of activating a more detailed way of logging, but it is not easy to use.
See transaction SE13 (log data changes, and search for threads about it) and this thread:
Please leave the thread open for a while. Perhaps someone knows of another way.
Cheers,
Julius
10-22-2008 9:02 PM
In SM12 chose a valid row and go to detail view of the lock.
Under technical attributes you will get the tcode name which is locked along with user.
Rakesh
10-24-2008 6:52 AM
Hi Sagarika,
As mentioned by Julius, you can configure the audit log.
Or you can try the following to narrow down your search.
1) Use STAD/ST03N.
I am considering STAD for the following steps.
2) Get the list of the users executing SM01 using Transaction=SM01.
3) Go to Edit-> Select output fields.
4) Select only User & Update requests.
Non-zero value under Update requests indicates the user has made some changes.
Still I am finding a way
1) to differentiate between the update requests for locking & unlocking & then
2) to relate a request with the transaction.
Regards,
Sachhidanand Rankhambe