Help with Powershell Cmd

Need Help with Getting an overview of all ActiveSync devices in the Exchange-organization in a Comma Separated Format.

I have been working with this but cant get the username format to run correctly

Get-Mailbox -ResultSize Unlimited | ForEach {
#$user = $mailbox.DisplayName
$deviceinfo.User = $mailbox.DisplayName
Get-MobileDeviceStatistics -Mailbox:$_.Identity |
Select-Object @{label="User" ; expression={$deviceinfo.User}},DeviceOS, lastsuccesssync

}

It just repeats the same user.

Thanks in advance

jyoung127

Asked: 2016-09-02

Advertise Here

1 Solution

LVL 40

SubsunCommented: 2016-09-02

Try this..

Get-Mailbox -ResultSize Unlimited | ForEach {
     $User = $_.DisplayName
    Get-MobileDeviceStatistics -Mailbox:$_.Identity |
    Select-Object @{label="User" ; expression={$User}},DeviceOS,lastsuccesssync   
 }

Open in new window

jyoung127Author Commented: 2016-09-02

awesome thank you so much
i was so close.

LVL 40

SubsunCommented: 2016-09-02

Yes.. $mailbox was not defined in the current script, so that values was picked possibly from a previous code which ran on the PS console. I changes it to get values form PS pipeline to fix it..

jyoung127Author Commented: 2016-09-02

Hey follow up is there a way to get this exported out to a file? csv

LVL 40

SubsunCommented: 2016-09-02

Use Export-csv ..

Get-Mailbox -ResultSize Unlimited | ForEach {
     $User = $_.DisplayName
    Get-MobileDeviceStatistics -Mailbox:$_.Identity |
    Select-Object @{label="User" ; expression={$User}},DeviceOS,lastsuccesssync   
 }| Export-csv C:\temp\report.csv -nti

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

Help with Powershell Cmd

Join & Write a Comment Already a member? Login.

Featured Post