Office 365 License Reporting

%3CLINGO-SUB%20id%3D%22lingo-sub-713267%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20License%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713267%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F169605%22%20target%3D%22_blank%22%3E%40Christopher%20Hoard%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20know%20and%20have%20this%20one%2C%20i%20dont%20understand%20this%20is%20not%20a%20free%20tool%20either%2C%3C%2FP%3E%3CP%3Eplease%20stop%20sharing%20this%20link%20with%20respect%20to%20licensing%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20Powershell%20way%20to%20accomplish%20this%20which%20i%20believe%20should%20be%20possible..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBR%2C%3C%2FP%3E%3CP%3E%2FHS%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713088%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20License%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713088%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EThis%20could%20be%20a%20possibility%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FOffice-365-Reporting-Tool-7987b4c2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgallery.technet.microsoft.com%2Foffice%2FOffice-365-Reporting-Tool-7987b4c2%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20that%20doesn%E2%80%99t%20cover%20it%20then%20it%E2%80%99s%20either%20a%20third%20party%20reporting%20tool%20or%20Powershell.%3CBR%20%2F%3E%3CBR%20%2F%3EHope%20that%20answers%20your%20question!%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713381%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20License%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713381%22%20slang%3D%22en-US%22%3EOf%20course%20it's%20possible.%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20use%20articles%20such%20as%20the%20one%20below%20to%20create%20your%20own%20script%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fenterprise%2Fpowershell%2Fview-account-license-and-service-details-with-office-365-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fenterprise%2Fpowershell%2Fview-account-license-and-service-details-with-office-365-powershell%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fenterprise%2Fpowershell%2Fview-licenses-and-services-with-office-365-powershell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Foffice365%2Fenterprise%2Fpowershell%2Fview-licenses-and-services-with-office-365-powershell%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EOr%20wait%20and%20see%20if%20someone%20already%20has%20one%20or%20has%20the%20time%20to%20create%20one.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58%22%20target%3D%22_blank%22%3E%40Vasil%20Michev%3C%2FA%3E%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F72542%22%20target%3D%22_blank%22%3E%40adam%20deltinger%3C%2FA%3E%20-%20would%20you%20have%20ever%20come%20across%20a%20script%20which%20can%20provide%20this%3F%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%20Chris%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-712823%22%20slang%3D%22en-US%22%3EOffice%20365%20License%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-712823%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20is%20not%20that%20straight%20forward%2C%20may%20be%20Microsoft%20is%20assuming%20any%20applied%20license%20has%20all%20services%20enabled%20in%20it%2C%3C%2FP%3E%3CP%3EWhich%20cannot%20be%20true%20everytime%2C%3C%2FP%3E%3CP%3EI%20have%20following%20requirement%20to%20prepare%20a%20report%20showing%3C%2FP%3E%3CP%3Euser%20name%3C%2FP%3E%3CP%3Euser%20email%3C%2FP%3E%3CP%3Euser%20location%3C%2FP%3E%3CP%3Euser%20license%20info%20for%20each%20service%20enabled%20for%20e.g.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eusername%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Buser-email%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Blocation%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Blicense%3C%2FP%3E%3CP%3Euser1%40corp.com%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3Bfirstname.lastname%40corp.com%26nbsp%3B%20%26nbsp%3B%20country%2Fcode%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20E3-Teams%2CE3-Onedrive%2CE5-Exchange%20etc..%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-712823%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%20License%20Reporting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-713467%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%20License%20Reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-713467%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F45912%22%20target%3D%22_blank%22%3E%40Himanshu%20Singh%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESolving%20our%20requirements%20with%20PowerShell%20always%20gives%20us%20a%20great%20accomplishment%20feel.%20Please%20try%20the%20below%20script%26nbsp%3Bwhich%20will%20list%20licensed%20users%20along%20with%20enabled%20service%20and%20its%20License%20subscription%20name.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20title%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2Fexport-office-365-user-079add3a%22%20href%3D%22https%3A%2F%2Fgallery.technet.microsoft.com%2FExport-Office-365-User-079add3a%22%20target%3D%22_blank%22%20rel%3D%22noreferrer%20noopener%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgallery.technet.microsoft.com%2FExport-Office-365-User-079add3a%3C%2FA%3E%3C%2FP%3E%3CDIV%3E%3CBR%20%2F%3E%3CDIV%3EThis%20script%20will%20provide%202%20output%20file.%20Please%20check%20the%20%22Simple%20Office%20365%20Users%20License%20Report%22%20file%20to%20solve%20your%20requirement.%3C%2FDIV%3E%3CDIV%3E%3CBR%20%2F%3E%3CDIV%3E%3CDIV%3E%3CDIV%3EIf%20you%20need%20any%20modifications%2C%20let%20me%20know.%20I%20am%20happy%20to%20help%20you.%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

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

 

 

4 Replies
Highlighted

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

Highlighted

@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

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

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