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
Hi,
Can u post here what command u used for this?
Recipients seems a multivalued property, and for them u cant just write them to a CSV file in a simple way.
Regards,
Laeeq Qazi|Team Lead(Exchange + Sharepoint + BES + DynamicsCRM) www.HostingController.com
Free Windows Admin Tool Kit Click here and download it now
February 27th, 2010 2:53am
I don't need these, thanks for your input.
MaelitoMaelito
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.
Free Windows Admin Tool Kit Click here and download it now
March 14th, 2011 5:19pm
Can someone please address this. having same issue.
Thanks - SJMP
June 2nd, 2011 10:54pm
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
Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2011 2:33pm