View difference between Paste ID: nr4Ave89 and vfbn5eQN

 Get-ADUser -Filter {(mail -ne "null") -and (Enabled -eq "true")} -Properties Surname,GivenName,mail | Select-Object Name,Surname,GivenName,mail | Format-Table
 # Active AD User Accounts with an email address.
 
 
-Get-ADUser -Filter * -Properties * | Sort-Object -Property Name | ForEach-Object {
+Get-ADUser -Filter * -Properties EmailAddress | where -Property EmailAddress -eq $null
-    $_ | Format-List -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,whenCreated,Enabled
+# AD User accounts without an Email Address.
-    $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
+
 
 Get-ADUser -Properties * -Filter {Enabled -eq 'True'} -SearchBase "OU=ExampleOU, DC=Domain, DC=com" | Select-Object @{Label = "Email";Expression = {$_.EmailAddress}}, @{Label = "First Name";Expression = {$_.GivenName}}, @{Label = "Last Name";Expression = {$_.Surname}}, @{Label = "Group";Expression = {($_.canonicalname -Split "/")[-2]}} | Export-Csv -Path users.csv -NoTypeInformation
-$alist = "Name`tAccountName`tDescription`tEmailAddress`tLastLogonDate`tManager`tTitle`tDepartment`tCompany`twhenCreated`tAcctEnabled`tGroups`n"
+# CSV of all enabled users that are contained in the OU with Distinguished Name “OU=ExampleOU, DC=Domain, DC=com”
-$userlist = Get-ADUser -Filter * -Properties * | Select-Object -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,Company,whenCreated,Enabled,MemberOf | Sort-Object -Property Name
+
-$userlist | ForEach-Object {
+
-    $grps = $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
+
-    $arec = $_.Name,$_.SamAccountName,$_.Description,$_.EmailAddress,$_LastLogonDate,$_.Manager,$_.Title,$_.Department,$_.Company,$_.whenCreated,$_.Enabled
+
-    $aline = ($arec -join "`t") + "`t" + ($grps -join "`t") + "`n"
+
-    $alist += $aline
+
-}
+
 Get-ADUser -Filter * -Properties * | Sort-Object -Property Name | ForEach-Object {
     $_ | Format-List -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,whenCreated,Enabled
     $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
 }  | ConvertTo-CSV
 
 $alist = "Name`tAccountName`tDescription`tEmailAddress`tLastLogonDate`tManager`tTitle`tDepartment`tCompany`twhenCreated`tAcctEnabled`tGroups`n"
 $userlist = Get-ADUser -Filter * -Properties * | Select-Object -Property Name,SamAccountName,Description,EmailAddress,LastLogonDate,Manager,Title,Department,Company,whenCreated,Enabled,MemberOf | Sort-Object -Property Name
 $userlist | ForEach-Object {
     $grps = $_.MemberOf | Get-ADGroup | ForEach-Object {$_.Name} | Sort-Object
     $arec = $_.Name,$_.SamAccountName,$_.Description,$_.EmailAddress,$_LastLogonDate,$_.Manager,$_.Title,$_.Department,$_.Company,$_.whenCreated,$_.Enabled
     $aline = ($arec -join "`t") + "`t" + ($grps -join "`t") + "`n"
     $alist += $aline
 }
 $alist | Out-File D:TempADUsers.csv
 
 csvde -f test.csv
 
 csvde -f test.csv
 
 csvde -f test.csv -r objectClass=user
 
 csvde -f test.csv -r objectClass=user -l DN, sAMAccountName, department, memberOf