DataProtectionManagerCX

1.3.0

Functions/New-DPMCXServerConfigurationReport.ps1

function New-DPMCXServerConfigurationReport
{
 [CmdletBinding()]
  param (
    [ValidateNotNullOrEmpty()]
    [PSCredential] $Credential,
    [Parameter(Position = 0, ValueFromPipeline = $true, ValueFromPipelineByPropertyName = $true)]
    [ValidateNotNullOrEmpty()]
    [string[]] $DpmServerName = 'localhost',
    [string] $ReportPath,
    [string] $MailEncoding = 'Default',
    [string] $MailFrom,
    [string[]] $MailTo,
    [string] $MailSubject = 'DPM Configuration Status Report',
    [string] $SMTPServer
  )

$ReportGeneratedTimeStamp = Get-Date

$parameters = @{
DpmServerName = $DpmServerName
}

if ($PSBoundParameters.ContainsKey('Credential')) {

$parameters.Add('Credential',$Credential)

}

$DPMServerConfigurationStatus = Get-DPMCXServerConfiguration @parameters

# To do: Error handling and prompt for automatic install using PowerShellGet
Import-Module PScribo

$document = Document 'Server Configuration Status Report' {

                
    Section -Style Heading1 'DPM Servers' {


        Section -Style Heading2 'Server Configuration Status Report' {
            
        Paragraph -Style Heading3 "Report generated at: $ReportGeneratedTimeStamp"
        Paragraph -Style Heading3 "Report generated on computer: $($env:computername)"
                                  
           $DPMServerConfigurationStatus | Select-Object @{
                  n = 'DPM Server'
                  e = {
                    $_.DPMServer
                  }
                },Connection,Version,
                @{
                  n = 'Active Alerts'
                  e = {
                    $_.ActiveAlerts
                  }
                },
                @{
                  n = 'Agents'
                  e = {
                    $_.ProtectedServers
                  }
                },
                Volumes,
                @{
                  n = 'Vss Snapshots'
                  e = {
                    $_.VssSnapshots
                  }
                },
                @{
                  n = 'Total Disk Capacity'
                  e = {
                    $_.TotalDiskCapacity
                  }
                },
                @{
                  n = 'Unallocated Disk Capacity'
                  e = {
                    $_.UnallocatedDiskCapacity
                  }
                },
                @{
                  n = 'Latest DPM DB Backup'
                  e = {
                    $_.LatestDPMDBBackup
                  }
                },                
                @{
                  n = 'RAM'
                  e = {
                    $_.TotalRAM
                  }
                },
                @{
                  n = 'Page File'
                  e = {
                    $_.PageFileSize
                  }
                },
                @{
                  n = 'Page File Recommended'
                  e = {
                    $_.PageFileSizeRecommended
                  }
                },
                @{
                  n = 'SQL Max RAM'
                  e = {
                    $_.SQLMaxRAM
                  }
                },
                @{
                  n = 'SQL Max RAM Recommended'
                  e = {
                    $_.SQLMaxRAMRecommended
                  }
                },Errors | 
                Table
           
           
           


        }
    }


    Section -Style Heading1 'DPM Server Sizing Guidelines' {
            
           Get-DPMCXSizingBaseline | Table -List
                   
    }

}

$HTMLFile = $document | Export-Document -Path $env:TEMP -Format Html
$body = Get-Content -Path $HTMLFile.FullName | Out-String

 $mailParams=@{
  To= $MailTo
  From= $MailFrom
  Subject= $MailSubject
  SMTPServer= $SMTPServer
  Body = $body 
  BodyAsHTML=$true
  Encoding = $MailEncoding
  ErrorAction = 'Stop'
 }

try {

    Send-MailMessage @mailParams

    Write-Output "DPM report sent successfully to $MailTo using SMTP server $SMTPServer"

}

catch {

    Write-Output "An error occured while trying to send the DPM report to $MailTo using SMTP server $SMTPServer : $($_.Exception.Message)"

}

}