Powershell n00b question
I have been supplied a list of users in XLS format that I wish to run a powershell command against "set-UMMailbox alias -CallAnsweringAudioCodec GSM"
How can I feed this list into the command so I don't have to do each user individually.
Sorry, total n00b to Powershell!
November 8th, 2010 11:47am
You could create a csv file from the excel document and then use the import csv command. It could look something like this:
Import-CSV c:\users.csv | foreach {set-UMMailbox $_.Username -CallAnsweringAudioCodec GSM}
The $_.Username is the field in the CSV where the alias is.
/Martin
Exchange is a passion not just a collaboration software.
Free Windows Admin Tool Kit Click here and download it now
November 8th, 2010 12:31pm
On Mon, 8 Nov 2010 16:42:47 +0000, dgjlee wrote:
>
>
>I have been supplied a list of users in XLS format that I wish to run a powershell command against "set-UMMailbox alias -CallAnsweringAudioCodec GSM"
>
>How can I feed this list into the command so I don't have to do each user individually.
>
>Sorry, total n00b to Powershell!
See if this helps:
http://powershell.com/cs/blogs/ebook/archive/2009/03/30/chapter-14-xml.aspx
---
Rich Matheisen
MCSE+I, Exchange MVP
--- Rich Matheisen MCSE+I, Exchange MVP
November 8th, 2010 5:49pm