Office 365 License Reporting

[Himanshu Singh]

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..

[#2]

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, Chris

[#3]

@Christopher Hoard 

I 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

[#4]

Of course it's possible.

You can use articles such as the one below to create your own script

https://docs.microsoft.com/en-us/office365/enterprise/powershell/view-account-license-and-service-de...

https://docs.microsoft.com/en-us/office365/enterprise/powershell/view-licenses-and-services-with-off...

Or wait and see if someone already has one or has the time to create one.

@Vasil Michev @adam deltinger - would you have ever come across a script which can provide this?

Best, Chris

[#5]

@Himanshu Singh 

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-079add3a

This 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.

[#6]

@Robert Luck 

Here the challenge  many companies wont allow the graph  api as it is reading user profile info  or requesting to  approve it.

without ms graph  and  input the user upn name   it should give lic assigment info

Thanks

Muthu

[#7]

@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

[#8]

@valHighlight how does function work ?

[#9]

@Himanshu Singh 

May worth to refer this:

https://www.syskit.com/blog/office-365-license-reporting-guide/

[#10]

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/