UpdateImmutableID: Difference between revisions

From UmsWiki
Jump to navigation Jump to search
Rum (talk | contribs)
No edit summary
Rum (talk | contribs)
No edit summary
Line 1: Line 1:
- $usersTable = New-Object system.Data.DataTable “UsersTable”
-- $usersTable = New-Object system.Data.DataTable “UsersTable”


$column1 = New-Object System.Data.DataColumn userPrincipalName,
$column1 = New-Object System.Data.DataColumn userPrincipalName,

Revision as of 12:35, 24 June 2019

-- $usersTable = New-Object system.Data.DataTable “UsersTable”

$column1 = New-Object System.Data.DataColumn userPrincipalName,

([String])

$column2 = New-Object System.Data.DataColumn immutableId,

([String])

$usersTable.Columns.Add($column1)

$usersTable.Columns.Add($column2)

$users=Import-Csv -Path users.csv -Header “userSamAccountName”

foreach($user in $users)

{

$adUser = Get-ADUser -Identity $user.userSamAccountName

$adUserGuid = $adUser.ObjectGUID

$byteArray = $adUserGuid.ToByteArray()

$immutableId = “”

$immutableId = [system.convert]::ToBase64String($byteArray)

$row = $usersTable.NewRow()

$row.userPrincipalName = $adUser.userPrincipalName

$row.immutableId = $immutableId

$usersTable.Rows.Add($row)

}

$usersTable | Export-Csv “c:\Users\Inlogic\UserExportIds.csv”