Update User properties in Active Directory from CSV

 

1. Import-Module ActiveDirectory
3. $USERS = Import-CSV c:\users.csv
5. $USERS | foreach {
7. $empid=$_.employeeid
8. $company=$_.company
9. $title=$_.title
10. $department=$_.department
11. $Division=$_.division
12. $pobox=$_.pobox
13. $city=$_.city
15. Set-ADUSer -Identity $_.samaccountname -Replace @{employeeID=$empid; company=$company; title=$title; department=$department; division=$division; postofficebox=$pobox; l=$City}
16. }

=====================================================================================================

Import-Module ActiveDirectory

$USERS = Import-CSV c:\users.csv

$empid=$USERS.employeeid
$company=$USERS.company
$title=$USERS.title
$department=$USERS.department
$Division=$USERS.division
$pobox=$USERS.pobox
$city=$USERS.city
$acc=$USERS.samaccountname

ForEach ($user in $USERS) {
Get-ADUser -Filter "samaccountname -eq '$Acc'" | Foreach {
Set-ADUser $ -Replace @{title = $title}
Set-ADUser $ -Replace @{company = $company}
Set-ADUser $ -Replace @{department = $department}
Set-ADUser $ -Add @{division = $division}
Set-ADUser $ -Replace @{postOfficeBox = $pobox}
Set-ADUser $ -Replace @{l = $city}
Set-ADUser $_ -Replace @{employeeid = $empid}
}
}

Create an ICON in system Tray

 #Create an ICON in system tray

Param

 (

[String]$Restart

 )

Hostname to IP address

 $location = Read-Host "CSV Path: "

$Names = Import-Csv -Path $location

foreach($n in $Names)

{

    try {

        $Computer = [system.net.dns]::resolve($n.NAME) | Select HostName,AddressList 

        $IP = ($Computer.AddressList).IPAddressToString

        New-Object PSObject -Property @{IPAddress=$IP; Name=$Computer.HostName} | Export-Csv \\filepath\Working.csv -NoTypeInformation -Append

    } catch {

        Write-Host "$($n.NAME) is unreachable."

        Write-Output $n | Export-Csv \\Filepath\Unreachable.csv -Append -Encoding ASCII

    }

}