导出Exchang报表结果异常！！！

通过如下命令导出Exchange 报表，结果异常。
[PS] C:\>
Get-MessageTrackingLog -Start "11/04/2014 00:00:00" -End "11/04/2014 11:20:00" -ResultSize unlimited -EventId s
end | Where-Object {$_.Sender -eq "minzhe@XXX.com"} |Select-Object time,eventid,recipients,recipientstatus
| Export-Csv -NoTypeInformation -encoding utf8 d:\minzhe.csv

结果如下：（怎么显示成“System.String[]","System.String[]"？）

"Time","EventId","Recipients","RecipientStatus"
"2014/11/4 10:10:50","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:53","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:53","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:54","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:55","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:55","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:55","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:55","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:55","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:56","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:57","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:58","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:58","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:59","SEND","System.String[]","System.String[]"
"2014/11/4 10:10:59","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:00","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:00","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:00","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:01","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:01","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:01","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:02","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:02","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:02","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:02","SEND","System.String[]","System.String[]"
"2014/11/4 10:11:02","SEND","System.String[]","System.String[]"

opop

2014-11-04 16:39

这是因为Recipient和RecipientStatus是Object，可能有多值，所以显示成"System.String[]"。

可以尝试下列命令解决该问题：

Get-MessageTrackingLog -Start "11/04/2014 00:00:00" -End "11/04/2014 11:20:00" -ResultSize unlimited -EventId s
end | Where-Object {$_.Sender -eq "minzhe@XXX.com"} |Select-Object time,eventid,@{l="Recipients";e={$_.Recipients -join " "}},@{l="RecipientStatus";e={$_.RecipientStatus -join ","}} | Export-Csv -NoTypeInformation -encoding utf8 d:\minzhe.csv

cisco1181788	2014-12-22 11:09
opop:这是因为Recipient和RecipientStatus是Object，可能有多值，所以显示成"System.String[]"。可以尝试下列命令解决该问题： Get-MessageTrackingLog -Start "11/04/2014 00:00:00" -End "11/04/2014 11:20:00" -ResultSize unlimited -EventId s . .. (2014-11-04 16:39) 哦，明白了，那么多个值还可以进一步过滤删选吗？

opop	2014-12-22 17:10
cisco1181788:哦，明白了，那么多个值还可以进一步过滤删选吗？(2014-12-22 11:09)嬀/color] 可以用-Contains参数筛选多值吧

查看完整版本: [-- 导出Exchang报表结果异常！！！ --] [-- top --]

Powered by phpwind v8.7.1 Code ©2003-2011 phpwind
Time 0.018950 second(s),query:6 Gzip enabled