Try this works pretty well for me
Thx!
Carlos
$csvRows=@()
"=============================================================="
"Start Mailbox Retrieve"
"=============================================================="
$mbx = get-casmailbox -ResultSize unlimited | where
{$_.hasactivesyncdevicepartnership -eq $true -and $_.identity -notlike
"*CAS_{*"} ;
"=============================================================="
"End Mailbox Retrieve"
"=============================================================="
$mbx | foreach {
"Processing: "+$_.name
$name = $_.name;
$device = get-activesyncdevicestatistics -mailbox $_.identity;
if($device){
foreach($dev in $device){
" Device: "+$dev.DeviceType
$csvRows += $dev
}
}
}
"=============================================================="
"Start CSV Write"
"=============================================================="
$csvRows | Export-Csv "c:\Temp\activesync.csv" -NoType
"=============================================================="
"End CSV Write"
"=============================================================="
From: Dan Hyatt [mailto:d...@danhyatt.com]
Sent: Friday, January 13, 2012 12:28 PM
To: MS-Exchange Admin Issues
Subject: RE: ActiveSync Inventory
Hi Jim,
Yes it works... Just need the UPN.
We are on Exchange 2007.
________________________________
From: jimruppre...@ku.edu<mailto:jimruppre...@ku.edu>
To:
exchangelist@lyris.sunbelt-software.com<mailto:exchangelist@lyris.sunbelt-software.com>
Subject: RE: ActiveSync Inventory
Date: Fri, 13 Jan 2012 17:21:29 +0000
I don't have an answer to your question, but I'm wondering if this script
actually runs for you? It throws an error for me.
"Pipeline not executed because a pipeline is already executing. Pipelines
cannot be executed concurrently.
+ CategoryInfo : OperationStopped:
(Microsoft.Power...tHelperRunspace:ExecutionCmdletHelperRunspace) [],
PSInvalidOperationException
+ FullyQualifiedErrorId : RemotePipelineExecutionFailed"
-jim
From: Dan Hyatt [mailto:d...@danhyatt.com]<mailto:[mailto:d...@danhyatt.com]>
Sent: Friday, January 13, 2012 10:35 AM
To: MS-Exchange Admin Issues
Subject: ActiveSync Inventory
Hey guys,
I am trying to export a list that would include the following ActiveSync Device
attributes.
DisplayName, Login, SMTP Address, Devicetype.
I found this script which has everything I need except for the userlogin.
Get-Mailbox | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} |
fl DeviceFriendlyName, Devicetype, DeviceUserAgent, Identity
How would I best also return that data?
Thanks,
Daniel
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe exchangelist
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe exchangelist
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to
listmana...@lyris.sunbeltsoftware.com<mailto:listmana...@lyris.sunbeltsoftware.com>
with the body: unsubscribe exchangelist
_________________________________________________________
This e-mail, including attachments, contains information that is
confidential and may be protected by attorney/client or other privileges.
This e-mail, including attachments, constitutes non-public information
intended to be conveyed only to the designated recipient(s). If you are not
an intended recipient, you are hereby notified that any unauthorized use,
dissemination, distribution or reproduction of this e-mail, including
attachments, is strictly prohibited and may be unlawful. If you have
received this e-mail in error, please notify me by e-mail reply and delete
the original message and any attachments from your system.
_________________________________________________________
---
To manage subscriptions click here:
http://lyris.sunbelt-software.com/read/my_forums/
or send an email to listmana...@lyris.sunbeltsoftware.com
with the body: unsubscribe exchangelist
