List data transferred by each device

Adrian · Joined: 05 Aug 2007 Posts: 28

Exchange 2007

Is there an easy way to list by device how much data has been sent and
received via ActiveSync over a set period e.g.. the last month?

Thanks for any advice.

Adrian

Archived from group: microsoft>public>exchange>mobility

Mark Arnold [MVP] · Joined: 05 Aug 2007 Posts: 1126

On Mon, 29 Oct 2007 19:53:59 -0000, "Adrian"
wrote:

>Exchange 2007
>
>Is there an easy way to list by device how much data has been sent and
>received via ActiveSync over a set period e.g.. the last month?
>
>Thanks for any advice.
>
>Adrian
>
The export-activesynclog is the closest I think you can get out of the
box.

John Oliver, Jr. [MVP] · Joined: 05 Aug 2007 Posts: 823

In addtion to Marks comments, why or and for what purpose?

--
John Oliver, Jr
MCSE, MCT, CCNA
Exchange MVP 2008
Microsoft Certified Partner

"Adrian" wrote in message @TK2MSFTNGP02.phx.gbl...
> Exchange 2007
>
> Is there an easy way to list by device how much data has been sent and
> received via ActiveSync over a set period e.g.. the last month?
>
> Thanks for any advice.
>
> Adrian
>

Adrian · Joined: 05 Aug 2007 Posts: 28

Thanks. I think I had a look at that but without much success.

"Mark Arnold [MVP]" wrote in message @4ax.com...
> On Mon, 29 Oct 2007 19:53:59 -0000, "Adrian"
> wrote:
>
>>Exchange 2007
>>
>>Is there an easy way to list by device how much data has been sent and
>>received via ActiveSync over a set period e.g.. the last month?
>>
>>Thanks for any advice.
>>
>>Adrian
>>
> The export-activesynclog is the closest I think you can get out of the
> box.

Adrian · Joined: 05 Aug 2007 Posts: 28

We have a shared data account and we would like an idea of how much data
each user is transferring each month. I know we can get it from the devices
but I thought I read somewhere it was possible to get this from the Exchange
server.

"John Oliver, Jr. [MVP]" wrote in message @microsoft.com...
> In addtion to Marks comments, why or and for what purpose?
>
> --
> John Oliver, Jr
> MCSE, MCT, CCNA
> Exchange MVP 2008
> Microsoft Certified Partner
>
>
> "Adrian" wrote in message
> @TK2MSFTNGP02.phx.gbl...
>> Exchange 2007
>>
>> Is there an easy way to list by device how much data has been sent and
>> received via ActiveSync over a set period e.g.. the last month?
>>
>> Thanks for any advice.
>>
>> Adrian
>>
>

Mark Arnold [MVP] · Joined: 05 Aug 2007 Posts: 1126

Well, if it's actually worth it then
http://www.mobiletopsoft.com/board/view.php?newsid=783 will help you
but I work on the principle that it's 2007 and prices are cheap enough
to just pay the damn bill. Unless of course you're in a country with a
3rd world attitude to mobile telephony like, ohhh, I don't know, the
USA for example.

Adrian · Joined: 05 Aug 2007 Posts: 28

Mark,

Thanks. I am not too bothered as we can get the details from the users'
phone. I just thought it might be something that was easy to find out on the
server.

Adrian.

"Mark Arnold [MVP]" wrote in message @4ax.com...
> Well, if it's actually worth it then
> http://www.mobiletopsoft.com/board/view.php?newsid=783 will help you
> but I work on the principle that it's 2007 and prices are cheap enough
> to just pay the damn bill. Unless of course you're in a country with a
> 3rd world attitude to mobile telephony like, ohhh, I don't know, the
> USA for example.

John Oliver, Jr. [MVP] · Joined: 05 Aug 2007 Posts: 823

Makes sense.

--
John Oliver, Jr
MCSE, MCT, CCNA
Exchange MVP 2008
Microsoft Certified Partner

"Adrian" wrote in message @TK2MSFTNGP04.phx.gbl...
> We have a shared data account and we would like an idea of how much data
> each user is transferring each month. I know we can get it from the
> devices but I thought I read somewhere it was possible to get this from
> the Exchange server.
>
> "John Oliver, Jr. [MVP]" wrote in message
> @microsoft.com...
>> In addtion to Marks comments, why or and for what purpose?
>>
>> --
>> John Oliver, Jr
>> MCSE, MCT, CCNA
>> Exchange MVP 2008
>> Microsoft Certified Partner
>>
>>
>> "Adrian" wrote in message
>> @TK2MSFTNGP02.phx.gbl...
>>> Exchange 2007
>>>
>>> Is there an easy way to list by device how much data has been sent and
>>> received via ActiveSync over a set period e.g.. the last month?
>>>
>>> Thanks for any advice.
>>>
>>> Adrian
>>>
>>
>
>

Daniel Noakes · Joined: 01 Nov 2007 Posts: 9

Adrian

You need to be delegated Exchange Recipient Administrator, have
created the output directory, have enabled logging on the IIS site and
have read permissions to the logs.
>From EMS run, Export-ActiveSyncLog -FileName: "c:\logs
\w3svc1\ex071001.log" -StartDate:"01/10/07" -EndDate:"30/10/07" -
OutputPath:"c:\reports"
Obviously you need change the log path and file name.

Total Sent Bytes and Total Received Bytes are listed in c:\reports
\users.csv.

Hope that gets Export-ActiveSyncLog working.

Daniel Noakes

Adrian · Joined: 05 Aug 2007 Posts: 28

Daniel,

Thanks. I have tried your suggestion. However it always seems to report just
the one day (in the example below it would be for 1/10/2007), and the bytes
sent and received field (in the users.csv) is always zero. Do you have any
suggestions?

Adrian.

"Daniel Noakes" wrote in message @y42g2000hsy.googlegroups.com...
> Adrian
>
> You need to be delegated Exchange Recipient Administrator, have
> created the output directory, have enabled logging on the IIS site and
> have read permissions to the logs.
>>From EMS run, Export-ActiveSyncLog -FileName: "c:\logs
> \w3svc1\ex071001.log" -StartDate:"01/10/07" -EndDate:"30/10/07" -
> OutputPath:"c:\reports"
> Obviously you need change the log path and file name.
>
> Total Sent Bytes and Total Received Bytes are listed in c:\reports
> \users.csv.
>
> Hope that gets Export-ActiveSyncLog working.
>
> Daniel Noakes
>

Daniel Noakes · Joined: 01 Nov 2007 Posts: 9

Adrian

That is correct, all of the data needs to be in one log file. I see
two options:
1. Merge the log files (manually, or using PowerShell)
2. Set the new log schedule on the site to monthly.

Daniel Noakes

Adrian · Joined: 05 Aug 2007 Posts: 28

Daniel,

Thank you very much. I have changed the log schedule to monthly.

Below is one of our Users.csv log (with names and IMEI's changed). What
might be the reason that it does not show bytes sent and received?

User Name,Device ID,Device Type,Items Sent,Items Received,Hits,Total Bytes
Sent,Total Bytes Received,Total Emails Sent,Total Emails Received,Total
Calendar Sent,Total Calendar Received,Total Contacts Sent,Total Contacts
Received,Total Tasks Sent,Total Tasks Received,Total OOF Messages Set by
Client,Total OOF Messages Retrieved from Server,Total Searches
requested,Total SharePoint Access,Total UNC Access,Total Attachment
Downloads,Total Attachment Size,Currently Compliant with Policy
abc\Smith,IMEIxxxxxxxxxxxxxxx,IMEIxxxxxxxxxxxxxxx,38,4,9,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,Unknown
abc\Jones,IMEIxxxxxxxxxxxxxxx,IMEIxxxxxxxxxxxxxxx,5,1,3,0,0,1,0,4,0,0,1,0,0,0,0,0,0,0,0,0,Unknown
*** Total ***,,,43,5,12,0,0,,,,,,,,,,,,,,,,

Thanks again for your help.

Adrian.

"Daniel Noakes" wrote in message @19g2000hsx.googlegroups.com...
> Adrian
>
> That is correct, all of the data needs to be in one log file. I see
> two options:
> 1. Merge the log files (manually, or using PowerShell)
> 2. Set the new log schedule on the site to monthly.
>
> Daniel Noakes
>

Daniel Noakes · Joined: 01 Nov 2007 Posts: 9

Adrian

I'm on the E12 SP1 TAP so have been running SP1 for a while. Didn't
trying running EAS reports before deploying it.
I take it you have not installed the SP1 beta? That is the only thing
I think it can be, so it looks like you'll have to wait until it is
released.

Daniel Noakes

Adrian · Joined: 05 Aug 2007 Posts: 28

Daniel,

I am very grateful for your help. No, we have not installed the SP1 beta.

When we do install SP1 I will post here with what the outcome is.

Adrian.

"Daniel Noakes" wrote in message @57g2000hsv.googlegroups.com...
> Adrian
>
> I'm on the E12 SP1 TAP so have been running SP1 for a while. Didn't
> trying running EAS reports before deploying it.
> I take it you have not installed the SP1 beta? That is the only thing
> I think it can be, so it looks like you'll have to wait until it is
> released.
>
> Daniel Noakes
>

Mark Arnold [MVP] · Joined: 05 Aug 2007 Posts: 1126

Be careful though. I suspect Daniel has a different SP1 build from
the one you will be able to download.
If he hasn't he should have because I have!

0x86000108 on Device again Hi there, since last post I tried many different things. Without any success: 1. Exported Mailbox to pst with exmerge -> scanpst. 2. checked exchange store with eseutil... 3. reinstalled Oma and Activesync virtual directories. 4. Tested syncing with diffe

mobile device recommendation Hi all, we are in the phases of rolling out SBS 2003 Premium with Exchange. Some of our users wish to have mobile devices that hot sync with Exchange and email Our current mobile service is through Verizon Wireless and they offer 2 such uni

forwarding email to a mobile device Hello All, I am looking for a simple hook from MS Exchange 2003. I need to forward an incomming mail to a mobile device. I need to send a new copy of the mail, because my mobile service provider ignores the message, if it is forwarded. Is there any API ho

How do I stop parternship with a mobile device I have a user using a smartphone (treo 700w) to connect to my exchange server and sync e-mail, contacts, calendar etc. The user is going to work somewhere else and wants to set the device up with the new company. Apparently there is something (according t

Managed contacts on mobile device Hi, I'm looking for a way to have centrally managed contacts distributed to Windows Mobile 6 devices. We have about 80 users in a dial plan, all of which use a WM6 mobile phone, where calls between users are free. We'd like to centrally manage and distrib