sql - 导出 csv 返回十六进制结果

Question

当我尝试对 Active Directory 运行 SQL 查询的结果并将其导出到 CSV 文件时，我总是在每一行上得到一个十六进制结果，而不是我选择的属性。

SQL：

$qry = New-Object System.Data.SqlClient.SqlCommand("SELECT Name, IsCompliant,LatestEntry,ComputerManufacturerName,ComputerModelName,OperatingSystemName,MachinesUsersNames FROM ComplianceCore.MachinesComplianceView", $conn)
$adapter = New-Object System.Data.SqlClient.SqlDataAdapter $qry
$dataset = New-Object System.Data.DataSet
$adapter.Fill($dataset) | Out-Null

电源外壳：

get-adcomputer -filter * -properties CN, CanonicalName, IPv4Address | Where-Object { ($_.Name -notin $dataset.tables.name -and $_.CanonicalName -notlike "*Domain Contr*" -and $_.CanonicalName -notlike "*servers*" -and $_.CanonicalName -notlike "*Idle Computers*") } | Select-object  CN, CanonicalName, IPv4Address | Export-Csv -Path "C:\BAC\WSUSScripts\MBAM Compliance\NotConfiguredResult.csv"

结果：

标签： sqlpowershell