License type Custom Properties

[E_Langlet]

Hi!

I wounder if it is possible to extract the allocated license type from each user from custom properties? 

I want to list each user and their allocated custom property license in a table. 

[Jack_Guo]

Hi @E_Langlet ,

You may get this info from the repository database but not recommended to work against the repo database.

In the QSR database, you may find CustomPropertyValues table, Field Value shows the custom property value, Field user_id shows the related user id. Join with the table Users.user id and you will know the username who has been assigned to this custom property value.

I hope this helps.