boxi r3 - Sdk - Retrieve active sessions

[former_member1337072]

Hi.

I've been hunting around the forums and through the SDK documentation, but to no avail.

My problem is retrieving the current active session count on our server. Any pointers is appreciatedt.

I know the information is to be found in the CMC but I need the count for our support center statistics.

Tom

[Former Member]

Hi,

thank you for your code,

I'm using your query with a little customization

Select

SI_LOGON_ALIAS, SI_APSNAME, SI_NAME, SI_LAST_ACCESS

from ci_systemobjects

where

SI_KIND='Connection' and

SI_PARENTID=41 and

SI_AUTHEN_METHOD != 'server-token' and

SI_FAILOVER_AVAILABLE_UNTIL is NULL

and I've found CMC and query output are always the same

Best regards

Francesco

[former_member1337072]

HI again...

Found a way to match the sessions shown in the CMS. I'm currently using the following query and it seems to work:

Select * 
from ci_systemobjects 
where 
SI_PARENTID=41 and
SI_AUTHEN_METHOD != 'server-token' and
SI_FAILOVER_AVAILABLE_UNTIL is NULL

Tom

[former_member1337072]

I've found one addition which seems to help a bit:

SI_AUTHEN_METHOD != 'server-token'

But still there is quite a few extra logons...

[former_member1337072]

Hi again.

I've been using the query from the solution above and it is somehow correct.

But I've noticed a difference between the session count in the CMC and the number returned by the query, the query "always" gives a somewhat higher count than the active sessions shown in the CMS.

Any ideas about what could cause that and how to remove the extra hits?

Tom

[Former Member]

Hi,

IInfoObjects sessions =
        infoStore.query("select * from ci_systemobjects where SI_PARENTID=41);
 int sessiionCount = sessions.size();

Enjoy

Johannes