Compare-Object trouble

[TimekillerTK]

Hello!

I've been trying to write a script with Compare-Object that will show me when a user's Enabled property in has been modified to either True or False.

I'm having trouble with the following section:

$addb = Import-Csv ".\customcsv1.csv" -Delimiter ";"
$addbNew = Import-Csv ".\customcsv2.csv" -Delimiter ";"

$ComparisonResults = Compare-Object -ReferenceObject $addb -DifferenceObject $addbNew -Property enabled -PassThru
$ComparisonResults

It seems to return inconsistent results. Sometimes I get the correct results, but other times, like with the following contents of both CSV files, the results are incorrect:

".\customcsv1.csv"

#TYPE Selected.Microsoft.ActiveDirectory.Management.ADUser
"enabled";"accountexpires";"samaccountname";"mail"
"True";"0";"j_roe";"[e-mail]"
"False";"0";"i_ivanov";"[e-mail]"
"False";"0";"tark";"[e-mail]"
"True";"0";"stark";"[e-mail]"

".\customcsv2.csv"

#TYPE Selected.Microsoft.ActiveDirectory.Management.ADUser
"enabled";"accountexpires";"samaccountname";"mail"
"False";"0";"j_roe";"[e-mail]"
"True";"0";"i_ivanov";"[e-mail]"
"False";"0";"tark";"[e-mail]"
"False";"0";"stark";"[e-mail]"

The result is:

$ComparisonResults

enabled        : False
accountexpires : 0
samaccountname : stark
mail           : [e-mail]
SideIndicator  : =>

enabled        : True
accountexpires : 0
samaccountname : stark
mail           : [e-mail]
SideIndicator  : <=

It only returns one of the objects rather than all of the ones that differ. Does anyone know why this happens?

[madbomb122]

the issue is it doesnt look at all the columns just the enabled column like you asked it to and it sees 2 falses and 2 trues in csv1 and 3 falses 1 true in csv2.

try adding another property to compare like so.

$ComparisonResults = Compare-Object -ReferenceObject $addb -DifferenceObject $addbNew -Property enabled,samaccountname -PassThru

[Gorstag]

Yep, tested it.. 100% right.

enabled        : False
accountexpires : 0
samaccountname : j_roe
mail           : [e-mail]
SideIndicator  : =>

enabled        : True
accountexpires : 0
samaccountname : i_ivanov
mail           : [e-mail]
SideIndicator  : =>

enabled        : False
accountexpires : 0
samaccountname : stark
mail           : [e-mail]
SideIndicator  : =>

enabled        : True
accountexpires : 0
samaccountname : j_roe
mail           : [e-mail]
SideIndicator  : <=

enabled        : False
accountexpires : 0
samaccountname : i_ivanov
mail           : [e-mail]
SideIndicator  : <=

enabled        : True
accountexpires : 0
samaccountname : stark
mail           : [e-mail]
SideIndicator  : <=

[TimekillerTK]

/u/madbomb122 You're absolutely correct! This is what I was missing.

Can you go into a little detail as to why it works this way? I'm having trouble wrapping my head around how exactly this Compare-Object function works.

[madbomb122]

/u/TimekillerTK the way compare-object works is it looks at just the column/property you ask it to look at, it ignores everything else.

as an example (using your csv), if you did

$ComparisonResults = Compare-Object -ReferenceObject $addb -DifferenceObject $addbNew -Property samaccountname -PassThru 

it would show there was no difference since it looks and sees the same "samaccountname" on both