Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Powershell--Assistance
How can I get a csv listing of Alias' from a csv listing of Displaynames? Please provide the Powershell cmdlet.
Thank you!
Thank you!
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
$stuff = @()
$stuff = foreach($entry in import-csv inputfilename.csv){Get-Mai
$stuff | Export-Csv outputfilename.csv -notypeinformation
Your input csv file should be something like:
Displayname
User1
User2
$stuff = foreach($entry in import-csv inputfilename.csv){Get-Mai
$stuff | Export-Csv outputfilename.csv -notypeinformation
Your input csv file should be something like:
Displayname
User1
User2
assuming your csv is something like
it would be something like
Name
Joe Took
Micheal Kain
it would be something like
$a = import-csv c:\list.csv
$a | Get-Mailbox $_.name| select name, alias
You can also use the following lines of code
foreach($entry in import-csv inputfilename.csv){Get-Mai
foreach($entry in import-csv inputfilename.csv){Get-Mai
Following command will only export the Alias. If you want more attributes in output then add it in select section and export it..
CSV header should be Displaynames
CSV header should be Displaynames
Import-csv test.csv | % {Get-recipient $_Displaynames | Select Alias} | Export-Csv c:\test.csv -NoTypeInformation
csv is like
the powershell is like
Name
Joe Took
Micheal Kain
the powershell is like
$a = import-csv c:\list.csv
$a | foreach {Get-Mailbox $_.name}| select name, alias | export-csv c:\alias.csv
Now I am trying to run this cmdlet, but it is outputting the quota values and not the names. Am I missing a variable? The csv is:
Name
user1
user2
Import-csv d:\displayname.csv
%{Get-mailbox $_.Name} |select-object prohibitsendquota, issuewarningquota, prohibitsendreceivequota |export-csv D:\QuotaLimit.csv
Any thoughts?
Name
user1
user2
Import-csv d:\displayname.csv
%{Get-mailbox $_.Name} |select-object prohibitsendquota, issuewarningquota, prohibitsendreceivequota |export-csv D:\QuotaLimit.csv
Any thoughts?
Run my command it is the same but will give youthe names and aliases add the quota variables to it if you want
Here is what's happening: When I add quotes around the displaynames ("john smith") and save it as csv, when I open in notepad, it shows triple quotes around the names ("""john smith"""). Some how the formatting is wrong when I save it. Even when I save it as a text file, it still shows triple quotation marks.
Any thoughts?
Any thoughts?
Premium Content
You need an Expert Office subscription to comment.Start Free Trial