Site Logo Image Maintenance Scripts

A repository of PowerShell Scripts to automate a variety of IT related maintenance tasks.

© 2023. All rights reserved.

Exch_AdminAuditReport.ps1

Description

@GitHub Copilot - Welcome @BanterBoy, I’m your Copilot and I’m here to help you get things done faster. I can identify issues, explain and even improve code.

You can ask generic questions, but what I’m really good at is helping you with your code. For example:

Generate unit tests for my code Explain the selected code Propose a fix for the bugs in my code If you want to learn more about my capabilities and limitations, check out the Copilot documentation.

I’m powered by AI, so surprises and mistakes are possible. Make sure to verify any generated code or suggestions, and share feedback so that we can learn and improve.

@BanterBoy: - Explain what the script does and why it is useful.

@GitHub Copilot -

Script

# Exchange Server 2010: Agent Log Reports
# This script has been written to run as a scheduled task and email the last 48 hours Agent Logs.
# Version 1.0 - James Pearman, July 2019


#Parameters

$Date = (Get-Date).AddHours(-48)
$EmailTo = "[email protected]"
$EmailFrom = "[email protected]"
$EmailSubject = "Exchange Agent Logs" + $Date
$SMTPServer = "123.456.7.89"
$ReportFileName = "C:\TaskScripts\TaskOut\Exch\ExchAgentLogs.html"

# Load the Microsoft Exchange Server 2010 PowerShell Snapin
If ($Null -eq (Get-PSSnapin -Name Microsoft.Exchange.Management.PowerShell.E2010 -ErrorAction SilentlyContinue)) {
    Add-PsSnapin Microsoft.Exchange.Management.PowerShell.E2010
}

# Map Agent Log Location
New-PSDrive -Name Z -PSProvider FileSystem -Root "\\exchange\c$\Program Files\Microsoft\Exchange Server\V14\TransportRoles\Logs\AgentLog" -Persist

#Create HTML Table

$Style = "<style>"
$Style = $Style + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$Style = $Style + "TH{border-width: 1px;padding: 4px;border-style: solid;border-color: black;background-color: #BDBDBD}"
$Style = $Style + "TD{border-width: 1px;padding: 4px;border-style: solid;border-color: black;}"
$Style = $Style + "</style>"
$Pre = "Exchange Server Admin Log"

#Get Agent Logs

$Logs = Get-AgentLog -Location "Z:\" -StartDate $Date | select-object @{n = 'recipients'; e = { $_.recipients } }, timestamp, P1fromaddress, @{n = 'p2fromaddresses'; e = { $_.p2fromaddresses } }, reasondata

$Logs | ConvertTo-HTML -Head $Style -PreContent $Pre > "$ReportFileName"

#Send Email

$Body = [System.IO.File]::ReadAllText('C:\TaskScripts\TaskOut\Exch\ExchAgentLogs.html')
Send-MailMessage -To $EmailTo -From $EmailFrom -Subject $EmailSubject -Body $Body -BodyAsHtml -SmtpServer $SMTPServer

#Remove Mapped Drive
Remove-PSDrive -Name Z

Back to Top

Download

Please feel free to copy parts of the script or if you would like to download the entire script, simple click the download button. You can download the complete repository in a zip file by clicking the Download link in the menu bar on the left hand side of the page.

Report Issues

You can report an issue or contribute to this site on GitHub. Simply click the button below and add any relevant notes. I will attempt to respond to all issues as soon as possible.

Issue

Back to Top