Catch the number of Concurrent Sessions / Users?

chanchan Member Posts: 2
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..


  • Options
    Luc_VanDyckLuc_VanDyck Member, Moderator, Administrator Posts: 3,633
    Name	      DataType	Subtype	Length
    recSession	Record	  Session	
    MESSAGE('Number of sessions in use is: %1',recSession.COUNT);
    No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
  • Options
    kinekine Member Posts: 12,562
    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)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
Sign In or Register to comment.