Catch the number of Concurrent Sessions / Users?

chan

Hi Guys,

Can any one advise how to capture the number of concurrent users at a given moment of time. So as to restrict access to some of the objects based on the Sessions.

For Example,

If Concurrent users cross 10, then access to table number 28100 is denied?

Any advise?

Thanks in advance..

Luc_VanDyck

Variable:
---------
Name	      DataType	Subtype	Length
recSession	Record	  Session	

MESSAGE('Number of sessions in use is: %1',recSession.COUNT);

kine

Warning! If you want to use that on MS SQL server backend, you must filter the table to "Application Name"='Microsoft Business Solutions-Navision client', else all MS SQL server sessions will be counted! =;

If you have license per database, you will need to filter to actual database too... 8)