Hi,

Thanks for looking (sorry if this posted in the wrong forum!).

I need to get some information from AD/Exchange, what I need to pipe the get-aduser command to get-mailboxstatistics

The information I need is:

SamAccountName, DisplayName, , lastlogintime, EmployeeID, Office, CanonicalName, MailboxSize.

Been trying to get the following working then export to CSV

$users = Get-adUser TestAccount -properties *
$users | Foreach-Object{

    $user = $_
    $stats = Get-MailboxStatistics $user

    New-Object -TypeName PSObject -Property @{
        FirstName = $user.FirstName
        LastName = $user.LastName
        SamAccount = $user.SamAccountName
        Department = $user.Department
        EmployeeID = $user.employeeID
        EmployeeNumber = $user.employeenumber
        Division = $user.Divison
        Office = $user.Office
        OU = $user.canonicalname
        Email = $user.mail
        Mobile = $user.mobilePhone
        LastLogon = $user.lastlogondate
        MailboxSize = $stats.TotalItemSize
        ItemCount =  $stats.ItemCount
            }
}

Any help would be great! Thank you

• Edited by SaintsDT Saturday, April 25, 2015 6:38 PM

$users = Get-ADUser TestAccount -Properties *
$users | Foreach-Object {

    $user = $_
    $stats = Get-MailboxStatistics $user.SamAccountName

    New-Object -TypeName PSObject -Property @{
        FirstName = $user.GivenName
        LastName = $user.SurName
        SamAccount = $user.SamAccountName
        Department = $user.Department
        EmployeeID = $user.EmployeeID
        EmployeeNumber = $user.EmployeeNumber
        Division = $user.Divison
        Office = $user.Office
        OU = $user.CanonicalName
        Email = $user.mail
        Mobile = $user.MobilePhone
        LastLogon = $user.LastLogonDate
        MailboxSize = $stats.TotalItemSize
        ItemCount =  $stats.ItemCount
    }
}

• Proposed as answer by Niko.ChengMicrosoft contingent staff, Moderator Tuesday, April 28, 2015 1:53 AM

Hi Saints,

As Helland post, you need to add ".SamAccountName" or ".name" as below:

$stats = Get-MailboxStatistics $user.SamAccountName

OR

$stats = Get-MailboxStatistics $user.Name

I have test in my lab and it runs successfully, as below:

Best regards,

I also changed

FirstName = $user.FirstName
LastName = $user.LastName

to

FirstName = $user.GivenName
LastName = $user.SurName

Thanks both of you! cant believe I was just missing $user.SamAccountName! (spent hours over weekend on this!).

One final question, how would I export this to CSV? Tried | export-csv c:\test.csv at end but I get an error message

Thanks again!!!

Try this:

$summary = @()
$users = Get-ADUser TestAccount -Properties *
$users | Foreach-Object {

    $user = $_
    $stats = Get-MailboxStatistics $user.SamAccountName

    $obj = New-Object -TypeName PSObject -Property @{
        FirstName = $user.GivenName
        LastName = $user.SurName
        SamAccount = $user.SamAccountName
        Department = $user.Department
        EmployeeID = $user.EmployeeID
        EmployeeNumber = $user.EmployeeNumber
        Division = $user.Divison
        Office = $user.Office
        OU = $user.CanonicalName
        Email = $user.mail
        Mobile = $user.MobilePhone
        LastLogon = $user.LastLogonDate
        MailboxSize = $stats.TotalItemSize
        ItemCount =  $stats.ItemCount
    }
    $summary += $obj
}
$summary | Export-Csv c:\test.csv -NoTypeInformation

• Proposed as answer by Mike CrowleyMVP, Moderator Tuesday, April 28, 2015 9:43 PM
• Marked as answer by SaintsDT 6 minutes ago

Thanks again for all your help!