get-mailbox | Get-mailboxstatistics -IncludeMoveHistory | Select -Property
Displayname, lastlogontime, @{Name = 'MoveHistory'; Expression = {
$_.MoveHistory -join ' '; }; } | Export-csv -Path
$env:userprofile\desktop\mailbox_migration_history.csv -NoTypeInformation Cheers, Trevor Sullivan From: listsad...@lists.myitforum.com [mailto:listsad...@lists.myitforum.com] On Behalf Of christopher.catl...@us.sogeti.com Sent: Thursday, February 13, 2014 10:37 AM To: powershell@lists.myitforum.com Subject: [powershell] Struggling to get as script finished. exporting to csv (one value is an array) get-mailbox | Get-mailboxstatistics -IncludeMoveHistory | Select -Property Displayname, lastlogontime, movehistory | Export-csv -Path $env:userprofile\desktop\mailbox_migration_history.csv -NoTypeInformation MoveHistory is an array Below is an example of the formatting. Ideally I'd like to be able to split this up, but getting it into a single field would suffice for this endeavor {(10/16/2013 7:50:48 AM: TargetMDB=2013 Offload, Size=1.536 GB (1,649,437,692 bytes), Duratio n=13:43:13), (6/7/2013 1:34:22 AM: Failed, TargetMDB=NAMPR05DG011-db027, Error=Error: Cannot find a recipient that has mailbox GUID 'c2ac24be-3718-446d-8d2f-0b4ec16e4d62'.)} Christopher Catlett Consultant | Detroit Sogeti USA Office 248-876-9738 |Fax 877.406.9647 26957 Northwestern Highway, Suite 130, Southfield, MI 48033-8456 <http://www.us.sogeti.com/> www.us.sogeti.com ================================================ Did you know you can also post and find answers on PowerShell in the forums? http://www.myitforum.com/forums/default.asp?catApp=1 ================================================ Did you know you can also post and find answers on PowerShell in the forums? http://www.myitforum.com/forums/default.asp?catApp=1
<<image001.jpg>>
