simultaneous connections to BO at an hourly basis

[Former Member]

How will I get number of simultaneous connections to BO at an hourly basis.

From the session(CMC) i am not able to find existing log.

[Former Member]

Please let me know how can I get the list number of simultaneous connections to BO at an hourly basis in SAP BO XI 3.1 SR 6

[onkarvelhals]

Please elaborate more..among following which connections you need:

• BO user's connections
• BO client connections
• BO's database connections
• BO's reporting database connections
• BO's web application connections.

[onkarvelhals]

FYI:

An excerpt from SAP Note 1728121

To get number of  user sessions:

Open the Query Builder URL: http://[server]:[port]/AdminTools/

Log on as an Administrator to get full access to all the repository objects and execute below SQL:

SELECT

SI_ID, SI_USERID, SI_APSNAME, SI_LOGON_ALIAS, SI_LASTLOGONTIME

FROM CI_SYSTEMOBJECTS

WHERE SI_KIND = 'Connection' AND SI_FAILOVER_AVAILABLE_UNTIL = NULL AND SI_AUTHEN_METHOD != 'server-token' ORDER BY SI_ID

[Paul1202]

Hi,

when you install the "standard" audit-universe  and the associated WEBII & Cristal-reports, you'll see a CR with name "Users - By Day  - Concurrent Sessions".

It produced some nice graphs. One graph with an overview , by 25-hours, how many users were logged in (max). And another one, which shows the same on all days

[onkarvelhals]

Hi Anutosh,

I would recommend to use Wily Introscope via the "Remote Support Component" .

If you just need user session, you can retrieve list using code like in SAP Note 1886165 - How to terminate user session manually in XI 3.1 and BI 4.0?

Hope it helps.

Regards,

Onkar

[former_member185603]

Check Audting DB.

[Former Member]

Apprecite your quick response.

We are using SAO BO XI 3.1 SR6. Please help me with information related to XI 3.1 SR6.