[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


PowerShell Command | Mailbox Statistics Export | Exchange 2007

Posted on 2012-09-21
Medium Priority
Last Modified: 2012-09-29
1- We need to create a report with the statistics informations below for all Active Sync users.
2- We need to run this command and have the results saved into a CSV, TXT file because are thousands of users.

Windows servers 2003
Exchange Servers 2007 Service Pack 3 Rollup 4
- FirstSyncTime : 12/22/2007 1:34:10 AM
- LastSyncAttemptTime : 1/14/2008 7:45:15 AM
- LastSuccessSync : 1/14/2008 7:45:15 AM
- DeviceType : PocketPC
- DeviceID : *******************************
- DeviceModel : WIZA100
- DeviceIMEI : ************21900
- DeviceFriendlyName : Pocket_PC
- Identity : foo@somedomain.com\AirSync-PocketPC-*******************************
Question by:osagarana
  • 2
  • 2
  • 2
LVL 10

Assisted Solution

by:Benjamin MOREAU
Benjamin MOREAU earned 1000 total points
ID: 38421870
Try this command :

Get-mailbox -ResultSize Unlimited  | Get-ActiveSyncDeviceStatistics | export-csv c:\export.csv
LVL 52

Assisted Solution

by:Manpreet SIngh Khatra
Manpreet SIngh Khatra earned 1000 total points
ID: 38421937
You can also try with

Get-Mailbox | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | ft Alias, Device*, Activesync*

List Exchange ActiveSync users and device information in Exchange 2007 and Exchange 2010

Identifying Exchange ActiveSync Users with PowerShell

- Rancy

Accepted Solution

osagarana earned 0 total points
ID: 38422655
Hello To everyone
At first thanks for fast reply. Based on the tw awsers provided by our colleagues, I´ve created the command below.

Get-Mailbox -Resultsize unlimited | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | Select-Object identity, DeviceFriendlyName, Devicetype, DeviceUserAgent, FirstSyncTime, LastSuccessSync | Export-Csv -Path c:\temp\test1.csv -Encoding 'Unicode' -NoTypeInformation
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why


Author Comment

ID: 38424922
I've requested that this question be closed as follows:

Accepted answer: 0 points for osagarana's comment #a38422655

for the following reason:

Colaborative Answers made me get a good result
LVL 10

Expert Comment

by:Benjamin MOREAU
ID: 38423811
If you think that it's collabortive job, you can share your points between experts...
LVL 52

Expert Comment

by:Manpreet SIngh Khatra
ID: 38424923
osagarana: I too say if the issue was resolved with collaborative feedback points should be awarded :)

- Rancy

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you looking for the options available for exporting EDB files to PST? You may be confused as they are different in different Exchange versions. Here, I will discuss some options available.
If you have come across a situation where you need to find some EDB mailbox recovery techniques, then here you will find the same. In this article, we will take you through three techniques using which you will be able to perform EDB recovery. You …
In this video we show how to create an email address policy in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Mail Flow…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question