Export message tracking results to excel not fully populated
HiI have managed to export a message tracking file into csv then excel but not all the info is showing on the csv comparing to the EMC > Toolbox > Message Tracking gui.On the gui > Message Tracking Results > Field "RECIPIENTS" > I can see many many mailbox all separated by comma , but on the report I see RECIPIENTS = SYSTEM STRING []If there is a single mailbox I will see it but if there is more than one I see SYSTEM STRING []Maelito
February 26th, 2010 6:03pm
I don't need these, thanks for your input.
MaelitoMaelito
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2010 11:53am
I am trying the same with the cmdlet:
[PS] C:\>get-messagetrackinglog -Sender email@domain.com -Start "1/1/2011 9:54:00 AM" -End "3/14/2011 10:04:00 A
M" | export-csv c:\from-sending-export.csv
System.String[] is returned for recipients column.
March 14th, 2011 10:34am
Can someone please address this. having same issue.
Thanks - SJMP
Free Windows Admin Tool Kit Click here and download it now
June 2nd, 2011 4:07pm
Can someone please address this. having same issue.
Thanks - SJMP
Hi,
Here it is:
Get-MessageTrackingLog -Sender administrator@domain.om | Select Sender,@{Name=’Recipients’;Expression={[string]::join(";", ($_.Recipients))}} | export-csv c:\from-sending-export.csv -NoTypeInformation
You have to look at this expression
@{Name=’Recipients’;Expression={[string]::join(";", ($_.Recipients))}}
which is extracting values from a mutlivalue property.Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM)
www.HostingController.com
June 3rd, 2011 7:43am