Skip to Content
0
Former Member
Jun 27, 2013 at 12:07 PM

Code for finding out no of users in BO

1373 Views

Hi All,

I need a write a query for getting

- Count of users in BO

- Count of current no of session

Code in query builder

Count of users in BO - SELECT count (SI_ID) FROM CI_SYSTEMOBJECTS where SI_KIND='USER'

Count of current no of session - SELECT count(SI_ID) FROM CI_SYSTEMOBJECTS WHERE SI_KIND = 'Connection' AND SI_FAILOVER_AVAILABLE_UNTIL = NULL AND SI_AUTHEN_METHOD != 'server-token' ORDER BY SI_NAME

I need to write the above code in database.

I use BO XI R3.1

Backend: SQL Server

Thanks for any help on these.

Regards

Shreyas