Writing output names to a string adding extra characters

Question

I am setting up an application that have rooms for its users. The only way to group these users is by listing their names in the following fashion:

Host IN ('Fist1 Last1', 'Fist2 Last2', 'Fist3 Last3')

I would like to output the names of the users in a given OU in the format inside of the parentheses above. Just 'Fist1 Last1', 'Fist2 Last2', 'Fist3 Last3'.

Get-ADuser -searchbase "OU=HQ,DC=DOMAIN,DC=COM" -filter {enabled -eq "True"} | Select-Object -Property name

How can I have that output in 'first last', 'first last', 'first last', etc....

Thanks!

mjolinor · Accepted Answer · 2014-06-06 19:43:10Z

1

Not tested, but I think this should work:

(Get-ADuser -searchbase "OU=HQ,DC=DOMAIN,DC=COM" -filter {enabled -eq "True"} |
  ForEach-Object { "'{0} {1}'" -f $_.GivenName,$_.Surname }) -join ','

answered Jun 6, 2014 at 19:43

mjolinor

68.7k7 gold badges118 silver badges141 bronze badges

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

Collectives™ on Stack Overflow

Writing output names to a string adding extra characters

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related