Licenses allocation

0

Hi Klaus,
as far as I'm aware - there is currently no automatic assigning of licenses to new users - you'll have to handle it manually or attach it to some HR process probably (there is an action to manage users licenses) ;)

It's described in this post: https://community.webcon.com/posts/post/licenses-2026/598/3

Hi Klaus, Maks,

Since 2026.1.4 and new licensing model, CAL assignment cannot be fully automatic, due to the fact that now users can be granted different licenses (Core, Lite, Premium CALs).
However, license assignment can be semi-automated by using User Defined API. You can create a "self-service" dashboard with HTML widget, inside create a button that will invoke User Defined API endpoint and execute "Manage users licenses" action to assign a CAL to current user.
If a user doesn't have a license assigned, they can open such dashboard and grant themselves a license on their own, without admin intervention.
This solution has downsides of course, such as user not knowing what license they should get. It should work well if you only have Core Cals (or Unlimited Solutions Access in old licensing model).

Kind regards

Hi Maksymilian,

thanks for your reply. Looking at the post you mentioned I have one query:

"In practice, this means that it is now necessary to switch over to manual license assignment in the Admin Panel → User management → Users and licenses → Active users, or to implement a dedicated process using license management actions."

Is there a way to select the user IDs which are synchronized but without a license? Or clearly said: where in the database do I find the information regarding license assignment?
My thought is to create a workflow that is run by a timer twice a month that will assign the licence to all new users.

Kind regards
Klaus

Hi Klaus,
you could try to join information from two sources:
1. [BPS_Config].[dbo].[IdentityUsers] - this will give you a list of all synced users
2. /api/data/v7.0/admin/licenses - this will return you a list of all users with assigned licenses (I'm thinking about REST Data Source).

Then create a business rule, that would return you a JSON from api into SQL statement IdentityUsers, and join on IU_Email and bpsId from JSON.

You can work with JSON in SQL Server since 2016 version, so this should be possible.

If not in Webcon, this could be a simple powershell script in task scheduler too.

Hi Maksymilian,

the table [BPS_Config].[dbo].[IdentityUsers] is empty. (?!?)
I found the synced users in BPS_Content.CacheOrganizationStructure and the licences in the [BPS_Config].[dbo].[UsersCals]

With these two I guess I can create a query.

Thanks!

Ah, yeah, how could i forget about CacheOrganizationStructure - it's much better place.
On UserCals - I remember that there was i time where i've been getting different results in term of # of assigned licenses from this table vs a license report in Designer Studio, but it seems like after updates it's a good place too look.

May the workflow be with you ;)