Get-AzADUser : Why it is showing "System out of memory" error after executing Get-AzADUser command ? | Powershell Command for all the AzADUser list using -SearchString in CSV file format | How to get all the AzADUser in single CSV file format ?

Get-AzADUser : Why it is showing "System out of memory" error after executing Get-AzADUser command ? | Powershell Command for all the AzADUser list using -SearchString in CSV file format | How to get multiple CSV files of the AzADUser in single CSV file format ? 

Hi,

Are you trying to find a powershell command to get the all users list?

And you are getting the error while executing Get-AzADUser command ?

Get-AzADUser | select UserPrincipalName, ObjectType, UsageLocation, GivenName

Are you getting a "System out Memory Exception" error message ??

Why it is showing "System out of memory" error after executing Get-AzADUser command ?

Here, let me tell you that what would the possible reason of getting the error like this.

According to me , this error is showing because the user list/user data must be very big , or in a large number.

What to do if Get-AzADUser showing "System out of memory" error ?

To get the az ad user list , you can use Get-AzADUser -First command to get the user list i.e., -First 100.

How to use Get-AzADUser -First without error ?

Reference Get-AzADUser | Microsoft Docs

So, you can use the Get-AzADUser -First to get the output without any error.

-First

e.g. -First <UInt64>. 

Get-AzADUser -First 10 | select UserPrincipalName, ObjectType

The above Get-AzADUser -First command will give you the only some first users which you want . 

But if want to list the all users then you can use an alternate method which is mentioned below.

Powershell Command for all the AzADUser list using Get-AzADUser -SearchString in CSV file format

Use the below commands to filter the AzAD Users Alphabetically and save them in csv file format. (Repeat the command for alphabet A to Z)

- Get-AzADUser -SearchString A | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserAfile.csv -NoTypeInformation
- Get-AzADUser -SearchString B | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserBfile.csv -NoTypeInformation
- Get-AzADUser -SearchString C | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserCfile.csv -NoTypeInformation
- Get-AzADUser -SearchString D | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserDfile.csv -NoTypeInformation
- Get-AzADUser -SearchString E | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserEfile.csv -NoTypeInformation
- Get-AzADUser -SearchString F | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserFfile.csv -NoTypeInformation
- Get-AzADUser -SearchString G | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserGfile.csv -NoTypeInformation
- Get-AzADUser -SearchString H | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserHfile.csv -NoTypeInformation
- Get-AzADUser -SearchString I | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserIfile.csv -NoTypeInformation
- Get-AzADUser -SearchString J | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserJfile.csv -NoTypeInformation
- Get-AzADUser -SearchString K | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserKfile.csv -NoTypeInformation
- Get-AzADUser -SearchString L | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserLfile.csv -NoTypeInformation
- Get-AzADUser -SearchString M | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserMfile.csv -NoTypeInformation
- Get-AzADUser -SearchString N | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserNfile.csv -NoTypeInformation
- Get-AzADUser -SearchString O | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserOfile.csv -NoTypeInformation
- Get-AzADUser -SearchString P | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserPfile.csv -NoTypeInformation
- Get-AzADUser -SearchString Q | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserQfile.csv -NoTypeInformation
- Get-AzADUser -SearchString R | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserRfile.csv -NoTypeInformation
- Get-AzADUser -SearchString S | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserSfile.csv -NoTypeInformation
- Get-AzADUser -SearchString T | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserTfile.csv -NoTypeInformation
- Get-AzADUser -SearchString U | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserUfile.csv -NoTypeInformation
- Get-AzADUser -SearchString V | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserVfile.csv -NoTypeInformation
- Get-AzADUser -SearchString W | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserWfile.csv -NoTypeInformation
- Get-AzADUser -SearchString X | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserXfile.csv -NoTypeInformation
- Get-AzADUser -SearchString Y | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserYfile.csv -NoTypeInformation
- Get-AzADUser -SearchString Z | select UserPrincipalName, ObjectType, UsageLocation, GivenName, Surname, DisplayName, Id, Type | Export-Csv -Path .\UserZfile.csv -NoTypeInformation

How to get multiple CSV files of the AzADUser in single CSV file format ?

To combine the all csv files present in the directory , you can use the below command.

Note: Change the location of the file where the all csv file are present and also the location of the final file where you want to combine all the files.

$getFirstLine = $true

get-childItem "C:\Users\STARtube\*.csv" | foreach {
 $filePath = $_

 $lines = Get-Content $filePath
 $linesToWrite = switch($getFirstLine) {
        $true  {$lines}
        $false {$lines | Select -Skip 1}

 }

 $getFirstLine = $false
 Add-Content "C:\Users\STARtube\final.csv" $linesToWrite
 }

To get the output of all the Az AD Users list , Import the final csv file.

 Import-Csv -Path .\final.csv

az ad user list CLI command error : Why it is showing error after executing az ad user list command ? What to do if az ad user list showing error ? How to use az ad user list filter without error ?

C:\Users\startube>az ad user list
The command failed with an unexpected error. Here is the traceback:

Traceback (most recent call last):
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 237, in invoke

File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/output.py", line 146, in out
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/output.py", line 37, in format_json
File “json\__init__.py", line 234, in dumps
File “json\encoder.py", line 201, in encode
MemoryError
To open an issue, please run: ‘az feedback'

Hi,

Are you trying to find a command for az ad user to get the all users list?

And you are getting the error while executing az ad user list command ?

az ad user list 

So, are you also getting the same error something like this ?

C:\Users\startube>az ad user list
The command failed with an unexpected error. Here is the traceback:

Traceback (most recent call last):
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/cli.py", line 237, in invoke

File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/output.py", line 146, in out
File "D:\a\1\s\build_scripts\windows\artifacts\cli\Lib\site-packages\knack/output.py", line 37, in format_json
File “json\__init__.py", line 234, in dumps
File “json\encoder.py", line 201, in encode
MemoryError
To open an issue, please run: ‘az feedback'

Why it is showing error after executing az ad user list command ?

Here, let me tell you that what would the possible reason of getting the error like this.

According to me , this error is showing because the user list/user data must be very big , or in a large number.

What to do if az ad user list showing error ?

To get the az ad user list , you can use az ad user list --filter command to get the user list i.e., --filter "displayname eq 'test' and servicePrincipalType eq 'Application'".

How to use az ad user list --filter without error ?

Reference az ad user | Microsoft Docs

So, you can use the az ad user list --filter to get the output without any error.

--filter

e.g. --filter "displayname eq 'test' and servicePrincipalType eq 'Application'". 

Explanation : Here it will filter the displayname and servicePrincipalType which is equal to the 'test' and 'Application'. You have to just give the properties from which you want to filter the query.

• --filter

az ad user list --filter "displayname eq 'STAR tube'" --query "[].{UPN:userPrincipalName}" -o table

From the above command you can filter the big data of user list and by using --query you can get the output for any particular properties of the users.