M365 powershell script uses a lot of memory

Question

To export information to one file (csv), I know that I shouldn't refer to multiple DBs. Because that action crashes memory.
(Get-azureaduser, get-mailbox, get-mailboxstatistics etc.)

So, pelase teach me...
Please tell me how to improve.....

powershell version is the latest version.
Basically, how to write a script is as follows.
Invoke-Command -ScriptBlock {get-azureaduser |% {get- ........ $data += [pscustomobject]........... ]}}

Is there a best way to write or a service that should be stopped?
My environment can't install IDE, so I only use PowerShell ISE...........

Answer 1

Try clearing variables that contain many objects when you are done with them. See if that makes a difference.

Instead if this....

get-azureaduser |% {get- ........}

Do this...

$AllUsers = get-azureaduser 
foreach ($User in $AllUSers) {get- ........}
Remove-Variable $AllUsers 

Answer 2

Why are you using Invoke-Command?

What is taking all the memory is the variable "$data". You're loading that with a PSCustomObject for each user.

If you run the Get-AzureUser locally and use the pipeline things will probably work faster and use less memory Maybe something like this:

get-azureaduser |  # sends one user object into the pipe at a time
    foreach-object{
        get- ........ 
        [pscustomobject]........... ]    # emits one PSCustomObject into the pipe at a time
    } | # continue with export-csv????