Where can I find information in the database about the licenses used?

0

Hi,
check the view [V_ADMIN_Licenses].

Regards,
Jacek

Hi Sławek,
I've been trying to find the place that gives same numbers as reports in designer studio, and after checking i think every table which could have it I've connected with Webcon via support.
There is and API endpoint which is used by Designer Studio to fetch info about used licenses: /studio/db/1/getsimplelicencereport, you can use the same endpoint.

1. Register API Application with any scope (Admin.Licenses.Read is suggested, but in that case it doesn't really matter).
2. Assing that API user Administrator Privileges on Studio
3. Login to the API via OAuth
4. Call /studio/db/1/getsimplelicencereport endpoint.

This will return you a json structure as in attached file.

It doesn't answer directly your question, as this is not in the database, but that's how you get same numbers as those displayed on reports tab in designer studio :)

Hi Slawek,

depending on what you want to achieve another option is to take a look at the
dbo.UsersCals
dbo.SingleSolutionCals

in the Config database.

The UsersCals contain the different license types.
I don't have in mind which integer value of the column UCL_LicenseType maps to which type.

Best regards,
Daniel