Get All Licenses users with Specific location

Hi, Today I need to calculate how many user licenses were assigned to my location.

Normally we need to know Get-MsolUser cmdlet at first.

And to see get-msoluser properties in the office 365 environment, we can use Get-MsolUser | Get-Member | Out-GridView , it shows , but there are a lot users on office 365, you need to use Get-MsolUser -all | Get-Member | Out-GridView

GetMsolUser This case to get “Get-MsolUser” properties, I must use -all parameter, it shows below, Today I’ll  use “IsLicensed”, “UsageLocation”, “UserPrincipalName”


Let’s get license user with specific location , to export csv file with column.


LicensesUsers I just added where-object {$_.isLicensed -eq $true -and $_.UsageLocation -eq “KR”, it distinguished and filtering  nicely to csv file, there are other options to use ExportCsv outer than for statement, but this is more easy to read document even if it takes time .


If you check cmdlet properties , you can use “Get-Member” cmdlet, and in this case , check your license user counts, and please check get-msoluser properties to get results more filtering to csv file.



글쓴이: hongwoo jin

I'm managing our Korea company's Office 365 administrator I want to be MS Office 365 & SharePoint MVP with certification.

답글 남기기

아래 항목을 채우거나 오른쪽 아이콘 중 하나를 클릭하여 로그 인 하세요: 로고

WordPress.com의 계정을 사용하여 댓글을 남깁니다. 로그아웃 /  변경 )

Google+ photo

Google+의 계정을 사용하여 댓글을 남깁니다. 로그아웃 /  변경 )

Twitter 사진

Twitter의 계정을 사용하여 댓글을 남깁니다. 로그아웃 /  변경 )

Facebook 사진

Facebook의 계정을 사용하여 댓글을 남깁니다. 로그아웃 /  변경 )


%s에 연결하는 중