Skip to Content

How to get no.of users in a specific client

HI,

I need to find the no of users in a specific client , but i don't have accounts to all the clients. I tried from one client where i have the account and executed SE16N and table usr02 got only client specific users list. And as per my understanding USR02 is a client speicific table.

What is the best to find the no of users for all the clients , is it possible from SQL query lik select count(*)from usr02 where mandt etc.. ? or is there any best way ?

Regards

Veeramalla.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Posted on Oct 11, 2011 at 07:01 AM

    Hi,

    To add condition "mandt =" you have to add to your query key word CLIENT SPECIFIED. Look in SAP help for details.

    BR

    Marcin Cholewczuk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2011 at 07:47 AM

    Dear venkateshwarlu,

    You have asked a question and answered it yourself.

    USR02 is table and group by MANDT feild.

    Hope it helps.

    Hussian S

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 11, 2011 at 09:24 AM

    Hello,

    i think transaction AL08 could also do the job. It displays all users in all clients and all instances. You can export he list to a spreadsheet to analyze it further.

    regards

    Christian

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 13, 2011 at 03:51 PM

    Just go to AL08 you can cumulative user in all application server. The same can be verified through SMLG Tcode with Global user list. Save some grey matter for other purposes.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2011 at 09:05 AM

    Hi

    Try this query

    select * from schema.USR02 where MANDT='999' and USTYP='A'

    what is your db?

    if it Sqlserver the schema is SID.sid.tablename.( eg TST.tst.USR02),use management studio >>newquery

    it its Oracle

    SAPSR3.usr02 or SAP<SID>.tablename

    Regards

    Arun.H

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.