import-module ActiveDirectory
$LogFile="c:\RMUnifyDuplicates\RMCom2000Duplicates.txt"
$NewLogFile = new-item $LogFile -type file -force #Create folder and file anew
$allusers= get-aduser -filter * -properties  rmCom2000-UsrMgr-uPN | where {$_."rmCom2000-UsrMgr-uPN" -ne $null} | select userprincipalname, samaccountname, firstname, lastname, rmCom2000-UsrMgr-uPN 

$AllRMComs = $allusers.'rmCom2000-usrmgr-upn' #Extract RMCom values 
$RMComStatistics=$AllRMComs | foreach-object -begin {$countRMComs=@{}} -process {$countRMComs.$_++} -end {$countRMComs} #Count RMCom2000 occurrences
$DuplicateRMComs=$RMComStatistics.GetEnumerator() | where value -gt 1 #List RMCom duplicates
$DuplicateUsers=$allusers | where {$_."rmCom2000-UsrMgr-uPN" -in $DuplicateRMComs.name} #List of Duplicate Users

##Output Duplicate Users to Screen 

$DuplicateUsers | Select UserPrincipalName,rmCom2000-UsrMgr-uPN

## Write Duplicate Users to Log File
foreach ($duplicate in $DuplicateUsers)
{
Add-Content -Path $Logfile "$($Duplicate.UserPrincipalName),$($Duplicate.SamAccountName),$($Duplicate.FirstName),$($Duplicate.LastName),$($Duplicate.'rmCom2000-UsrMgr-uPN')"
}
#Add a line if no duplicates have been found
If
((get-content $LogFile) -eq $NULL) {write-output "No duplicates found"}
else
{ Write-Output "*** User list saved to $LogFile ***" }