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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics