Hi Shiva,

Should not be much problem to get it customized, you would just need so extra formatting and output codes.

Please post the full script so the it can be modified as per your current usage.

Your current cmdlets output is just Name,Count nothing

here is the full script I am running

function Load_Exchange_Tools {
 if (-not (Get-pssnapin | ? {$_.name -like 'Microsoft.Exchange.Management.PowerShell.e2010'})) {
  Add-PSSnapin Microsoft.Exchange.Management.PowerShell.e2010
 }
}
Load_Exchange_Tools
Get-MessageTrackingLog -Sender "no-reply@xxx.com" -Start (Get-Date).AddHours(-24) -End (Get-Date).AddHours(0) -resultsize "unlimited" |Group-Object -Property:EventId | Sort-Object Count -Desc | Select Name,Count >d:\rep\xxx.txt

Hi Shiva,

Please find the script below.

ExTrackingLogsCustom.ps1

#Script to extract Exchange Tracking logs and format the output as per custom name.


function Load_Exchange_Tools {
  if (-not (Get-pssnapin | ? {$_.name -like 'Microsoft.Exchange.Management.PowerShell.e2010'})) {
   Add-PSSnapin Microsoft.Exchange.Management.PowerShell.e2010
  }
 }
 Load_Exchange_Tools 



$result = Get-MessageTrackingLog -Sender "no-reply@xxx.com" -Start (Get-Date).AddHours(-24) -End (Get-Date).AddHours(0) -resultsize "unlimited" |Group-Object -Property:EventId | Sort-Object Count -Desc | Select Name,Count


$a = "Name" +"`t"+ "Count" +"`r`n" #This is the header with tab seperator `t for the output
foreach ($i in $result) 
{ 

#Case for replacing the names or keeping the default if no match found
#You can add remove more as required.
switch ($i.Name)

{
     "RECEIVE" {$j="Generated"; break}
     "SEND" {$j="Sent Externally"; break}
     "DELIVER" {$j="Sent Internally- Staff"; break}
     "RESOLVE" {$j="Remove"; break}
     "TRANSFER" {$j="Remove"; break}
     "REDIRECT" {$j="Remove"; break}

     default {$j=$i.Name; break}
}


$a += $j +"`t" + $i.Count +  "`r`n"


}

#$a
out-file -filepath d:\rep\xxx.xls -inputobject $a

Many thanks

Just one more

we do not want the below fields  in the output

    "RESOLVE" {$j="Remove"; break}
     "TRANSFER" {$j="Remove"; break}
     "REDIRECT" {$j="Remove"; break}

-regards

Shiva

Hi Shiva,

Thought so :)

Use the below update; wrap an if{ } statement around the output variable $a.

if ($j -notlike "Remove") {
$a += $j +"`t" + $i.Count +  "`r`n"
}

NOTE:- Don't delete the earlier switch case's "Remove" statements

Thanks a ton,I eventually managed tweaking some values from the script you have provded and got it as required.

Wondering if  output  can be sent directly as a well formatted HTML format ..to the mail recipient ..I have scheduled to run the report and then mail to recipients ..but it goes out as a text attachment in generic format ..Can I format into a more presenable format directly as mail body ?

Thanks in advance ..

Hi Shiva,

Yes that is quite possible, but would require you to have a bit of html knowledge and lots of patience to get the output right.

Below is a link that does it very well.

https://gallery.technet.microsoft.com/office/Exchnage-2010-Database-f6961eb8

Run the schduled task on a Exchange server itself to email it directly.

Exchange 2010 and 2013 Database HTML report via Email:

https://gallery.technet.microsoft.com/office/d9af4a66-a908-4a3f-af10-380aa63c3a74

Thanks for your patience ..Cheers ..

MArking your solution as answer

Good Day! Mate ..you are very helpful.