Status Change

statuschange

$Past = Import-csv "Past 51.csv" | select Stig, Vkey, Status
$Current = import-csv "Current 51.csv" | select Stig, Vkey, Status

$AssignedNumbers = @()
ForEach ($key in $Past)
{
    $vkey = $key.vkey
    $stig =$key.stig
    $status = $key.status

    $Keymatch = $Current| where {$_.vkey -eq $vkey}
    $statusdifference = $current | where {$_.status -eq $status}
    $currentstatus = $Current | where {$_.status} | select status

   If($Keymatch -ne $statusdifference)
   {
         #Process the data
        $AssignedNumbers += New-Object PsObject -Property @{STIG=$stig;Vkey =$Vkey;Status =$currentstatus}
    }

}

$AssignedNumbers | select "stig","vkey","status"