Skip to Content
author's profile photo Former Member
Former Member

jsp code for getting the count on active sessions and users in the systems

Hi All,


I want to add a chart (pic,bar) on the infoview home page (where we find Document list and Personalize). The chart should be dynamic.

For ex: Pie chart should display the active no users v/s total no of users.

I have gone through the below thread. http://scn.sap.com/thread/3374717

I am new to SDK. Could you please help.

We have BO environment, we would like to have same chart as above.

Could you please explain the detailed steps to get the out put as above.


Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 03, 2013 at 02:24 PM

    This is a Java question that should really be asked over in the Java Application Development Space here: http://scn.sap.com/community/bi-platform/java-sdk. However, here's the logic you'll need:

    1. Log in to the CMS as Administrator.

    2. To get the session count, run the following query in the CMS:

    Select SI_ID, SI_DATA from CI_SYSTEMOBJECTS where SI_KIND = 'Connection' and SI_NAME != 'System Account'

    3. For each IInfoObject found in the query, find the CADENZA_timeOutCheck property of the SI_DATA property. If the value is true (meaning this is an active session), increment the session count.

    4. To get the active user count, run the following query in the CMS:

    Select SI_ID, SI_ALIASES from CI_SYSTEMOBJECTS where SI_KIND = 'User' and SI_NAME != 'Administrator' and SI_NAME !='Guest' and SI_NAME != 'SMAdmin'

    5. For each IInfoObject found in the query, walk through the Aliases property. If the Disabled property of any of the aliases is false, then the user is active and needs to be counted. NOTE: If you're only using Enterprise authentication, you may only have one alias per user. If you're using ActiveDirectory or LDAP authentication, you may have more than one alias.

    -Dell

    Message was edited by: Dell Stinnett

    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.