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!
not able to export result in csv - powershell
$a = Get-Content C:\xyz\test.txt
foreach($b in $a)
{
Get-Mailbox -Identity $b | Select-Object name, Database
}
$b | Export-Csv C:\xyz\result.csv
It gives output as ""PSPath","PSParentPath","
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You're exporting b, which comes from your file. It's breaking the interpreter a bit.
Get-Content C:\xyz\test.txt | ForEach-Object {
Get-Mailbox -Identity $_ | Select-Object name, Database
} | Export-Csv C:\xyz\result.csv
Supply values for the following parameters:
Process[0]:
Anyway you could modify my script not able to get yours..
Process[0]:
Anyway you could modify my script not able to get yours..
$results = @()
$a = Get-Content C:\xyz\test.txt
foreach($b in $a)
{
$results += Get-Mailbox -Identity $b | Select-Object name, Database
}
$results | Export-Csv C:\xyz\result.csv
You're going to have to share a bit more detail because the errors you're getting and the code I'm posting are not joining up.
What, exactly, does the error message say and where is it being thrown?
What, exactly, does the error message say and where is it being thrown?
what my script does is it gets all user from list and find their mailboxes and shows results.
I want this result in csv
I want this result in csv
I'm quite capable of reading the script and determining its intent. I've given you two versions which will achieve that result. The scripts aren't long, there's not a huge margin for error here.
I'm unclear how you're managing to end up with errors. You'll have to share more if I'm to help further.
I'm unclear how you're managing to end up with errors. You'll have to share more if I'm to help further.
$a = Get-Content C:\xyz\test.txt
foreach($b in $a)
{
Get-Mailbox -Identity $b | ft name, Database
}
$b | Export-Csv C:\xyz\result.csv
I have modified my script it gives output in the console however it generates a csv file with no output in it
That's because "$b" is a single entry (the last entry) from Get-Content. It is *not* the result of the Get-Mailbox command. You'll get lots to the console and nothing of note to the file.
If you want to export, you either need:
To send the output you're generating for the console to a file (via Export-Csv)
Or:
To declare, then add results to an array. The array is then sent to Export-Csv:
If you cannot build the examples yourself, don't tweak them except for the obvious file names. If you cannot work with the error messages yourself, include them in the thread exactly as they are, don't paraphrase or give your own partial interpretation.
If you want to export, you either need:
To send the output you're generating for the console to a file (via Export-Csv)
Get-Content C:\xyz\test.txt | ForEach-Object {
Get-Mailbox -Identity $_ | Select-Object name, Database
} | Export-Csv C:\xyz\result.csv
Or:
To declare, then add results to an array. The array is then sent to Export-Csv:
$results = @()
$a = Get-Content C:\xyz\test.txt
foreach($b in $a)
{
$results += Get-Mailbox -Identity $b | Select-Object name, Database
}
$results | Export-Csv C:\xyz\result.csv
If you cannot build the examples yourself, don't tweak them except for the obvious file names. If you cannot work with the error messages yourself, include them in the thread exactly as they are, don't paraphrase or give your own partial interpretation.
Im getting this ou put in csv
#TYPE Microsoft.PowerShell.Comma
"ClassId2eaqwere99d3c95291
May be some with exchange expertise can solve this ...
#TYPE Microsoft.PowerShell.Comma
"ClassId2eaqwere99d3c95291
May be some with exchange expertise can solve this ...
You showed code with a bug caused by you passing the wrong value to Export-Csv.
I gave you two solutions which deal with that.
At no point have I used Format-*, so why are you?
I cannot help you, you change the things you're given, then complain they don't work.
Good luck.
I gave you two solutions which deal with that.
At no point have I used Format-*, so why are you?
I cannot help you, you change the things you're given, then complain they don't work.
Good luck.
I hate to ask this but are you running this on an Exchange server or at least opening a remote powershell session to one? I.E. loading the Exchange modules? I only ask this because, out of curiosity, I tried both of the scripts that Chris posted and they run like a champ ). As long as your text file is just a list of users, you have valid paths, and have the Exchange module loaded in powershell these run perfectly.
Premium Content
You need an Expert Office subscription to comment.Start Free Trial