PrateekKumarSingh · October 4, 2015 18:07
diff --git a/DPM_Resource_Utilization.ps1 b/DPM_Resource_Utilization.ps1
 # Parameter Definition
 Param
 (
    [Parameter(mandatory = $true)] [String] $DPMServer,
    [String] $SendEmailTo,
    [String] $OutputDirectory,
    [String] $SMTPServer
 )

 # HTML Body Definition Start

 $a = "<html><head><style>"
 $a = $a + "BODY{font-family: Calibri;font-size:14;font-color: #000000}"
 $a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
 $a = $a + "TH{border-width: 1px;padding: 4px;border-style: solid;border-color: black;background-color: #BDBDBD}"
 $a = $a + "TD{border-width: 1px;padding: 4px;border-style: solid;border-color: black;background-color: #ffffff	}"
 $a = $a + "</style></head><body>"

 # HTML Body Definition End

 $b = "</body></html>"


 # Connecting to DPM Server

 $DataSources = Get-ProtectionGroup -DPMServerName $DPMServer| %{Get-Datasource -ProtectionGroup $_} 

 $Out = @()

 $Heading = "<bR><H1>DPM Resource Utilization</h1><br><br>"

 Foreach($D in $DataSources)
 {

 $RecoveryStr = ($d.diskallocation).split('|')[1]

 #DPM Resource Utlization Calculations
 $RecoveryAllocated, $RecoveryUsed  = $RecoveryStr -split "allocated,"
 $RecoveryAllocated = [int](($RecoveryAllocated -split ": ")[1] -split " ")[0]
 $RecoveryUsed = [int]((($RecoveryUsed -split " used")[0]) -split " ")[1]
 $RecoveryPointVolUtilization =[int]("{0:N2}" -f (($RecoveryUsed/$RecoveryAllocated)*100))

 $ReplicaSize = "{0:N2}" -f $($d.ReplicaSize/1gb)
 $ReplicaSpaceUsed = "{0:N2}" -f ($d.ReplicaUsedSpace/1gb)
 $ReplicaUtilization =[int]("{0:N2}" -f (($ReplicaSpaceUsed/$ReplicaSize)*100))

 $NumOfRecoveryPoint = ($d | get-recoverypoint).count

 $Out += $d|select ProtectionGroupName, Name, @{name='Replica Size (In GB)';expression={$ReplicaSize}}, @{name='Replica Used Space (In GB)';expression={$ReplicaSpaceUsed}} , @{name='RecoveryPointVolume Allocated (In GB)';expression={$RecoveryAllocated}}, @{name='RecoveryPoint Used Space (In GB)';expression={$RecoveryUsed}},@{name='Total Recovery Points';expression ={$NumOfRecoveryPoint}} , @{name='Replica Utilization %';expression={$ReplicaUtilization}}, @{name='RecoveryPoint Volume Utilization %';expression={$RecoveryPointVolUtilization}}
 }
    
 # Closing the Connection with DPM server
 disconnect-dpmserver -dpmservername $DPMServer

 $ResourceUtil = $Out | Sort -property name -descending | convertto-html -fragment

 # Adding all HTML data

 $html = $a + $heading + $ResourceUtil + $b

 If(-not $OutputDirectory)
 {
 $FilePath = "$((Get-Location).path)\DPM_ResourceUtlization_Report.html"
 }
 else
 { 
    If($OutputDirectory[-1] -ne '\')
    {
    
        $FilePath = "$OutputDirectory\DPM_ResourceUtlization_Report.html"
    }
    else
    {
        $FilePath = $OutputDirectory+"DPM_ResourceUtlization_Report.html"
    }
 }

 #Writing the HTML File
 $html | set-content $FilePath -confirm:$false
 Write-Host "A DPM Resource Utilization Report has been generated on Location : $filePath" -ForegroundColor Yellow

 #Sending Email
 If($SendEmailTo -and $SMTPServer)
 {
 Send-MailMessage -To $SendEmailTo -From "[email protected]" -Subject "DPM Space Utilization" -SmtpServer $SMTPServer -Body ($html| Out-String) -BodyAsHtml 
 Write-Host "DPM Resource Utilization Report has been sent to email $SendEmailTo" -ForegroundColor Yellow
 }
	# Parameter Definition
	Param
	(
	[Parameter(mandatory = $true)] [String] $DPMServer,
	[String] $SendEmailTo,
	[String] $OutputDirectory,
	[String] $SMTPServer
	)

	# HTML Body Definition Start

	$a = "<html><head><style>"
	$a = $a + "BODY{font-family: Calibri;font-size:14;font-color: #000000}"
	$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
	$a = $a + "TH{border-width: 1px;padding: 4px;border-style: solid;border-color: black;background-color: #BDBDBD}"
	$a = $a + "TD{border-width: 1px;padding: 4px;border-style: solid;border-color: black;background-color: #ffffff }"
	$a = $a + "</style></head><body>"

	# HTML Body Definition End

	$b = "</body></html>"


	# Connecting to DPM Server

	$DataSources = Get-ProtectionGroup -DPMServerName $DPMServer\| %{Get-Datasource -ProtectionGroup $_}

	$Out = @()

	$Heading = "<bR><H1>DPM Resource Utilization</h1><br><br>"

	Foreach($D in $DataSources)
	{

	$RecoveryStr = ($d.diskallocation).split('\|')[1]

	#DPM Resource Utlization Calculations
	$RecoveryAllocated, $RecoveryUsed = $RecoveryStr -split "allocated,"
	$RecoveryAllocated = [int](($RecoveryAllocated -split ": ")[1] -split " ")[0]
	$RecoveryUsed = [int]((($RecoveryUsed -split " used")[0]) -split " ")[1]
	$RecoveryPointVolUtilization =[int]("{0:N2}" -f (($RecoveryUsed/$RecoveryAllocated)*100))

	$ReplicaSize = "{0:N2}" -f $($d.ReplicaSize/1gb)
	$ReplicaSpaceUsed = "{0:N2}" -f ($d.ReplicaUsedSpace/1gb)
	$ReplicaUtilization =[int]("{0:N2}" -f (($ReplicaSpaceUsed/$ReplicaSize)*100))

	$NumOfRecoveryPoint = ($d \| get-recoverypoint).count

	$Out += $d\|select ProtectionGroupName, Name, @{name='Replica Size (In GB)';expression={$ReplicaSize}}, @{name='Replica Used Space (In GB)';expression={$ReplicaSpaceUsed}} , @{name='RecoveryPointVolume Allocated (In GB)';expression={$RecoveryAllocated}}, @{name='RecoveryPoint Used Space (In GB)';expression={$RecoveryUsed}},@{name='Total Recovery Points';expression ={$NumOfRecoveryPoint}} , @{name='Replica Utilization %';expression={$ReplicaUtilization}}, @{name='RecoveryPoint Volume Utilization %';expression={$RecoveryPointVolUtilization}}
	}

	# Closing the Connection with DPM server
	disconnect-dpmserver -dpmservername $DPMServer

	$ResourceUtil = $Out \| Sort -property name -descending \| convertto-html -fragment

	# Adding all HTML data

	$html = $a + $heading + $ResourceUtil + $b

	If(-not $OutputDirectory)
	{
	$FilePath = "$((Get-Location).path)\DPM_ResourceUtlization_Report.html"
	}
	else
	{
	If($OutputDirectory[-1] -ne '\')
	{

	$FilePath = "$OutputDirectory\DPM_ResourceUtlization_Report.html"
	}
	else
	{
	$FilePath = $OutputDirectory+"DPM_ResourceUtlization_Report.html"
	}
	}

	#Writing the HTML File
	$html \| set-content $FilePath -confirm:$false
	Write-Host "A DPM Resource Utilization Report has been generated on Location : $filePath" -ForegroundColor Yellow

	#Sending Email
	If($SendEmailTo -and $SMTPServer)
	{
	Send-MailMessage -To $SendEmailTo -From "[email protected]" -Subject "DPM Space Utilization" -SmtpServer $SMTPServer -Body ($html\| Out-String) -BodyAsHtml
	Write-Host "DPM Resource Utilization Report has been sent to email $SendEmailTo" -ForegroundColor Yellow
	}