This is my current code which isn't doing what I want.

$UserList = get-content C:\Users\*****\Desktop\UserList\UserList.csv
$yesEmail = @()
$allUsers = Get-ADUser -Filter * -Properties `
GivenName,Surname,SamAccountName,Name,EmailAddress | ?{ $_.Enabled -eq $true } | `
Select GivenName,Surname,SamAccountName,Name,EmailAddress

    foreach ($u in $allUsers){
        if ($UserList -notcontains $u.EmailAddress){
            $yesEmail += New-Object PSObject -Property @{
                GivenName = $u.GivenName
                Surname = $u.Surname
                DisplayName = $u.Name
                samAccountName = $u.SamAccountName
                EmailAddress = $u.EmailAddress
                }
            }
        }
$yesEmail | Select GivenName,Surname,SamAccountName,Name,EmailAddress | `
Export-Csv C:\Users\*****\Desktop\UserList\Difference.csv

UserList.csv is a list of email addresses.
I want to compare them to all users in AD and compile of list of users that aren't in UserList.

Thanks for any help.
-Judical

On $userlist you could try import-csv instead of get-content. And maby try -notmatch instead of -notcontains.

 Edit: jrv is correct, I missed reading the 2 last sentences.

• Edited by Viktor Lindström 9 hours 35 minutes ago

On $userlist you could try import-csv instead of get-content. And maby try -notmatch instead of -notcontains.

 Edit: jrv is correct, I missed reading the 2 last sentences.

• Edited by Viktor Lindström 9 hours 27 minutes ago

In this case "notcontains" is correct.

Is "userlist" a single column of email addresses?

If the above is true try this and post the exact errors.

$UserList=Get-Content C:\Users\*****\Desktop\UserList\UserList.csv
Get-ADUser -Filter {Enabled -eq $true} -Properties GivenName,Surname,SamAccountName,Name,EmailAddress|
	Where-Object{$UserList -notcontains $_.EmailAddress}|
 	select GivenName,Surname,SamAccountName,Name,EmailAddress |
 	Export-Csv C:\Users\*****\Desktop\UserList\Difference.csv 

On $userlist you could try import-csv instead of get-content. And maby try -notmatch instead of -notcontains.

 Edit: jrv is correct, I missed reading the 2 last sentences.

• Edited by Viktor Lindström Friday, August 21, 2015 9:34 PM

This works, thank you very much.
Not being a guru could you tell how I could use a document that has many columns one of which being email addresses?

-Judical

Use Import-Csv instead of Get-Content.

http://ss64.com/ps/import-csv.html

Would it look like this?

$UserList=(Import-Csv "C:\Users\****\Desktop\UserList\UserReport.csv")."Email Address"

Sure.

More help if you don't mind.
I am now trying to filter out results that do not have an employee number.

This is my current script;

$UserList=(Import-Csv "C:\Users\****\Desktop\UserList\UserReport.csv")."Employee Number"
Get-ADUser -Filter {Enabled -eq $true} -Properties EmployeeNumber,SamAccountName,Name,EmailAddress|
Where-Object{$UserList -notcontains $_.EmployeeNumber}|
  select EmployeeNumber,SamAccountName,Name,EmailAddress |
  Export-Csv C:\Users\****\Desktop\UserList\DifferenceNEW.csv

I assume the code i'm looking for is this | where {$_."EmployeeNumber" -ne ""}
However I am not sure where how or where to add it to the script.

-Judical

More help if you don't mind.
I am now trying to filter out results that do not have an employee number.

This is my current script;

$UserList=(Import-Csv "C:\Users\****\Desktop\UserList\UserReport.csv")."Employee Number"
Get-ADUser -Filter {Enabled -eq $true} -Properties EmployeeNumber,SamAccountName,Name,EmailAddress|
Where-Object{$UserList -notcontains $_.EmployeeNumber}|
  select EmployeeNumber,SamAccountName,Name,EmailAddress |
  Export-Csv C:\Users\****\Desktop\UserList\DifferenceNEW.csv

I assume the code i'm looking for is this | where {$_."EmployeeNumber" -ne ""}
However I am not sure where how or where to add it to the script.

-Judical

get-aduser -properties employeenumber -Filter {employeenumber -notlike "*"}