how to check if an ID exists in how many client ?

[Former Member]

hi,

i have more than 10 clients in DEV and i am not using CUA. so to maintain user IDs i have to log in to each of the clients.

when developers leave the project or company, i have to delete their ids from the clients. now the problem is to identify which are the clients have the id.

is there any table or any tcode which allows me to check across all clients for the existence of an id ?

comment and advice will be highly appreciated.

regards,

kent

[Former Member · Accepted solution]

Hi

Well at SAP level, it seems bit complicated to me, but at SQL you can certainely find it:

Logon as sysdba:

select mandt from sapr3.usr02 where bname='id you require';

Hope this resolves your query.

Regards

Rahul

Edited by: Rahul Deo on May 26, 2008 10:58 PM

[Former Member · Accepted solution]

Hi Kent,

Usually i will follow this method in all my landscapes.

If You run this report(RSUSR100) in se38 it will solve all your problem.

Regards

Vijay kumar

[Former Member · Accepted solution]

hi Vijay kumar,

this report only list out the users in the client where i run the report.

that means if i login to client DEV100 and run the report, it only shows me users in DEV100. so if i got DEV200, DEV300, DEV400 ... i will have to login one by one ..

is there any report that can show cross client info ?

regards,

kent

[Former Member · Accepted solution]

Hi Kent

You need to run the query I provided in last post.

Else you can prepare a Z report, for the same in SAP.

Regards

Rahul

[Former Member · Accepted solution]

hi Rahul,

i have no access to os / db .. only have full access in sap application. if at application level i can run some report that would be very helpful.

will ask my dba to try the sql statement.

tq.

regards,

kent

[Former Member · Accepted solution]

Try report RSUVM005 which is also available in tcode USMM (a tool in the license audit workbench), unless it is a SAP standard user, in which case you should use report RSUSR003.

Cheers,

Julius

Edited by: Julius Bussche on May 27, 2008 11:52 AM

[Former Member · Accepted solution]

hi Julius,

ya, i am aware about this USMM user classification.

i guess this would be the best i could get.

thanks a lot.

regards,

kent