How to export csv

Question

Hi Guys,

I don't know how to export this powershell script. how to export to csv files ?

$Users = Import-Csv c:\Sources\Query\alias.csv
foreach ($id in $users)
{
Get-MailboxStatistics $id.alias | Sort-Object DisplayName, Database, TotalItemSize –Descending | ft @{label=”User”;expression={$.DisplayName}},@{label=”Database”;expression={$.Databasename}},@{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}}
}

Thank You,

Answer 1

Hi @Hharis ,

you can try it this way (not tested by myself):

$Users = Import-Csv c:\Sources\Query\alias.csv  
$mailboxStats = @()  
foreach ($id in $users) {  
    $userStats = Get-MailboxStatistics $id.alias | Sort-Object DisplayName, Database, TotalItemSize –Descending |  
        Select-Object @{label = ”User”; expression = { $_.DisplayName } }, @{label = ”Database”; expression = { $_.Databasename } }, @{label = ”Total Size (MB)”; expression = { $_.TotalItemSize.Value.ToMB() } }  
    $mailboxStats = $mailboxStats + $userStats   
}  
$mailboxStats | Export-Csv -Path "c:\temp\mailboxstats.csv" -NoTypeInformation  

----------

(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)

Regards
Andreas Baumgarten

Answer 2

Hey @Hharis

Did you try to add an output at the end of the query?

Example:
foreach ($item in $ITGlueTest.data)
{
$item.attributes | export-csv C:\organization.csv -Append
}

--If the reply is helpful, please Upvote and Accept as answer--

Answer 3

Here's another way to do this without the need for intermediate array manipulation:

Import-Csv c:\Sources\Query\alias.csv |
    ForEach-Object {
        Get-MailboxStatistics $_.alias
    } |
        Sort-Object DisplayName, Database, TotalItemSize -Descending | 
            Select-Object  @{n = "User"; e = { $_.DisplayName } }, 
                            @{n = "Database"; e = { $_.Databasename } }, 
                            @{n = "Total Size (MB)"; e = { $_.TotalItemSize.Value.ToMB() } } |
                Export-Csv c:\junk\MailBoxStats.csv -NoTypeInformation