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

[Former Member]

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.

[DellSC]

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