locked
unable to export username (sameaccountname) with mailbox size RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi,

    i am using this command to export all users with their name , user id (sameaccountname),mailbox size , database but samaccountname is coming as blank

    Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,SamAccountName,TotalItemSize,Database | Export-Csv c:\temp\size.csv 

    can anyone guide me how i can get the user ids as welll with mailbox size and database name


    Monday, July 24, 2017 10:05 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Balal 

    You need a foreach to be able to get the Samaccount name as this is not part of Get-MailboxStatistics you will also need a blank arrays to capture each properties. The below should work. The only problem i have had with the below is that you have to have powershell V3 or above to add the append command to export-csv. 

    $mailboxes = get-mailbox -resultsize unlimited 
foreach  ($mailbox in $mailboxes) {
$Results=@() 
$properties = @{
SAMAccountName = $mailbox.sAMAccountName
displayName = $mailbox.displayName
TotalItemSize = (get-mailboxstatistics -id $mailbox.distinguishedname).totalitemsize
ItemCount = (get-mailboxstatistics -id $mailbox.distinguishedname).ItemCount
Database = $mailbox.Database
}
$Results += New-Object psobject -Property $properties
$Results | select SAMAccountName,displayName,TotalItemSize,ItemCount,Database | Export-Csv c:\Temp\MAilboxExport.csv -NoTypeInformation -Append
}

    • Marked as answer by Balal Ahmad Tuesday, July 25, 2017 4:36 AM
    Monday, July 24, 2017 4:29 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Get-MailboxStatistics does not have "SamAccountName".  Use "DisplayName" or "alias".

    \_(ツ)_/


    • Edited by jrv Monday, July 24, 2017 10:25 AM
    Monday, July 24, 2017 10:20 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    display name i already have , i need the user id , i tried Alias but still its giving blank values

    Get-Mailbox -ResultSize Unlimited | Get-MailboxStatistics | Sort-Object TotalItemSize -Descending | Select-Object DisplayName,Alias,TotalItemSize,Database | Export-Csv c:\temp\size.csv

    Monday, July 24, 2017 10:34 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You will have to use a foreach loop to capture the SamAccountName from get-mailbox.

    \_(ツ)_/

    Monday, July 24, 2017 10:45 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    can you please send me the complete command ?
    Monday, July 24, 2017 10:53 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    1

    Get-MailboxStatistics | where {$_.ObjectClass –eq “Mailbox”} | Sort-Object TotalItemSize –Descending | ft @{label=”User”;expression={$_.DisplayName}},@{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}},@{label=”Items”;

    expression={$_.ItemCount}},@{label=”Storage Limit”;expression={$_.StorageLimitStatus}} -auto

    try this too..

    This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing! http://sesaitech.blogspot.in/

    Monday, July 24, 2017 11:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    1

    Get-MailboxStatistics | where {$_.ObjectClass –eq “Mailbox”} | Sort-Object TotalItemSize –Descending | ft @{label=”User”;expression={$_.DisplayName}},@{label=”Total Size (MB)”;expression={$_.TotalItemSize.Value.ToMB()}},@{label=”Items”;

    expression={$_.ItemCount}},@{label=”Storage Limit”;expression={$_.StorageLimitStatus}} -auto

    try this too..

    This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing! http://sesaitech.blogspot.in/

    This is not helpful.  It does not solve any problems.

    \_(ツ)_/

    Monday, July 24, 2017 11:02 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    can you please send me the complete command ?

    PowerShell has a new utility that can be used to learn about commands and syntax.  You should try it as it will help you solve many problems:

    help ForEach-Object -full

    \_(ツ)_/

    Monday, July 24, 2017 11:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    its asking for identity even i m typing nothing happen , means no results on power shell

    did u try with you ?

      
    Monday, July 24, 2017 11:13 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Get-MailboxStatistics -Database "Mailbox Database XXXXXXXXXXXXX" | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending | Export-CSV C:\MBSizes.csv

    Try now..i think my previous one was wrong.

    This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing! http://sesaitech.blogspot.in/

    Monday, July 24, 2017 11:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Get-MailboxStatistics -Database "Mailbox Database XXXXXXXXXXXXX" | Select DisplayName, ItemCount, TotalItemSize | Sort-Object TotalItemSize -Descending | Export-CSV C:\MBSizes.csv

    This posting is provided "AS IS" with no warranties and confers no rights! Always test ANY suggestion in a test environment before implementing! http://sesaitech.blogspot.in/

    Monday, July 24, 2017 11:16 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Balal 

    You need a foreach to be able to get the Samaccount name as this is not part of Get-MailboxStatistics you will also need a blank arrays to capture each properties. The below should work. The only problem i have had with the below is that you have to have powershell V3 or above to add the append command to export-csv. 

    $mailboxes = get-mailbox -resultsize unlimited 
foreach  ($mailbox in $mailboxes) {
$Results=@() 
$properties = @{
SAMAccountName = $mailbox.sAMAccountName
displayName = $mailbox.displayName
TotalItemSize = (get-mailboxstatistics -id $mailbox.distinguishedname).totalitemsize
ItemCount = (get-mailboxstatistics -id $mailbox.distinguishedname).ItemCount
Database = $mailbox.Database
}
$Results += New-Object psobject -Property $properties
$Results | select SAMAccountName,displayName,TotalItemSize,ItemCount,Database | Export-Csv c:\Temp\MAilboxExport.csv -NoTypeInformation -Append
}

    • Marked as answer by Balal Ahmad Tuesday, July 25, 2017 4:36 AM
    Monday, July 24, 2017 4:29 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Dear geoff.phillis 

    this is what i was looking for.

    Thanks 


    Tuesday, July 25, 2017 4:36 AM