<div>
Yes all you need to do is the following...<br />
<br />

<pre><code id="code-20-39784083-1">Get-Mailbox -resultsize unlimited | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | select identity, lastsuccesssync, DeviceType | out-file c:\filename.csv</code></pre>
<br />
Will.
</div>


Yes all you need to do is the following...



Get-Mailbox -resultsize unlimited | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | select identity, lastsuccesssync, DeviceType | out-file c:\filename.csv


Will.

<div>
<div class="content wysiwyg-content">
Hi guys<br />
<br />
I can use <br />
Get-Mailbox -resultsize unlimited | ForEach {Get-ActiveSyncDeviceStati<wbr />stics -Mailbox:$_.Identity} | ft identity, lastsuccesssync, Devicetype<br />
to get them in powershell. or output it to a csv file.<br />
<br />
but the format is not what i want. the csv only has one column.<br />
<br />
does any one know a way to output the result into a csv file with three columns?<br />
<br />
thanks a lot.<br />
<br />
SYH
</div>
</div>


Hi guys

I can use 
Get-Mailbox -resultsize unlimited | ForEach {Get-ActiveSyncDeviceStatistics -Mailbox:$_.Identity} | ft identity, lastsuccesssync, Devicetype
to get them in powershell. or output it to a csv file.

but the format is not what i want. the csv only has one column.

does any one know a way to output the result into a csv file with three columns?

thanks a lot.

SYH

powershell output csv format

Windows PowerShell is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework. PowerShell provides full access to the Component Object Model (COM) and Windows Management Instrumentation (WMI), enabling administrators to perform administrative tasks on both local and remote Windows systems as well as WS-Management and Common Information Model (CIM) enabling management of remote Linux systems and network devices.

Powershell

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

The term 'shell' refers to a general class of text-based command interpreters most often associated with the UNIX and Linux operating systems. Popular shells include Bourne, Debian Almquist (dash), Korn (ksh), Bourne Again (bash) and the C shell family (csh). Some view the DOS 'cmd' prompt as a minimal shell of sorts. It is also possible to install Cygwin on Windows and emulate a full Unix environment with complete shell capabilities. Terminal emulators, such as xterm, GNOME Terminal and OS X Terminal, can be used to access shell.