To Kill the user session in 3.1 SP6

[Former Member]

Hi All,

Checking if have any script to kill the active session.

We had followed below KB article

1886165-How to terminate user session manually in XI 3.1 and BI 4.0?  however we don't have any option to kill all the session at a time as we need to kill each user manually.

Any inputs would be much helpful.

Regards,

Shiva G

[Former Member]

Hi Shiva,

You would need to look put for the query in code and remove the si_name from it. Something like below

"SELECT SI_ID, SI_USERID, SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS WHERE " +

      "SI_KIND = 'Connection' AND SI_FAILOVER_AVAILABLE_UNTIL = NULL AND SI_AUTHEN_METHOD != 'server-token' " +

      "AND SI_NAME !='Administrator';

Make sure to test the query in query builder prior to updating the code. The above query brings all the user sessions apart from administrator. I am not sure why you would want to kill all users session, however consider taking database backup before running any script.

Thanks,

Prithvi

[Former Member]

We are trying to terminate session which has been not loged out properly.Query provided by SAP  will let us kill the sessions one at a time not all the sessions

We are trying to modify the query so we can kill the session all at a time instead of selecting one user.

Regards,

Shiva

[Former Member]

http://scn.sap.com/community/bi-platform/java-sdk/blog/2013/05/14/scripts-for-user-management

In Above script we got the required information.

Regards,

Shiva

[Former Member]

Hi Shiva,

You can also use the below KBA that contains a Program Object:

1996692 - How to Automate the Cleanup of Stale BI4 User Sessions

The above KBA contains a Progarm Object that takes number of minutes as parameters, since it is a Program Object you will get the benefit of running the same as per your requirement, just make sure you don't enter the value less than 60 minutes as the PO is designed to ignore any value less than 60 minutes as it is the default timeout of CMC.

Hope this helps.

Regards,

Rajarsh