Powershell output/export help

williambricker · 2019-03-08T13:43:34.000Z

TLDR

Running the command Get-aduser -identity username | select givenname

Results in the following output = @{givenname=givenname}

Or in excel it will have a header with givenname and the users name underneath but I want powershell to only output the users givenname by itself so that I can utilize the text of the users first name without it being wrapped in @{givenname=}.

The longer version of the problem is that I am integrating some basic commands with a windows forms interface.

I have a text box for the user ID

$objUIDBox = New-Object System.Windows.Forms.TextBox
$objUIDBox.Location = New-Object System.Drawing.Size(10,40)
$objUIDBox.Size = New-Object System.Drawing.Size(260,20)
$objUIDBox.TabIndex = 0
$objForm.Controls.Add($objUIDBox)

Then I have a command attached to a button $objUIDBox.text=get-aduser user | select givenname, but the short of the issue is that the text provided by

get-aduser user | select givenname ends up populating the text box with @{givenname=givenname}

Neally · 2019-03-08T13:55:00.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…

Neally · 2019-03-08T13:56:45.000Z

williambricker:

Get-aduser -identity username | select givenname

Results in the following output = @{givenname=givenname}

You have to use ‘expandproperty’

Get-aduser -identity username | select -expandproperty givenname
#or
(Get-aduser -identity username).givenname

edwineekelaers2 · 2019-03-08T13:56:47.000Z

I see you are trying to use gui’s. Don’t if you aren’t sufficiently skilled. Basic gui less code works better and is easier to learn

williambricker · 2019-03-08T14:08:23.000Z

Man I should of known that since I had to do the same thing with security groups to get them to populate in a listbox.

TYVM