[PS][EX2010] E-mails Recieved per day of Month Report

.Synopsis
E-mail Counting Script v1 by ELAU 10/10/19
– Script counts emails received for each day of the current month
.DESCRIPTION
– Script pulls days of the month and counts number of emails received for each day of the current month or days specified into a HTML report.
– Script allows option to e-mail report
.EXAMPLE
– Run count.ps1 without parameters will prompt for required options
.EXAMPLE
– Specify days to go back without sending email report

count.ps1 -mailbox <mailbox to search> -day <days to search back from today>

.EXAMPLE
– Specify days to go back with sending email report

count.ps1 -mailbox <mailbox to search> -day <days to search back from today> -emailto <report to send to>

<#
   .Synopsis
      E-mail Counting Script v1 by EPIC 10/10/19
      – Script counts emails received for each day of the current month
   .DESCRIPTION
      – Script pulls days of the month and counts number of emails received for each day of the current month or days specified into a HTML report.
      – Script allows option to e-mail report
   .EXAMPLE
      – Run count.ps1 without parameters will prompt for required options
   .EXAMPLE
      – Specify days to go back

      count.ps1 -mailbox <mailbox to search> -day <days to search back from today>

   .EXAMPLE
      – Specify days to go back and email report

       count.ps1 -mailbox <mailbox to search> -day <days to search back from today> -emailto <report to send to>
  
   #>

# Parameters
Param(
[Parameter(position=1)]
[string]$mailbox,
[Parameter(position=2)]
[string]$day,
[Parameter(position=3)]
[string]$emailto
)

# Setup Variables
$smtpServer = “smtpserver.com”
$emailFrom = “from@address.com”
$subject = “Recieved e-mails per day”
$Path = “c:\temp\test.html”

[INT]$year = (Get-date).ToString(“yy”)
[INT]$month = (Get-date).ToString(“MM”)
$monthheader = (Get-date).ToString(“MMMM,yyyy”)

# Prompts for input if no parmeters provided
if (!$day)
{
[INT]$day = (Get-date).ToString(“dd”)
[INT]$days = [datetime]::DaysInMonth($year,$month)
}

if (!$mailbox)
{
$mailbox = Read-Host -Prompt “Mailbox to Search (user@firstrepublic.com)”
}

If ($emailto)
{
$email = “sure”
}
elseif (!$emailto)
{

$email = Read-Host -Prompt “E-mail Report : Yes or No”
while(“yes”,”no” -notcontains $email)
{
$email = Read-Host -Prompt “E-mail Report : Yes or No”
} 

}

if ($email -eq “yes”)
{
$emailTo = Read-Host -Prompt “E-mail to send Report (user@firstrepublic.com)”
} 

#HTML HEADER
$head = @”
<title>E-mail Report</title>
<style type=”text/css”>
table, td { border: 1px solid black; border-collapse:collapse;}
tr:nth-child(odd) { background-color:lightgrey; }
th { color:black;
  text-align:left;
  border: 1px solid black;
  font:normal 16px verdana, arial, helvetica, sans-serif;
  font-weight:bold;
  background-color: #6495ED;
  padding-left:6px;
  padding-right:6px;
}
</style>
“@

# HTML TABLE HEADER
$body += @”
<table>
<tr><th colspan=”2″>$monthheader – $mailbox</th></tr>
<tr>
    <td>Date</td>
    <td>E-mails Recieved</td>
</tr>
  
“@

# Performs the search and adds HTML ROWs

$i=1
Do {


$start = ((get-date -hour 0 -Minute 0 -Second 0).adddays(-($day-$i+1)))
$shortstart = ((get-date).adddays(-($day-$i+1)).ToString(“MM-dd-yyyy”))
$end = ((get-date -hour 0 -Minute 0 -Second 0).adddays(-($day-($i))))   

 
$emails = Get-TransportServer | Get-MessageTrackingLog -ResultSize Unlimited -Start $start -End $end -EventId “Receive” -Recipient $mailbox
$count = ($emails | Measure-Object).count

$body += @”
<tr>
    <td>$shortstart</td>
    <td>$count</td>
</tr>
“@
$i++
    }
While ($i -le $day)



# HTML FOOTER
$body += @”
</table>
“@

# Add HTML together and ouputs report
$HTML = $head + $body
$HTML | Out-File $Path

# Sends e-mail if email is requested
if ($email -eq “yes” -or $email -eq “sure”)
{
Send-MailMessage -From $emailFrom -To $emailTo -Subject $Subject -Body $HTML -BodyAsHtml -SmtpServer $smtpServer -EA Stop 2>> $errorlog
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

.Synopsis

E-mail Counting Script v1 by EPIC 10/10/19

– Script counts emails received for each day of the current month

.DESCRIPTION

– Script pulls days of the month and counts number of emails received for each day of the current month or days specified into a HTML report.

– Script allows option to e-mail report

.EXAMPLE

– Run count.ps1 without parameters will prompt for required options

.EXAMPLE

– Specify days to go back

count.ps1 -mailbox <mailbox to search> -day <days to search back from today>

.EXAMPLE

– Specify days to go back and email report

count.ps1 -mailbox <mailbox to search> -day <days to search back from today> -emailto <report to send to>

# Parameters

Param(

[Parameter(position=1)]

[string]$mailbox,

[Parameter(position=2)]

[string]$day,

[Parameter(position=3)]

[string]$emailto

)

# Setup Variables

$smtpServer = “smtpserver.com”

$emailFrom = “from@address.com”

$subject = “Recieved e-mails per day”

$Path = “c:\temp\test.html”

[INT]$year = (Get-date).ToString(“yy”)

[INT]$month = (Get-date).ToString(“MM”)

$monthheader = (Get-date).ToString(“MMMM,yyyy”)

# Prompts for input if no parmeters provided

if (!$day)

{

[INT]$day = (Get-date).ToString(“dd”)

[INT]$days = [datetime]::DaysInMonth($year,$month)

}

if (!$mailbox)

{

$mailbox = Read-Host -Prompt “Mailbox to Search (user@firstrepublic.com)”

}

If ($emailto)

{

$email = “sure”

}

elseif (!$emailto)

{

$email = Read-Host -Prompt “E-mail Report : Yes or No”

while(“yes”,“no” -notcontains $email)

{

$email = Read-Host -Prompt “E-mail Report : Yes or No”

}

if ($email -eq “yes”)

{

$emailTo = Read-Host -Prompt “E-mail to send Report (user@firstrepublic.com)”

}

#HTML HEADER

$head = @”

<title>E-mail Report</title>

table, td { border: 1px solid black; border-collapse:collapse;}

tr:nth-child(odd) { background-color:lightgrey; }

th { color:black;

text-align:left;

border: 1px solid black;

font:normal 16px verdana, arial, helvetica, sans-serif;

font-weight:bold;

background-color: #6495ED;

padding-left:6px;

padding-right:6px;

}

</style>

“@

# HTML TABLE HEADER

$body += @”

<table>

<tr><th colspan=”2″>$monthheader – $mailbox</th></tr>

<tr>

<td>E-mails Recieved</td>

</tr>

“@

# Performs the search and adds HTML ROWs

$i=1

Do {

$start = ((get-date -hour 0 -Minute 0 -Second 0).adddays(–($day–$i+1)))

$shortstart = ((get-date).adddays(–($day–$i+1)).ToString(“MM-dd-yyyy”))

$end = ((get-date -hour 0 -Minute 0 -Second 0).adddays(–($day–($i))))

$emails = Get-TransportServer | Get-MessageTrackingLog -ResultSize Unlimited -Start $start -End $end -EventId “Receive” -Recipient $mailbox

$count = ($emails | Measure-Object).count

$body += @”

<tr>

<td>$shortstart</td>

<td>$count</td>

</tr>

“@

$i++

}

While ($i -le $day)

# HTML FOOTER

$body += @”

</table>

“@

# Add HTML together and ouputs report

$HTML = $head + $body

$HTML | Out-File $Path

# Sends e-mail if email is requested

if ($email -eq “yes” -or $email -eq “sure”)

{

Send-MailMessage -From $emailFrom -To $emailTo -Subject $Subject -Body $HTML -BodyAsHtml -SmtpServer $smtpServer -EA Stop 2>> $errorlog

}

epic

Contributer and Author Enterprise Communications Engineer Hi Epic

theelau@gmail.com

415-000-0000

testest test