Alan Subel posted on October 26, 2010 10:05

Determining How Many Sage MAS 500 and BI User Licenses Are Being Used
- Sage MAS 500 user license:
- A standard MAS 500 user license is validated when an application task is launched from the business desktop.
- Application tasks include all tasks in the Maintenance, Activities, and Reports folders on the Tasks tab.
- Sage MAS 500 is licensed by concurrent user. The number of available users that can launch tasks in Sage MAS 500 decrements when a user starts a new task.
- After all available user licenses are taken, no additional users can launch an application task until a current user logs out from the Sage MAS 500 application.
- Business Insights (BI) user licenses:
- BI user licenses are used when the following applications are started:
- Business Insights Explorer
- Business Insights Analyzer
- Business Insights Dashboard
- If a user in Business Insights Explorer opens a Sage MAS 500 application task, the BI user license automatically transfers to a standard Sage MAS 500 user license for that user.
- Both license types are used in one session if an application task and a BI task are active at the same time.
License Example:
A company purchases ten standard Sage MAS 500 application user licenses and five Business Insights user licenses. Fifteen sessions can be started with active tasks, ten standard application tasks and five BI tasks
To determine how many MAS user licenses and BI user licenses are being used – run the following queries in SQL Server Query Analyzer
MAS 500 User License:
SELECT COUNT(*)
FROM master..sysprocesses WITH (NOLOCK)
WHERE program_name = 'Sage MAS 500/App' AND dbid = DB_ID()
MAS 500 BIE User License:
SELECT COUNT(*)
FROM master..sysprocesses WITH (NOLOCK)
WHERE program_name = 'Sage MAS 500/BI' AND dbid = DB_ID()
The number returned by these queries represents the total number of users in MAS 500 occupying a license.