<div>
To run this report you need to open the Windows Azure Active Directory Module for Windows Powershell, and connect to Office 365. Once connected run the following cmdlet:<br />
<br />
Get-MSOLUser -All | select userprincipalname,islicens<wbr />ed,{$_.Lic<wbr />enses.Acco<wbr />untSkuId}|<wbr /> Export-CSV c:\userlist.csv -NoTypeInformation<br />
<br />
For more info<br />
<br />
<a href="https://mymicrosoftexchange.wordpress.com/2015/03/23/office-365-script-to-get-detailed-report-of-assigned-licenses/" rel="ugc">Office 365: Script to get detailed report of assigned licenses</a>
</div>


To run this report you need to open the Windows Azure Active Directory Module for Windows Powershell, and connect to Office 365. Once connected run the following cmdlet:

Get-MSOLUser -All | select userprincipalname,islicensed,{$_.Licenses.AccountSkuId}| Export-CSV c:\userlist.csv -NoTypeInformation

For more info

Office 365: Script to get detailed report of assigned licenses [https://mymicrosoftexchange.wordpress.com/2015/03/23/office-365-script-to-get-detailed-report-of-assigned-licenses/]

<div>
I think I tried something similar but mine only returns the license type but no license location (France/US/....).<br />
<br />
Let me try yours. &nbsp;Thx
</div>


I think I tried something similar but mine only returns the license type but no license location (France/US/....).

Let me try yours.  Thx

<div>
Not sure what you mean by license location. Perhaps the UsageLocation attribute?
</div>


Not sure what you mean by license location. Perhaps the UsageLocation attribute?

<div>
<div class="content wysiwyg-content">
Is it possible to have a PS command to read a CSV file (contains list of UPNs) and returns the product licenses LOCATION of each account?
</div>
</div>


Is it possible to have a PS command to read a CSV file (contains list of UPNs) and returns the product licenses LOCATION of each account?

Powershell script to return the Office 365 license location.

Office 365 is a group of software plus services subscriptions that provides productivity software and related services to its subscribers. Office 365 allows the use of Microsoft Office apps on Windows and OS X, provides storage space on Microsoft's cloud storage service OneDrive, and grants 60 Skype minutes per month. Office 365 includes e-mail and social networking services through hosted versions of Exchange Server, Skype for Business Server, SharePoint and Office Online, integration with Yammer, as well as access to the Office software. All of Office 365's components can be managed and configured through an online portal; users can be added manually, imported from a CSV file, or Office 365 can be set up for single sign-on with a local Active Directory using Active Directory Federation Services.

Microsoft 365

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.