Report Which O365 License each user has Based on office

Question

I need a report that will show what O365 Licenses each user has based on Office. If can emailed or with in reports

Comments

Hello,

What exactly do you mean by O365 Licenses each user has based on Office?

Could you, please, describe the desired report in all the possible details with a live example?

---

I company has many offices I wantto be able to seclect one and get a report that show User, Email, Title < & which Office365 licence they have if any at all

Answer 1

Hello,

Unfortunately, there is no possibility to create such a report because requesting licenses assigned to each user can take very long time. As a solution, you can create a Scheduled Task, that will save the list of licenses for each user into a property in their account and then create a report that will filter users by Office property value and display assigned licenses by taking them from the property updated by the script. To save licenses to a user account property, use the following script from our repository: https://www.adaxes.com/script-repository/save-assigned-office-365-licenses-to-active-directory-attribute-s459.htm.

For information on how to create reports, have a look at the following tutorial: https://www.adaxes.com/tutorials_ActiveDirectoryManagement_CreateReport.htm. Should you have issues creating the report, we will provide you with detailed instructions.