Export to CSV

spiceuser-kr31x · 2021-05-14T16:58:23.000Z

I’m working on a project to hide all disabled users from GAL. How can I get this command to export to a CSV file? Any help is appreciated.

Get-ADUser -Filter {(enabled -eq "false") -and (msExchHideFromAddressLists -notlike "*")}
-Properties enabled,msExchHideFromAddressLists

Neally · 2021-05-14T17:02:26.000Z

Welcome

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2021-05-14T17:07:09.000Z

in general avoid using backticks, look into splatting.

e.g.

$aduserinfo = @{
    Filter =  "(enabled -eq 'false') -and (msExchHideFromAddressLists -notlike '*')"
    Properties = 'msExchHideFromAddressLists'
}

Get-aduser @aduserinfo |
export-csv "file.csv" -NoTypeInformation

Evan7191 · 2021-05-14T17:10:38.000Z

You should be able to pipe the results to Export-Csv. For example:

Get-ADUser -Filter {(enabled -eq "false") -and (msExchHideFromAddressLists -notlike "*")} -Properties enabled,msExchHideFromAddressLists |
    Export-Csv -Path "Drive:\Folder\File.csv" -NoTypeInformation

Also, instead of using the backtick (`) as a line separator, consider using splatting. The backtick will cause an error if any character other than end-of-line follows it.

learn.microsoft.com

about Splatting - PowerShell

Describes how to use splatting to pass parameters to commands in PowerShell.