<div>
get-aduser -Filter {mail -like &quot;*&quot;} -Properties UserPrincipalName,mail,Dep<wbr />artment | select UserPrincipalName,mail,Dep<wbr />artment | where Department -like &quot;Logistics*&quot; | ft -a<br />
<br />
This should give you what you are looking for.<br />
<br />
Dan
</div>


get-aduser -Filter {mail -like "*"} -Properties UserPrincipalName,mail,Department | select UserPrincipalName,mail,Department | where Department -like "Logistics*" | ft -a

This should give you what you are looking for.

Dan

<div>
This is awesome, thank you! I should have added that I need to add the ability to export this to a csv, will a &quot;Export-Csv c:\ps_test\test.txt&quot; work?
</div>


This is awesome, thank you! I should have added that I need to add the ability to export this to a csv, will a "Export-Csv c:\ps_test\test.txt" work?

<div>
<div class="content wysiwyg-content">
Hi everyone,<br />
<br />
Very new to powershell and at this point I need to punt and just ask for the command here. What I have so far is:<br />
<br />
Get-ADUser -Filter * -Properties EmailAddress, Department | select EmailAddress, Department<br />
<br />
What I ultimately need to do is filter it to where Department = Logistics and so on and so forth.<br />
<br />
I really appreciate your help,<br />
Mike
</div>
</div>


Hi everyone,

Very new to powershell and at this point I need to punt and just ask for the command here. What I have so far is:

Get-ADUser -Filter * -Properties EmailAddress, Department | select EmailAddress, Department

What I ultimately need to do is filter it to where Department = Logistics and so on and so forth.

I really appreciate your help,
Mike

PowerShell script to display all email addresses where the department = X

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.