CLM License stats

Good morning Jazzers,

We want to do license stats on a much finer level.

The scenario:

Users are members of multiple projects in CCM, RM and QM. We want to have the functionality to get license stats for licenses issued to users on a specific project. The current license stats gives us licenses per user.

Iknow it's possible to create scripts to query tables in relevant databases to build up the information of such stats that will be populated in another database.

Can someone please give me an indication of the tables we'd have to run the query against to compile such information?

Any help will be appreciated.

Regards

Johan