PS Script Help

rekin · 2018-09-11T16:15:47.000Z

Hi,

I have written a simple PS script which will pull user data such as samaccountname and emailaddress using first and last names pulled from a CSV file. The script is below:

Import-Module ActiveDirectory

$users = Import-CSV “locationofcsvfile”

foreach ($user in $users) {

$gname = $user.givenname
$sname = $user.surname

get-aduser -filter {givenname -eq $gname -and surname -eq $sname} -properties * | select samaccountname,emailaddress
}

The following errors appear when running the script:

error.png800×63 27.7 KB

Please tell me what I am missing…

Thanks!

shelly · 2018-09-11T16:22:17.000Z

What is the structure of your CSV file? Does its first row have titles? Can you post a small example - sanitized of course.

Neally · 2018-09-11T16:23:23.000Z

If you post code, please use the ‘Insert Code’ button. Please and thank you!

PLEASE READ BEFORE POSTING! Read if you're new to the PowerShell forum! Programming & Development

Hi, and welcome to the PowerShell forum! Don’t apologize for being a “noob” or “newbie” or “n00b.” There’s just no need – nobody will think you’re stupid, and the forums are all about asking questions. Just ask! Use a descriptive subject. Don't say "Need help" or "PowerShell Help", actually summarize what the problem is. It helps the rest of us keep track of which problem is which. Don’t post massive scripts. We’re all volunteers and we don’t have time to read all that, nor will we copy, past…

Neally · 2018-09-11T16:25:47.000Z

try like so, but as said, it depends on your CSV file.

Import-Module ActiveDirectory

$users = Import-CSV "c:\location\of\file.csv"

foreach ($user in $users) {

    $gname = $user.givenname
    $sname = $user.surname

    if ($gname -and $sname) {
        get-aduser -filter "givenname -eq '$gname' -and surname -eq '$sname'" -properties * | 
            select samaccountname, emailaddress
    }
    else {
        Write-Warning "no name info"
    }
}

rekin · 2018-09-11T16:34:55.000Z

jitensh · 2018-09-11T16:35:18.000Z

CSV should have a header like givename,surname based on your code you running. Looks you have gname and sname so it will be

Import-Module ActiveDirectory

$users = Import-CSV "c:\location\of\file.csv"
foreach ($user in $users) {

    $gname = $user.gname
    $sname = $user.sname
      $user=Get-ADUser -Filter "GivenName -eq '$gname' -and Surname -like '$sname'"  -properties Emailaddress
       if( $User )
    {
        $user |select samaccountname, emailaddress
    }
    else
    {
    New-Object PSObject -Property @{
            GivenName  = $Gname
            Surname    = $sname
            Status     = 'MISSING ACCOUNT'
            }
    }

}

rekin · 2018-09-17T16:01:00.000Z

JitenSh,

Thanks.