how to limit the number of concurrent users per company?

mightykid

I would like to know if it's possible to allocate a specific number of concurrent users per company. Please see the sample below:


Lincensed users : 30 Concurrent users


Allocation:
Company A : 20 concurrent users
Company B : 10 concurrent users

Any suggestions?

garak

mhm, you can create an new table: "Allowed users per company" (Company Name Text 30, max No. of Users integer). Here you define the number of useres allwowed in company. And an second table connected users per company (Companyname, User Name, Session ID). Both tables are not DataperCompany.

Then on CU1 (there are functions Like CompanyStart (or so)) you check how many useres allowed in the company. Than count the sessions of connected Navision Clients on this company. If the limit is not get, than let the user login and save the information in table 2. If user logoff from company you must delete the row in table 2. If the limit is catched, than send an (error) information message an block connecting (or close the client with using WSH and ALT+F4). But user with "Super" permissions should be ever have the right to connect ;-)

But note, it's possible, that an navision client crash and the login information are still stored in table 2. so u must delete this entry manuell or per batch. For example check the SessionIDs on Session Table with the stored sessionID in table 2.

Regards

mightykid

thanks for the tip. i have found a solution which uses the user time register table.