Thank you for recommending "". Your recommendation has been successfully processed.
by Jasper Oosterveld on 11/24/2015
Date Revised: 11/24/2015
Applies to: Azure Active Directory Module for Windows PowerShell, Microsoft Online Services Sign-In Assistant for IT Professionals, Office 365, PowerShell
Recently for a client, I had to retrieve all the Office 365 users, including name and country, for one of our customers. I used PowerShell for this. Let’s take a look at my steps.
I installed the necessary tools: https://msdn.microsoft.com/en-us/library/azure/jj151815.aspx
First install the Microsoft Online Services Sign-In Assistant for IT Professionals RTW from the Microsoft Download Center. Then install the Azure Active Directory Module for Windows PowerShell (64-bit version), and click Run to run the installer package.
After that, I executed the following cmdlets:
$credential = get-credential
Connect-MsolService -Credential $credential
Get-MsolUser | Select-Object DisplayName, Country | Export-Csv C:\users.csv
You are now able to open the CSV in Excel and have you results ready. Nice :-). I am a PowerShell n00b but this was easy to do for me :-).
Note: You do need to be an Office 365 Global Administrator to connect through PowerShell.
You can find Jasper’s original post here: http://www.jasperoosterveld.com/2015/11/retrieve-users-including-names-and-country-from-office-365/
by Tony Redmond on Aug 01, 2016
Like any resource, Office 365 Groups can become unused over time. Microsoft doesn’t provide any method to find potentially obsolete groups, but some enthusiastic hacking with PowerShell to use Office...
by Eugene Dauphin on Dec 06, 2015
Use these two PowerShell scripts to help you work with multiple Office 365 tenants more efficiently. One script stores credentials for a tenant, the other connects to an Office 365 tenant with the...
by Jasper Oosterveld on Nov 24, 2015
Here's a simple PowerShell script for retrieving name and country from Office 365 and export to a .CSV file. You use Microsoft Online Services Sign-In Assistant for IT Professionals and Azure Active...
by Daniel Laskewitz on Nov 11, 2015
Daniel offers a PowerShell script to change properties in Office 365 Groups. Daniel's solution is based on a script from Wictor Wilen.
by Matthew McDermott on Oct 01, 2015
If you give a lot of demos, and in particular if you use the Microsoft Office demos, you'll find this PowerShell script for changing passwords very handy.
IT Unity revolutionizes the way technical content is
created, customized, and consumed. IT Unity empowers the community of trusted
experts, users, business decision makers, IT professionals, developers, and
industry solution providers to solve business problems with technology.
Innovation. Technology. Community