Source of BitBucket license data

[Luke James]

I am trying to find the source of the following data retrieved via the following the REST endpoint rest/api/1.0/admin/license? using GET. I want to be able to sql query this rather than the REST resource.

currentNumberOfUsers = ??

maximumNumberOfUsers = ??

 Can anyone offer up anything?

[Nic Brough -Adaptavist-]

Stick to REST queries, they're far more easy.

If you must do it with SQL, then you need to read the cwd tables.  I think it's app_dir ones to work out what groups have access to stash, then the cwd_membership table to get a list of users in those groups, then cwd_user to check each user for their "enabled" flag.

Then for maximum users, you can't, as the licence is handled by data read from files on the disk and processed without the database. 

[Luke James]

Thank you Nic, its not quite matching up with my figures. What if I need to know more about each table, is there an online resource for this information?