Office 365 users information

The following PowerShell script will extract Office 365 info with MFA status. I didn't write it, I just use it. There is a URL in the comments to the page that I found it on. It will export to CSV and PowerBI can then consume it.

 

###############################################################
#################################################  
# This script accepts 1 parameter from command console
#  
# OutputFile  - Optional - File path to save the Output CSV file

# To run the script  
#  
# .\export_office_365_users_mfa_status.ps1  -OutputFile "C:\Reports\o365-users-mfa-status.csv"
#  
# NOTE: If you don't pass an output file path, it will save the output file in your powershell working directory (".\office-365-users-without-photo.csv").
#  
# Author:                      https://www.morgantechspace.com  
# Version:                     1.0  
# Last Modified Date:    14/06/2018 
# Last Modified By:        Morgan  
###############################################################
#################################################  

Connect-MsolService
  
#Accept input parameters  
Param(  
    [Parameter(Position=1, Mandatory=$false, ValueFromPipeline=$true)]  
    [string] $OutputFile 
)  
  
#Set default output file path if not passed.
if ([string]::IsNullOrEmpty($OutputFile) -eq $true) 
{ 
    $OutputFile = ".\o365-users-mfa-status.csv"      
}

$Result=@() 
$users = Get-MsolUser -All
$users | ForEach-Object {
$user = $_
if ($user.StrongAuthenticationRequirements.State -ne $null){
$mfaStatus = $user.StrongAuthenticationRequirements.State
}else{
$mfaStatus = "Disabled" }

$Result += New-Object PSObject -property @{ 
UserName = $user.DisplayName
UserPrincipalName = $user.UserPrincipalName
MFAStatus = $mfaStatus
}
}
#Export user details to CSV.
$Result | Export-CSV $OutputFile -NoTypeInformation -Encoding UTF8
Write-Host "Report exported successfully" -ForegroundColor Yellow