List of Concurrent Users

[kbenson]

Hello Community,

We are trying to find out how many concurrent users logging into BO in day for over an year, to make sure we are not exceeding our licenses. Could anyone please let me know how can I get this information?

I have tried using query builder and aslo tried to fetch some reports from audit universe, but couldn't find right information.

I appreciate the help.

Thanks!

Kristen

[former_member185603 · Accepted solution]

Audit should give the information by day. And also, if you are just looking to get an alert, I would suggest to setup an alert in CMC -> monitoring on CMS server, metric, setup a threshold like lower threshold and upper threshold. if it reaches the limit, you can setup to send an email to you, so you are aware of license usage.

[kbenson · Accepted solution]

Hi Jawahar,

Thank you so much and I appreciate your help. I was able to check highest number of sessions created by Concurrent users since start up in monitoring and also created a watchlist.

Thanks again!

[Joe_Peters]

This query will display the peak reported concurrency per day. It's in Oracle syntax but can be adjusted as necessary.

select 
    trunc(start_time) start_day,
    max(to_number(substr(to_char(ad.event_detail_value),1,length(to_char(ad.event_detail_value))-1))) max_concur
from
    ads_event ae
    join ads_event_type_str et
        on ae.event_type_id = et.event_type_id
        and et.language = 'EN'
    join ads_event_detail ad
        on ae.event_id = ad.event_id
    join ads_event_detail_type_str dt
        on ad.event_detail_type_id = dt.event_detail_type_id
        and dt.language = 'EN'
where
        event_type_name = 'Logon'
    and event_detail_type_name = 'Concurrent User Count'
    and rownum < 20
group by
    trunc(start_time) 
order by 
    1

I believe that the reported concurrency is all users on the system and not just those with a concurrency license. I could be wrong.

[Joe_Peters]

This query will display the peak reported concurrency per day. It's in Oracle syntax but can be adjusted as necessary.

select 
    trunc(start_time) start_day,
    max(to_number(substr(to_char(ad.event_detail_value),1,length(to_char(ad.event_detail_value))-1))) max_concur
from
    ads_event ae
    join ads_event_type_str et
        on ae.event_type_id = et.event_type_id
        and et.language = 'EN'
    join ads_event_detail ad
        on ae.event_id = ad.event_id
    join ads_event_detail_type_str dt
        on ad.event_detail_type_id = dt.event_detail_type_id
        and dt.language = 'EN'
where
        event_type_name = 'Logon'
    and event_detail_type_name = 'Concurrent User Count'
    and rownum < 20
group by
    trunc(start_time) 
order by 
    1

I believe that the reported concurrency is all users on the system and not just those with a concurrency license. I could be wrong.

[kbenson]

Hi Amit,

Thank you so much for your response.

The URL provided gives the information of all the concurrent users, but our requirement is to find how many concurrent users are logging into to BO everyday for over a period of year in order to make sure we have enough licenses.

[amitrathi239]

check attached link.

http://www.forumtopics.com/busobj/viewtopic.php?t=70045&sid=794e18cadf133245a1130bd40f92b30f