Query to see which SAP user has the Professional license assigned

[Former Member]

I know the licences are not stored in any table.

But the license assignment should be in an SAP table.

I have multiple users that sometimes I want to see which one of them has the professional license assigned.

Is there a query to do that

thanks in advance

[edy_simon]

Hi Vasili,

License assignment is not stored in the table also.

Have a look at the file in your server

(InstallationFolder)\SAP\SAP Business One ServerTools\License\B1Upf.xml

This file contains the license assignment.

Regards

Edy

[Former Member]

Hi All,

Or the License Server API...

Regards,

Eric

[Former Member]

AFAIK This is not available to view in the SQL database whatsoever, it's only viewable/alterable through the administration console. I suspect it's due to the sensitive nature of the contents that it's not stored in the SQL database.