power shell command

timzimmerman2 · 2019-05-16T18:13:13.000Z

Can someone help with this powershell command. I am helping a co-work find users, But also find the manager and there information?

$ADUserParams=@{
‘Server’ = server
‘Searchbase’ = ‘OU=sites,DC=xxxx,DC=xxxx’
‘Searchscope’= ‘Subtree’
‘Filter’ = ‘’
‘Properties’ = '’
}

$SelectParams=@{
‘Property’ = ‘SAMAccountname’,‘Employeenumber’,‘givenname’,‘surname’,‘Division’,‘title’,‘EmailAddress’,@{Name=‘Manager Last’;Expression={(Get-ADUser $.Manager).surname}},@{Name=‘Manager First’;Expression={(Get-ADUser $.Manager).givenname}},@{Name=‘Manager Clock’;Expression={(Get-ADUser $.Manager).Employeenumber}},‘officephone’,@{Name=‘Manager email’;Expression={(Get-ADUser $.Manager).EmailAddress}}
}

get-aduser @ADUserParams | select-object @SelectParams | export-csv “c:\temp\test.csv”

Neally · 2019-05-16T18:15:07.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…

Evan7191 · 2019-05-16T18:20:23.000Z

You need to use $ for variables instead of @.

$ADUserParams=@{ 
'Server' = server
'Searchbase' = 'OU=sites,DC=xxxx,DC=xxxx' 
'Searchscope'= 'Subtree' 
'Filter' = '*' 
'Properties' = ('SAMAccountname','Employeenumber','givenname','surname','Division','title','EmailAddress')
} 

$SelectParams=@{ 
'Property' = 'SAMAccountname','Employeenumber','givenname','surname','Division','title','EmailAddress',@{Name='Manager Last';Expression={(Get-ADUser $_.Manager).surname}},@{Name='Manager First';Expression={(Get-ADUser $_.Manager).givenname}},@{Name='Manager Clock';Expression={(Get-ADUser $_.Manager).Employeenumber}},'officephone',@{Name='Manager email';Expression={(Get-ADUser $_.Manager).EmailAddress}}
} 

get-aduser $ADUserParams | select-object $SelectParams | export-csv "c:\temp\test.csv"

-Properties * is inefficient, especially if you know which properties you want to retrieve.

Neally · 2019-05-16T18:21:56.000Z

Evan7191:

You need to use $ for variables instead of @.

I think he tried to splat?

Evan7191 · 2019-05-16T18:29:26.000Z

Neally:

Evan7191:

You need to use $ for variables instead of @.

I think he tried to splat?

Yes, the splatting was correct, but the variables in the Get-ADUser command were not.

robertmartinez3 · 2019-05-16T18:43:23.000Z

I would check first how managers are listed in Active Directory under the Attribute Editor and then query those items. What errors are you receiving?

timzimmerman2 · 2019-05-16T22:27:18.000Z

I am not receiving any errors. It pulls in the all the categories. But for the manager email and manager clock, I get no data. its picks up the phone numbers for the managers. Not sure why the titles for manager email and manger clock are there but it find no data.

robertmartinez3 · 2019-05-17T02:33:39.000Z

You probably aren’t seeing ManagerEmail because that attribute doesn’t exist, when I look at Active Directory I see a mail attribute not EmailAddress, and I don’t see Clock but looking at your Name=‘Manager Clock’;Expression={(Get-ADUser $_.Manager).Employeenumber the value might not exist. Doing a

get-aduser "samAccountName" -properties *

will get you all the properties of that account

010101000110100101101101 · 2019-05-17T04:01:49.000Z

Evan7191:

You need to use $ for variables instead of @.

$ADUserParams=@{ 
'Server' = server
'Searchbase' = 'OU=sites,DC=xxxx,DC=xxxx' 
'Searchscope'= 'Subtree' 
'Filter' = '*' 
'Properties' = ('SAMAccountname','Employeenumber','givenname','surname','Division','title','EmailAddress')
} 

$SelectParams=@{ 
'Property' = 'SAMAccountname','Employeenumber','givenname','surname','Division','title','EmailAddress',@{Name='Manager Last';Expression={(Get-ADUser $_.Manager).surname}},@{Name='Manager First';Expression={(Get-ADUser $_.Manager).givenname}},@{Name='Manager Clock';Expression={(Get-ADUser $_.Manager).Employeenumber}},'officephone',@{Name='Manager email';Expression={(Get-ADUser $_.Manager).EmailAddress}}
} 

get-aduser $ADUserParams | select-object $SelectParams | export-csv "c:\temp\test.csv"

-Properties * is inefficient, especially if you know which properties you want to retrieve.

No, he was doing that part correctly. You do use the ‘@’ symbol there in the Get-ADUser cmdlet just as he has done.

timzimmerman2 · 2019-05-17T09:21:02.000Z

I tested it and adding the $ instead of @, did not work. Everything works but for the Manager clock-employee number or Manager email -emailaddress. So why does it pull the mangers phone number but not the email and manager employee number?

$SelectParams=@{ 'Property' = 'SAMAccountname','Employeenumber','givenname','surname','Division','title','EmailAddress',@{Name='Manager Last';Expression={(Get-ADUser $_.Manager).surname}},@{Name='Manager First';Expression={(Get-ADUser $_.Manager).givenname}},**@{Name='Manager Clock';Expression={(Get-ADUser $_.Manager).Employeenumber}}**,'officephone',**@{Name='Manager email';Expression={(Get-ADUser $_.Manager).EmailAddress}}**

robertmartinez3 · 2019-05-18T20:14:12.000Z

Read my post above…those properties probably don’t exist or they are referenced by a different Attribute Name than the one you have listed.

timzimmerman2 · 2019-05-18T21:46:24.000Z

Yes, you are correct. but thats not what he power shell is asking for.

$SelectParams=@{ ‘Property’ = ‘SAMAccountname’,‘Employeenumber’,‘givenname’,‘surname’,‘Division’,‘title’,‘EmailAddress’,@{Name=‘Manager Last’;Expression={(Get-ADUser $.Manager).surname}},@{Name=‘Manager First’;Expression={(Get-ADUser $.Manager).givenname}},@{Name=‘Manager Clock’;Expression={(Get-ADUser $.Manager).Employeenumber}},‘officephone’,@{Name=‘Manager email’;Expression={(Get-ADUser $.Manager).EmailAddress}}

Manager email or manager clock is just a category in the output data. But Manager email should show the email address as shown in the script. Manager Last is not an attribute either but it picks up the correct information. I am not saying you are wrong, I am separating the manager information from the employee information.

The name is just the title of the column. it should show the correct information.