I can see the total figure under the platform analytics page however want to find who the users are and also how they are broken down into the different apps we have.
O11
Hello.
In O11 you can check System Entities. Remember a single user can be in multiple apps and own multiple roles on each.
In summary, they look like this. (Espace = module).
It depends on what you need, but
Users JOIN User_Effective_Role ON User.id=User_Effective_Role.User_Id
User_Effective_Role JOIN Role ON Role.Id=User_Effective_Role.Role_Id
Role JOIN Espace ON Role.Espace_Id = Espace.Id
This way you can see for each user only the roles (given directly or through groups).
If you also want application, you just need to add a JOIN between Espace and Application.