Forum Discussion
Office 365 License Reporting
This is not that straight forward, may be Microsoft is assuming any applied license has all services enabled in it,
Which cannot be true everytime,
I have following requirement to prepare a report showing
user name
user email
user location
user license info for each service enabled for e.g.
username user-email location license
user1@corp.com firstname.lastname@corp.com country/code E3-Teams,E3-Onedrive,E5-Exchange etc..
9 Replies
- Maybe this might help? It's a PowerShell script written using the Microsoft Graph PowerShell SDK and reports licenses assigned to users together with the costs of the licenses:
https://office365itpros.com/2024/02/14/microsoft-365-licensing-report/ - @valHighlight how does function work ?
Himanshu Singh you could try https://infrasos.com/office-365-reporting/office-365-license-report/
Allows you to get a detailed report on which Office 365 has been enabled / provisioned for each user with a license
Hi!
This could be a possibility
https://gallery.technet.microsoft.com/office/Office-365-Reporting-Tool-7987b4c2
If that doesn’t cover it then it’s either a third party reporting tool or Powershell.
Hope that answers your question!
Best, ChrisI know and have this one, i dont understand this is not a free tool either,
please stop sharing this link with respect to licensing,
I am looking for Powershell way to accomplish this which i believe should be possible..
BR,
/HS
Solving our requirements with PowerShell always gives us a great accomplishment feel. Please try the below script which will list licensed users along with enabled service and its License subscription name.
https://gallery.technet.microsoft.com/Export-Office-365-User-079add3aThis script will provide 2 output file. Please check the "Simple Office 365 Users License Report" file to solve your requirement.If you need any modifications, let me know. I am happy to help you.
