Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

How do you get number of seat licenses available using Providex ODBC?

Posted By LouisRoselli over 8 years ago

How do you get number of seat licenses available using Providex ODBC? Meaning, is there a Table that stores the number of users taking a seat? I know there is the sy_console table, but that just shows who has what window/process open.

0 connex over 8 years ago

Is that encoded in the UserRegistrationKey of SY_SYSTEM?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 LouisRoselli over 8 years ago in reply to connex

The max number of seat licences is encoded within the UserRegistrationKey. I'm wanting to get the number of seat licences used at a given moment of time.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Kevin M over 8 years ago in reply to LouisRoselli

A distinct count of workstation name in sy_console will likely give you the correct number.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

How do you get number of seat licenses available using Providex ODBC?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING