How to show user license information on report

 Hi ,

We are going to learn how to show user license information in a report.

In Lightning Experience:

1. Click the gear icon, and click Setup
2. Enter Report Types in the Quick Find box, and select Report Types
3. Click New Custom Report Type
4. In the Primary Object field, select Users
5. Enter a Name, Label, Description, and Category for your new report type
6. Select a deployment status
7. Click Next, then Save
8. Click Edit Layout
9. Under the 'View' dropdown box, click the Add fields related via lookup link
10. Click Profile
11. Select User License, then click ‘view related fields’
12. Select Name, Status, and Total Licenses, then click OK
13. Click Save

Once the above steps are completed we can generate reports by using the above report type with report builder.

Reference: 

https://help.salesforce.com/s/articleView?id=000337772&type=1