Get mailboxstatistics from a CSV file

Todas as Respostas

• 

  

  0

  Entrar para Votar

  $report = @()
  $outfile = "MailboxSizeReport" + ".csv" 
  $user = Import-CSV c:\users.csv
  foreach ($id in $user)
  {
     Get-MailboxStatistics $id.alias | Sort-Object TotalItemSize -Descending 
       $tmp = New-Object PSObject
       $tmp | Add-Member -type NoteProperty -name DisplayName -value $id.DisplayName
       $tmp | Add-Member -type NoteProperty -name TotalItemSize -value $id.TotalItemSize
       $report += $tmp
  }
  $report | Export-CSV c:\$outfile –notypeinformation -encoding "unicode"

  
  

  ---

  Om

  

  • Marcado como Resposta Morris - MS quinta-feira, 17 de janeiro de 2013 19:15

  quinta-feira, 17 de janeiro de 2013 16:34
• 

  

  0

  Entrar para Votar

  Hello Prakash,

  Thank you for offering me the solution script.

  I want to make things simpler, I don't need the entire list (1000 mailboxes size) output.

  All that I need is the totalitemsize (total size of 1000 mailboxes).

  Can it be done?

  Morris

  quinta-feira, 17 de janeiro de 2013 16:47
• 

  

  0

  Entrar para Votar

  $user = Import-CSV c:\users.csv
  $total = 0
  foreach ($id in $user)
  {
  $tmp = Get-MailboxStatistics $id.alias 
  $item = $tmp.TotalItemSize 
  
  $itemsize=[int]$item
  $size = 0
  $size = $total + $itemsize
  
  $total = $size
  
  }
  
  write-host "Total size:" $total

  
  This one will give you the total itemm size of all the 1000 mailboxes.

  ---

  Om

  

  
  
  
  
  
  
  

  • Editado Om Prakash Nath quinta-feira, 17 de janeiro de 2013 17:31

  quinta-feira, 17 de janeiro de 2013 17:15
• 

  

  0

  Entrar para Votar

  Looks like I got the following script working for me:

  
  $Users = Import-Csv c:\ExportList_new.csv

  foreach ($id in $users)

  {

  Get-MailboxStatistics $id.alias | Sort-Object TotalItemSize –Descending | ft @{label=”User”;expression={$_.DisplayName}},@{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}}

  }

  • Marcado como Resposta Morris - MS quinta-feira, 17 de janeiro de 2013 19:15

  quinta-feira, 17 de janeiro de 2013 17:21
• 

  

  0

  Entrar para Votar

  Great... My earlier script does the same thing.

  Your one really simple but I afraid, you won't be able to export this result in a CSV file.

  ---

  Om

  

  quinta-feira, 17 de janeiro de 2013 17:31
• 

  

  0

  Entrar para Votar

  Prakash,

  I actually started: start-transcript results.txt

                              Ran the script

                              Stop-transcript

  That did the trick.

  quinta-feira, 17 de janeiro de 2013 19:15
• 

  

  0

  Entrar para Votar

  Hi,

  I am specfiying only the email address it were not working ?

  i have specicy FirstName, LastName, email address as mentioned in the thread.

  If could help me it would be grea

  THnka

  Muthu

  ---

  Thanks Muthu

  domingo, 2 de agosto de 2020 11:33