Powershell将AD缩略图导出到数据库

Import-Module ActiveDirectory
$users = Get-ADUser -Filter * -Properties thumbnailPhoto

$connectionString = "Data Source=数据库地址;Initial Catalog=数据库名称;User ID=用户名;Password=密码"
$connection = New-Object System.Data.SqlClient.SqlConnection($connectionString)
$connection.Open()

$command = $connection.CreateCommand()
$command.CommandText = "CREATE TABLE UserThumbnails (Username VARCHAR(50), Thumbnail VARBINARY(MAX))"
$command.ExecuteNonQuery()

foreach ($user in $users) {
    $username = $user.SamAccountName
    $thumbnail = $user.thumbnailPhoto

    $command.CommandText = "INSERT INTO UserThumbnails (Username, Thumbnail) VALUES ('$username', @thumbnail)"
    $command.Parameters.AddWithValue("@thumbnail", $thumbnail)
    $command.ExecuteNonQuery()
}

$connection.Close()