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

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.

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 
news:uY701VmGIHA.5544@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
>

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

"Mark Arnold [MVP]"  wrote in message 
news:8kvdi3hjtf2em9ul60pd10o0efe2otg4tc@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.

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 
news:3F05F97B-4C30-4053-9120-E40266263A43@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 
> news:uY701VmGIHA.5544@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
>>
>

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.

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 
news:pp3fi3t9om2rk3lrmdlr8l2e9ahhb6agjb@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.

Makes sense.

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


"Adrian"  wrote in message 
news:OQfdIAzGIHA.1188@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 
> news:3F05F97B-4C30-4053-9120-E40266263A43@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 
>> news:uY701VmGIHA.5544@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

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,

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 
news:1193960938.340119.260400@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
>

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,

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 
news:1194003824.389983.33450@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
>

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

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 
news:1194022058.782213.306120@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
>

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!

Mark,

Thanks. I will wait until it is out of beta and has been released for a 
while.

Adrian
"Mark Arnold [MVP]"  wrote in message 
news:j92ni3h5sbpuncpqi588rscbuv2guhcbcr@4ax.com...
> 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!
>