locked
Formatting recipients message tracking log RRS feed

  • Question

  • Hi,

    Recipients column in below command output has truncated recipients.

    get-messagetrackinglog -Recipients:email@company.com -Start "01/08/2010 09:41:00" -End "12/08/2010 16:51:00" | ft EventId, Source, Sender, Recipients, MessageSubject, Timestamp -wrap

    Can anyone help to get output in column in command shell (do not want to export to csv) with all recipient to show.

    Thanks in advance

    Tuesday, February 14, 2012 2:41 AM

Answers

  • if your results contains more than 16 values EMS will truncate the output..

    to get rid of this.. set formate enumeration limit to -1 which will show you as much as possible

    $FormatEnumerationLimit = -1

     

    Kottees : My Blog : Please mark it as an answer if it really helps you.

    Tuesday, February 14, 2012 4:31 AM

All replies

  • Hi there,

    use -Autosize in end of the command.


    Kottees : My Blog : Please mark it as an answer if it really helps you.

    Tuesday, February 14, 2012 3:41 AM
  • hi Kottees,

    I even tried -autosize at the end, but still recipient column truncates with .....

    Regards,

    Tuesday, February 14, 2012 3:50 AM
  • it looks good for me... can you paste the screen shot if possible..

    Kottees : My Blog : Please mark it as an answer if it really helps you.

    Tuesday, February 14, 2012 3:59 AM
  • On Tue, 14 Feb 2012 02:41:21 +0000, Exchange_support wrote:
     
    >Recipients column in below command output has truncated recipients.
    >
    >get-messagetrackinglog -Recipients:email@company.com -Start "01/08/2010 09:41:00" -End "12/08/2010 16:51:00" | ft EventId, Source, Sender, Recipients, MessageSubject, Timestamp -wrap
    >
    >Can anyone help to get output in column in command shell (do not want to export to csv) with all recipient to show.
     
    You'll have to use an 'expression' to expand the recipients if they
    number more than the default format allows.
     
    Where you have "Recipients", replace that with this:
     
    @{n='Recipients';e={[string]::join(";", ($_.Recipients))}}
     
    ---
    Rich Matheisen
    MCSE+I, Exchange MVP
     

    --- Rich Matheisen MCSE+I, Exchange MVP
    Tuesday, February 14, 2012 4:22 AM
  • Hello,

    Find output below with last command. -wrap -autosize

    Kindly advice.

    Regards,



    Tuesday, February 14, 2012 4:27 AM
  • if your results contains more than 16 values EMS will truncate the output..

    to get rid of this.. set formate enumeration limit to -1 which will show you as much as possible

    $FormatEnumerationLimit = -1

     

    Kottees : My Blog : Please mark it as an answer if it really helps you.

    Tuesday, February 14, 2012 4:31 AM
  • Hello Kottees,

    Nice catch. By defalut $FormatEnumerationLimit was set to 16 & Total recipients were 20 dats why it was truncating above 16.

    Appreciate.

    Regards,

    Tuesday, February 14, 2012 5:18 AM
  • Now the million dollar question.. output that CSV.. EASY.. but how the heck do you get each recipient to be on it's own row in excel? I can import the csv into excel.. and do some manipulation but how do you do this directly with powershell so that the output looks like this when imported into excel.  What I see above when imported into excel will case the recipients to be on one HUGE long row... 

    Timestamp         Sender Recipients           Recipients

    5/14/2013 10:46 john@contoso.com       jim@consoto.com;

    5/14/2013 10:46 john@contoso.com       jack@contso.com;

    5/14/2013 10:46 john@contoso.com       bob@contoso.com 

    Wednesday, May 15, 2013 1:33 PM
  • Hi,

    Answered in another thread 

    http://social.technet.microsoft.com/Forums/en-US/exchangesvradmin/thread/9519f3ce-18b0-4930-ba55-667c73af7560/ 


    Kottees : My Blog : Please mark it as an answer if it really helps you.

    Thursday, May 16, 2013 8:22 AM
  • My issue was resolved after just typing 

    $FormatEnumerationLimit in shell

    where it shows 

    16

    and in next line it was resolved as 

    C:\Windows\system32>$FormatEnumerationLimit=-1

    it makes it unlimited


    Nawaz

    Wednesday, October 14, 2015 2:03 PM