Expand all | Collapse all

Number of Concurrent Users

  • 1.  Number of Concurrent Users

    Posted 06-03-2015 02:06 PM

    Is there an easy way to get a list of the historical maximum amount of concurrent users in the system? Admin --> License Information provides an overview of the type of license, and the user license activity report gives a good overview of activity, but it does not include statistics regarding concurrent users.

  • 2.  Re: Number of Concurrent Users

    Posted 06-03-2015 06:13 PM

    If you have access to logs you could just check the number of request happening each minute.


    For example:


    cat app-access*.log | cut -f 1 -d " " | rev | cut -c 4- | rev | lxsort -u | uniq -c | sed "s/  */ /g" |  sed "s/|\[/ /" | sed "s/ /\t/g" >goo.txt


    cat all the access logs into cut to pull off just the ip and date time.

    Flip the line to remove the seconds and push into a unique sort (sort on linux on my windows box I renamed linux sort to lxsort so I didn't use the window sort command).

    Then get a count of the number of unique accesses for a given minute by IP address

    Do some text cleanup with sed.



    Drop this file into Excel and pivot on the datetime field.





  • 3.  Re: Number of Concurrent Users

    Posted 06-04-2015 03:02 AM

    Check these -


    Query for user concurrency


    Concurrent Sessions




  • 4.  Re: Number of Concurrent Users

    Posted 06-04-2015 04:35 AM

    The problem with the  user concurrency query is that it onlz brings the data since the clear user sessions job was run the last time. That can typically be run at one day intercals.

    So that is not going to give the maximum unless you run it daily eg for a year and record the results.

    The access logs by default give numbers for a longer period than the session tables.

  • 5.  Re: Number of Concurrent Users

    Posted 06-19-2015 07:36 PM

    Hi Daniel-


    Many people like to use the User License and Activity Report to gather this type of information.



    Elizabeth Mark-Hollandsworth

    Support Engineer

    CA Clarity Project & Portfolio Management

  • 6.  Re: Number of Concurrent Users

    Posted 06-22-2015 01:54 PM

    Looks like there's already some good answers here, but in case you need more: we use a portlet provided by Rego Consulting to grab users currently logged in. You can grab the NSQL (for an Oracle backend) from Rego's xChange website here: