PowerShell Get-ADGroup Display Issue

Question

I am writing a script with a GUI for work and I have an Issue that I am having trouble getting past. I am trying to get the Department to show all of our departments in a combobox but when the script pulls the departments from the AD it also displays the @{Name= before every department name (see image below).

Here is the block I am having issues with

$DepGroups = Get-ADGroup -Filter * -SearchBase "OU=Our Departments,DC=ourDC,DC=com" |
             select Name | Sort -Property Name
$DepBox = New-Object System.Windows.Forms.ComboBox
$DepBox.Width = 136
$DepBox.Height = 20
$DepBox.Location = New-Object System.Drawing.Point(95,53)
$DepBox.Font = "Microsoft Sans Serif,10"
$DepBox.DropDownStyle = 'DropDownList'
$DepBox.Items.AddRange($DepGroups)
$Form.Controls.Add($DepBox)

Possible duplicate of How to `select` to an array of strings — Ansgar Wiechers
– Ansgar Wiechers, Commented Aug 16, 2017 at 8:25

Alec Collier · Accepted Answer · 2017-08-15 23:23:36Z

0

Uusing the | Select pipe will return an object with the selected attributes in it, in this case just the Name.

You should use ( < obj > ).Name to just get the value of the Name attribute.

i.e.

$DepGroups = (Get-ADGroup -Filter * -SearchBase "OU=Our Departments,DC=ourDC,DC=com").Name | <Any additional sorting>

answered Aug 15, 2017 at 23:23

Alec Collier

1,5239 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

User2495 Over a year ago

Yes this is exactly what I needed Thank you very much!

Collectives™ on Stack Overflow

PowerShell Get-ADGroup Display Issue

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related