Add selections from ticked boxs into powershell script

the-guvner · 2021-01-20T13:37:24.000Z

Hi, please could i get some help on the below,

The goal:

To have a form with tick boxs that then puts the options ticked into a script to obtain a list of AD users from OU’s.

The issue:

I am able to have one of the ticked options to go into the AD users script…BUT it only selects the last option selected in the tick box. I need all selected options (which would be AD attribute names for job title,surname,display name etc) to be put into the script in the ares after -properties & Select. I have searched online but cant seem to find a solution for my skill level I.E im learning PS but im not at this level of knowledge to understand whats required. The form itself has been cobbled together from online research.(so may be a bit of a mess in places).

Is there any help that anyone could provide please?

The full code:

Add-Type -AssemblyName System.Windows.Forms
Add-Type -AssemblyName System.Drawing

$form = New-Object System.Windows.Forms.Form
$form.Text = 'Select an option'
$form.Size = New-Object System.Drawing.Size(300,200)
$form.StartPosition = 'CenterScreen'

$okButton = New-Object System.Windows.Forms.Button
$okButton.Location = New-Object System.Drawing.Point(75,120)
$okButton.Size = New-Object System.Drawing.Size(75,23)
$okButton.Text = 'OK'
$okButton.DialogResult = [System.Windows.Forms.DialogResult]::OK
$form.AcceptButton = $okButton
$form.Controls.Add($okButton)

$cancelButton = New-Object System.Windows.Forms.Button
$cancelButton.Location = New-Object System.Drawing.Point(150,120)
$cancelButton.Size = New-Object System.Drawing.Size(75,23)
$cancelButton.Text = 'Cancel'
$cancelButton.DialogResult = [System.Windows.Forms.DialogResult]::Cancel
$form.CancelButton = $cancelButton
$form.Controls.Add($cancelButton)

$label = New-Object System.Windows.Forms.Label
$label.Location = New-Object System.Drawing.Point(10,20)
$label.Size = New-Object System.Drawing.Size(280,20)
$label.Text = 'Please select options:'
$form.Controls.Add($label)

$listBox = New-Object System.Windows.Forms.checkedlistbox
$checkBox.CheckOnClick = $true
$listBox.Location = New-Object System.Drawing.Point(10,40)
$listBox.Size = New-Object System.Drawing.Size(260,20)
$CheckedListBox.CheckOnClick = $true
$CheckedListBox.Items.Add("Select All")
$CheckedListBox.Items.AddRange(1..10)
$CheckedListBox.ClearSelected()
$objForm.Controls.Add($CheckedListBox)
$listBox.Height = 80

###The below has the names the same as the AD attributes are called.....ive done it like this as i was trying to pass that into the script as a variable.
[void] $listBox.Items.Add("EmailAddress")
[void] $listBox.Items.Add('Surname')
[void] $listBox.Items.Add('title')
[void] $listBox.Items.Add('Empty at mo')
[void] $listBox.Items.Add('Empty at mo')
[void] $listBox.Items.Add('Empty at mo')
[void] $listBox.Items.Add('Empty at mo')

$form.Controls.Add($listBox)

$form.Topmost = $true

$result = $form.ShowDialog()

if ($result -eq [System.Windows.Forms.DialogResult]::OK)
{
######the idea below was to place the text from the list boxs into a variable that i then put the variable into the script below.
    $Email = $listBox.SelectedItem.ToString();
    $surname = $listBox.SelectedItem.ToString();
    $Job = $listBox.SelectedItem.ToString();

    $ous = "OU=Some place A,OU=Some place A,DC=B,DC=Some place c","OU=Some place D,OU=Some place E,DC=F,DC=Some place G,DC=H"

    ####and here is where i would like the selected items to appear after -properties & Select with the , in between.
$ous | ForEach { Get-ADUser -Filter {Enabled -eq $True} -SearchBase $_ -properties displayname,$Email,$surname,$job} | Select displayname,$surname,$job | Export-Csv -path c:\test.csv -NoTypeInformation
}

Evan7191 · 2021-01-20T14:45:47.000Z

Instead of making a list of checkboxes from scratch, I would recommend running your query and sending the results to Out-GridView, and you can use the -PassThru parameter to send the selection output back to your script.

learn.microsoft.com

Out-GridView (Microsoft.PowerShell.Utility) - PowerShell

This cmdlet is only available on the Windows platform. The Out-GridView cmdlet sends the output from a command to a grid view window where the output is displayed in an interactive table. Because this cmdlet requires a user interface, it does not...

Neally · 2021-01-20T15:49:18.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…

the-guvner · 2021-01-20T20:26:48.000Z

Thanks for the help Evan. However i am still struggling with this (think at at my current knowledge limit). I have added the out grid passthrough to the end of the script. The changes are on the last line as seen in the attached code. When running it does pass to the grid but the CSV is created blank and it also still only inputs the last ticked box into the get-aduser script and not all checked items.

Now im not even sure if i’ve put the code in the right place etc so would you be able to help any further? I appreciate your help on this.

$ous | ForEach { Get-ADUser -Filter {Enabled -eq $True} -SearchBase $_ -properties displayname,$Email,$surname,$job} | Select displayname,$Email,$surname,$job | Get-Process | Out-GridView -PassThru | Export-Csv -Path c:\test.csv -NoTypeInformation

Neally · 2021-01-20T20:37:29.000Z

yeah no that syntax makes no sense.

try like so

e.g.

$data = 
$ous | 
ForEach-object { 
    Get-ADUser -Filter {Enabled -eq $True} -SearchBase $_ -properties displayname,emailaddress,surname,title | 
    Select displayname,Email,surname,title
}

$data | Out-GridView -PassThru |
Export-Csv -Path c:\test.csv -NoTypeInformation

the-guvner · 2021-01-20T21:01:04.000Z

Thanks for the reply,
How can i get it so if only for example surname and title were ticked and i want those ticked options to then be output to the CSV (or basically any combination of tilcked boxs)? I’ve listed the area i need them to go into below.

$data = $ous | ForEach-object { Get-ADUser -Filter {Enabled -eq $True} -SearchBase $_ -properties displayname,Take selections from the ticked boxs |  Select displayname,Take selections from the ticked boxs}

Neally · 2021-01-20T21:16:22.000Z

I don’t do GUIs

The-Guvner:

How can i get it so if only for example surname and title were ticked and i want those ticked options to then be output to the CSV

You might have to write repetitive code or a function to get what you need.
You can try something like this, get the elements from the listbox items, but they MUST match AD properties
e.g

$data = 
$ous | 
ForEach-object { 
    Get-ADUser -Filter {Enabled -eq $True} -SearchBase $_ -properties displayname,$(if($listBox.Items){$listBox.Items -join ","}) | 
    Select $(if($listBox.Items){$listBox.Items -join ","})
}

$data | Out-GridView -PassThru |
Export-Csv -Path c:\test.csv -NoTypeInformation

the-guvner · 2021-01-21T20:52:23.000Z

Thanks for the assistance. so i have played with the suggestions and kinda went back to the beginning with the form. when testing the code up to line 51 i can output the text from the selected boxs…so great that part works…so i though ok i’ll add that variable $x into the get-aduser code in the select section…but it doesn’t work…When opening the form i make the selections and click ok this then creates the CSV but returns all the properties for AD…its not picking up the varibale $x hence why it returns so many columns.

I did try $(if($listBox.Items) as advised by Neally but that didnt work. No output to the CSV was provided.

Any further help would be much appropriated. I have attached the latest code.

Add-Type -AssemblyName System.Windows.Forms
Add-Type -AssemblyName System.Drawing

$form = New-Object System.Windows.Forms.Form
$form.Text = 'Data Entry Form'
$form.Size = New-Object System.Drawing.Size(300,200)
$form.StartPosition = 'CenterScreen'

$OKButton = New-Object System.Windows.Forms.Button
$OKButton.Location = New-Object System.Drawing.Point(75,120)
$OKButton.Size = New-Object System.Drawing.Size(75,23)
$OKButton.Text = 'OK'
$OKButton.DialogResult = [System.Windows.Forms.DialogResult]::OK
$form.AcceptButton = $OKButton
$form.Controls.Add($OKButton)

$CancelButton = New-Object System.Windows.Forms.Button
$CancelButton.Location = New-Object System.Drawing.Point(150,120)
$CancelButton.Size = New-Object System.Drawing.Size(75,23)
$CancelButton.Text = 'Cancel'
$CancelButton.DialogResult = [System.Windows.Forms.DialogResult]::Cancel
$form.CancelButton = $CancelButton
$form.Controls.Add($CancelButton)

$label = New-Object System.Windows.Forms.Label
$label.Location = New-Object System.Drawing.Point(10,20)
$label.Size = New-Object System.Drawing.Size(280,20)
$label.Text = 'Please make a selection from the list below:'
$form.Controls.Add($label)

$listBox = New-Object System.Windows.Forms.Listbox
$listBox.Location = New-Object System.Drawing.Point(10,40)
$listBox.Size = New-Object System.Drawing.Size(260,20)

$listBox.SelectionMode = 'MultiExtended'

[void] $listBox.Items.Add('emailaddress')
[void] $listBox.Items.Add('surname')
[void] $listBox.Items.Add('SAMAccountname')
[void] $listBox.Items.Add('givenName')
[void] $listBox.Items.Add('EmployeeID')

$listBox.Height = 70
$form.Controls.Add($listBox)
$form.Topmost = $true

$result = $form.ShowDialog()

if ($result -eq [System.Windows.Forms.DialogResult]::OK)
{
    $x = $listBox.SelectedItems. -join "," #####here i added out-gridview and it did return the values from the selected boxs.

    

    $ous = "OU=Name 1,OU=Name 2,DC=Name 3,DC=Name 4,DC=Name 5","OU=Name 6,OU=Name 7,DC=Name 8,DC=Name 9,DC=Name 10"

    ######thought i could add the var $x after select in the script below to have the selected options from the form populate there as string with , between the words (surname,givename etc)

$ous | ForEach { Get-ADUser -Filter {Enabled -eq $True} -SearchBase $_ -properties *  } | Select $x|  Export-Csv -path c:\ADtest.csv

}

the-guvner · 2021-01-31T14:55:10.000Z

Update: I have now managed to get this working. I can now select multiple options from the list box and store them in a variable and have the script use the selected options that are stored in the variable. This is version 1 as i want to make this more presentable etc but for now the topic i created has been solved.
Thanks to all for the info and stearing.
Final code included for those interested.

Add-Type -AssemblyName System.Windows.Forms
Add-Type -AssemblyName System.Drawing

$form = New-Object System.Windows.Forms.Form
$form.Text = 'Data Entry Form'
$form.Size = New-Object System.Drawing.Size(300,200)
$form.StartPosition = 'CenterScreen'

$OKButton = New-Object System.Windows.Forms.Button
$OKButton.Location = New-Object System.Drawing.Point(75,120)
$OKButton.Size = New-Object System.Drawing.Size(75,23)
$OKButton.Text = 'OK'
$OKButton.DialogResult = [System.Windows.Forms.DialogResult]::OK
$form.AcceptButton = $OKButton
$form.Controls.Add($OKButton)

$CancelButton = New-Object System.Windows.Forms.Button
$CancelButton.Location = New-Object System.Drawing.Point(150,120)
$CancelButton.Size = New-Object System.Drawing.Size(75,23)
$CancelButton.Text = 'Cancel'
$CancelButton.DialogResult = [System.Windows.Forms.DialogResult]::Cancel
$form.CancelButton = $CancelButton
$form.Controls.Add($CancelButton)

$label = New-Object System.Windows.Forms.Label
$label.Location = New-Object System.Drawing.Point(10,20)
$label.Size = New-Object System.Drawing.Size(280,20)
$label.Text = 'Please make a selection from the list below:'
$form.Controls.Add($label)

$listBox = New-Object System.Windows.Forms.Listbox
$listBox.Location = New-Object System.Drawing.Point(10,40)
$listBox.Size = New-Object System.Drawing.Size(260,20)

$listBox.SelectionMode = 'MultiExtended'

[void] $listBox.Items.Add('emailaddress')
[void] $listBox.Items.Add('surname')
[void] $listBox.Items.Add('SAMAccountname')
[void] $listBox.Items.Add('givenName')
[void] $listBox.Items.Add('EmployeeID')
[void] $listBox.Items.Add('Company')
[void] $listBox.Items.Add('department')

$listBox.Height = 70
$form.Controls.Add($listBox)
$form.Topmost = $true

$result = $form.ShowDialog()

if ($result -eq [System.Windows.Forms.DialogResult]::OK)
{
    $x = $listBox.SelectedItems

  
    
$ous = #list your ous here!
"OU=

$ous | ForEach { Get-ADUser -Filter {Enabled -eq $True} -SearchBase $_ -properties manager,physicalDeliveryOfficeName,lastlogontimestamp,emailaddress,Company,department,SAMAccountname,givenName,Surname,EmployeeID,description,title,displayname} | Select $x|  Export-Csv -path c:\ADtest.csv

}