Hi

please do help me to generate report, who have last logged into exchange, i need samaccountname also,I am using Exchange Server 2013.

I am trying to run this report but it doesnot show

Get-MailboxStatistics -Database "MyExchangeDB" | Select DisplayName, SamAccountName, LastLogged
OnUserAccount, ItemCount, TotalItemSize, LastLogonTime |  Export-CSV C:\mailbox.csv 

please do help me to add email address in this report and also enabled users in active directory

• Edited by Risingflight Wednesday, May 20, 2015 2:02 PM g

Hi Risingflight,

Try the following command :

foreach($users in Get-ADuser -filter *){
$users | Foreach-Object {
    $user = $_
    $stats = Get-MailboxStatistics $user.Name
    New-Object -TypeName PSObject -Property @{
        DisplayName = $stats.DisplayName
        SamAccount = $user.SamAccountName
        LastLoggedOnUserAccount = $stats.LastLoggedOnUserAccount
        ItemCount = $stats.ItemCount
        TotalItemSize = $stats.TotalItemSize
        LastLogonTime = $stats.LastLogonTime
        
    }
}
}

Best re