检查ADusers属性export-csv并包含null

Question

我有一个手机号码列表，我想尝试将广告用户与之匹配，然后导出为csv。

目前的脚本工作到目前为止，但我希望它包括一行，当它没有找到一个用户，这表明它没有匹配的手机号码。

$ou="OU=User Accounts,OU=Users,OU=Company,DC=dc01,DC=local"

get-content chk_usr_mobile.csv | 
ForEach {
$aduser=get-aduser -SearchBase $ou -filter{(mobile -eq $_)} -Properties *|
select -Property company,emailaddress,@{L='departmentnumber'; E={$_.departmentnumber[0]}}, mobile,givenname,sn
if ($aduser -eq $null){
$aduser=$_
}
else{
$aduser}
} | export-csv .\tel_result.csv -encoding UTF8 -notypeinformation 

所以我想要的输出在csv中应该是这样的：

"company","emailaddress","departmentnumber","mobile","givenname","sn"
"Company","user1g@company.com","123","123456789","Joe","Doe"
"no user found for number 98765431"
"Company","user2g@company.com","124","456789123","Jane","Doe"

Answer 1

从您的代码判断，输入的CSV文件根本不是CSV文件，而是一个文本文件，每个文件的电话号码都在单独的一行上。

为了不破坏输出CSV，我建议您执行以下操作：

$ou="OU=User Accounts,OU=Users,OU=Company,DC=dc01,DC=local"
Get-Content chk_usr_mobile.csv | ForEach-Object {
    $aduser = Get-ADUser -SearchBase $ou -Filter { mobile -eq $_ } -Properties Company,EmailAddress,departmentnumber,Mobile,GivenName,Surname
    if ($aduser) {
        $aduser | Select-Object Company,EmailAddress,@{L='DepartmentNumber'; E={$_.departmentnumber[0]}},Mobile,GivenName,Surname
    }
    else {
        [PSCustomObject]@{
            Company = 'no user found for number {0}' -f $_
            EmailAddress = ''
            DepartmentNumber = ''
            Mobile = ''
            GivenName = ''
            Surname = ''
        }
    }
} | Export-Csv .\tel_result.csv -Encoding UTF8 -NoTypeInformation -Force