Get user's data with license details

[VinayC]

Hi, 

I have to create a single report which will have data like Users details (Name, Manager Name, Assignment group, etc.) and his subscription with which module.

To achieve this I have created a database view with table sys_user and sys_user_has_license which is returning all record, now I am not able to apply filter on column subscription/ProductCodes to get only CSM users detail.

Highly appreciated for your response.

Regards,

Vinay Chaurasia

[Mark Manders]

Can you share what you did with your database view?

And why not use the OOB subscription management module? If setup correctly, it just shows you who is using what license.

[VinayC]

Appreciate for your response, but now I am able to fix the issue.

[Mark Manders]

In that case, can you close the question, or even better: share your solution so others can find it as well when they run into the same.

[arnoldha]

Hey @Mark Manders, are you sure about the last part? I've been trying to configure the Subscription Management dashboard but impossible to see who is using a license