Blocked Users

Question

I want a list or report of all my blocked users and export to csv.   Is this Possible

Answer 1

Hi Armandos,

Have you referred to the information above? Could you share any updates?

Regards,

Allan

Answer 2

Hi Armandos,

If the “blocked users” means sign-in blocked users, I suggest you run a PowerShell cmdlet to export them to a CSV file. Below are the detailed steps for your reference:

1. Install the Azure AD Module.
2. Run Windows Azure Active Directory Module for Windows PowerShell as administrator.
3. Run Connect-MsolService and enter your admin credentials.
4. Run the following command to export the sign-in blocked users to C:\Test\BlockedUsers.csv:

Get-MsolUser | where {$_.blockcredential -eq $true} | select UserPrincipalName,DisplayName,isLicensed | Export-CsvC:\Test\BlockedUsers.csv –NoTypeInformation

Please let me know whether this works from your side. If it doesn’t match your situation, please describe your requirement in more detail and we’ll follow up and assist you further.

Thanks,

Lingyu Sun

Answer 3

Work very good. Thanks