Monday, 1 February 2016

Office 365: Get-MsolUser

The Get-MsolUser cmdlet is an Azure AD powershell cmdlet. It can be used to get an individual user, or list of users information. An individual user will be retrieved if the ObjectId or UserPrincipalName parameter is used.

Note: Before proceed, Install and Configure Azure AD PowerShell

Retrieve single user:
Get-MsolUser -ObjectId <Guid>
-------------or---------------
Get-MsolUser -UserPrincipalName <UserPrincipalName>
Retrieve all users:
Get-MsolUser -All

Example 1

The following command retrieves all users in the company (up to 500 results).
Get-MsolUser

Example 2

The following command retrieves only first 100 users in the company.
Get-MsolUser -MaxResults 100

Example 3

The following command retrieves all the available users in the company.
Get-MsolUser -All

Example 4

The following command retrieves all the deleted users in the company.
Get-MsolUser -All -ReturnDeletedUsers

Example 5

The following command retrieves the user with the UPN morgan@mts.com
Get-MsolUser -UserPrincipalName morgan@mts.com

Example 6

The following command retrieves all the licensed users
Get-MsolUser -All | Where-Object { $_.isLicensed -eq "TRUE" }

Example 7

The following command retrieves and export all the licensed Office 365 users to csv file.
Get-MsolUser | Where-Object { $_.isLicensed -eq "TRUE" } | Select DisplayName,UserPrincipalName,IsLicensed |
Export-Csv c:\LicensedUsers.csv -NoTypeInformation

Example 8

The following command retrieves all users based on Department filter.
Get-MsolUser -All | Where { $_.Department -like "*Sales*" -or $_.Department -eq "Marketing" } |
Select DisplayName,UserPrincipalName,Department,IsLicensed

Example 9

The following command retrieves and export all the users with when they last changed their passwords in Office 365 to csv file.
Get-MsolUser -All | select DisplayName,UserPrincipalName, LastPasswordChangeTimeStamp | 
Export-CSV C:\LastPasswordChange_Report.csv -NoTypeInformation

Advertisements
Advertisements

No comments:

Post a Comment