Re: Datastore Usage Report

AGFlora · ‎01-03-2013

Hi

The following code reports the datastore usage and writes to an html file using the Add-Content cmdlet.

I'm having trouble sorting by % free. Please help.

CODE:

Function GetDS
{
Get-DataCenter $DC | Get-Datastore | Where-Object {$_.Name -notlike "DataStore1*"} | %{
        $Store = {} | Select Name, CapacityGB, UsedGB, FreeSpace, PercFree
            $Name = $Store.Name = $_.name | Sort -Property PercFree
   $Capacity = $Store.CapacityGB = [math]::Round($_.capacityGB/1024,$digits)
   $Used = $Store.UsedGB = [math]::Round(($_.CapacityGB - $_.FreeSpaceGB)/1024,$digits)
   $PercFree = $Store.PercFree = [math]::Round(100*$_.FreeSpaceGB/$_.CapacityGB,$digits) | Sort -Property PercFree

# Passing the 4 variables from this function to another function called writedata
writedata $Name $Capacity $Used $PercFree
}
}

# Function will compile the data passed from the RPCInfo Function into HTML table format
Function writedata
{
param ($Name,$Capacity,$Used, $PercFree)

If ($Store.PercFree -gt $Warning)
{$tableEntry = "<tr><td>$Name</td><td><center>$Capacity</center></td><td><center>$Used</center></td><td><center>$PercFree</center></td></tr>"
Add-Content $fileName $tableEntry
Write-Host $tableEntry}

ElseIf ($Store.PercFree -lt $Critical)
{$tableEntry = "<tr><td>$Name</td><td><center>$Capacity</center></td><td><center>$Used</center></td><td><center>$PercFree</center></td></tr>"
Add-Content $fileName $tableEntry
Write-Host $tableEntry}

ElseIf ($Store.PercFree -lt $Warning)
{$tableEntry = "<tr><td>$Name</td><td><center>$Capacity</center></td><td><center>$Used</center></td><td><center>$PercFree</center></td></tr>"
Add-Content $fileName $tableEntry
Write-Host $tableEntry}

}

End Code

Thanks

LucD · ‎01-03-2013

Try something like this

Function GetDS {
    $report = Get-DataCenter $DC | Get-Datastore | 
        Where-Object {$_.Name -notlike "DataStore1*"} | %{
        New-Object PSObject -Property @{
            Name = $_.name
            Capacity = [math]::Round($_.capacityGB/1024,$digits)
            Used = [math]::Round(($_.CapacityGB - $_.FreeSpaceGB)/1024,$digits)
            PercFree = [math]::Round(100 * $_.FreeSpaceGB/$_.CapacityGB,$digits)
        }
    } | Sort-Object -Property PercFree
    $report | %{
        writedata $_.Name $_.Capacity $_.Used $_.PercFree
        }
}

# Function will compile the data passed from the RPCInfo Function into HTML table format
Function writedata {
    param ($Name,$Capacity,$Used, $PercFree)


    If ($Store.PercFree -gt $Warning)
    {        $tableEntry = "<tr><td><font face='Tahoma'>$Name</font></td><td><center><b><font face='Tahoma'>$Capacity</font></b></center></td><td><center><b><font face='Tahoma'>$Used</font></b></center></td><td><center><b><font face='Tahoma'color = 'darkblue'>$PercFree</font></b></center></td></tr>"
        Add-Content $fileName $tableEntry
        Write-Host $tableEntry}



    ElseIf ($Store.PercFree -lt $Critical)
    {        $tableEntry = "<tr><td><font face='Tahoma'>$Name</font></td><td><center><b><font face='Tahoma'>$Capacity</font></b></center></td><td><center><b><font face='Tahoma'>$Used</font></b></center></td><td><center><b><font face='Tahoma'color = 'red'>$PercFree</font></b></center></td></tr>"
        Add-Content $fileName $tableEntry
        Write-Host $tableEntry}



    ElseIf ($Store.PercFree -lt $Warning)
    {        $tableEntry = "<tr><td><font face='Tahoma'>$Name</font></td><td><center><b><font face='Tahoma'>$Capacity</font></b></center></td><td><center><b><font face='Tahoma'>$Used</font></b></center></td><td><center><b><font face='Tahoma'color = 'Orange'>$PercFree</font></b></center></td></tr>"
        Add-Content $fileName $tableEntry
        Write-Host $tableEntry}


}

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

AGFlora · ‎01-03-2013

Hi Luc

The ouput is only the html code but no data.

Here is the entire script:

#Load PowerCLI snapin
add-pssnapin VMware.VimAutomation.Core

#Remove previous HTML report
Remove-Item "HTML-Reports\DS-Report.htm"

##Connect to vCenter Server
###########################
$vC = "vCenterServer"
Connect-VIServer $vC
$date = ( Get-Date ).ToString('yyyy/MM/dd')
$Title = "Datastore Usage Report"
$Warning = "10"
$Critical = "5"
$digits = 2
$DC = "Datacenter1"

$DateStamp = get-date -uformat "%Y-%m-%d@%H-%M-%S"

#Create file for new run
New-Item -ItemType file "HTML-Reports\DS-Report.htm"
$fileName = "HTML-Reports\DS-Report.htm"

#HTML Header for Output
Function writeHtmlHeader
{
param($fileName)

Add-Content $fileName "<html>"
Add-Content $fileName "<head>"
Add-Content $fileName "<meta http-equiv='Content-Type' content='text/html; charset=iso-8859-1'>"
Add-Content $fileName '<title>$Title</title>'
Add-Content $fileName '<STYLE TYPE="text/css">'
Add-Content $fileName ""
Add-Content $fileName "</style>"
Add-Content $fileName "</head>"
Add-Content $fileName "<body>"
Add-Content $fileName "<table width='60%'>"
Add-Content $fileName "<tr bgcolor='#FFFFFF'>"
Add-Content $fileName "<td colspan='7' height='25' align='center'>"
Add-Content $fileName "$Title - $Date"
Add-Content $fileName "</td>"
Add-Content $fileName "</tr>"
Add-Content $fileName "</table>"
}

# Function to write the HTML Header to the file
# This Example will have 4 Columns
Function writeTableHeader
{
param($fileName)
Add-Content $fileName "<table width='60%'><tbody>"
Add-Content $fileName "<tr bgcolor=#003399>"
Add-Content $fileName "<td align='center'>Datastore Name</td>"
Add-Content $fileName "<td align='center'>Capacity (TB)</td>"
Add-Content $fileName "<td align='center'>Used (TB)</td>"
#Add-Content $fileName "<td align='center'>Critical - Below 5% Free / Warning - Below 10% Free</td>"
Add-Content $fileName "<td align='center'>% Free</td>"
Add-Content $fileName "</tr>"
}

# Function to write the HTML Footer
Function writeHtmlFooter
{
param($fileName)
Add-Content $fileName "</table>"
Add-Content $fileName "<left><weak>Send All Inqueries Regarding this Report to EmailAddress</left>"
Add-Content $fileName "</body>"
Add-Content $fileName "</html>"
}

#<#
# Function to perform the work for the data you need
# I left content in place to give example
# Server variable was derived from a Get-Content function which would have occurred at the initialization of this script (removed)

Function GetDS {
    $report = Get-DataCenter $DC | Get-Datastore |
        Where-Object {$_.Name -notlike "DataStore1*"} | %{
        $row = New-Object PSObject -Property @{
            Name = $_.name
            Capacity = [math]::Round($_.capacityGB/1024,$digits)
            Used = [math]::Round(($_.CapacityGB - $_.FreeSpaceGB)/1024,$digits)
            PercFree = [math]::Round(100 * $_.FreeSpaceGB/$_.CapacityGB,$digits)
        }
    } | Sort-Object -Property PercFree
    $report | %{
        writedata $_.Name $_.Capacity $_.Used $_.PercFree
   }
}

# Function will compile the data passed from the RPCInfo Function into HTML table format
Function writedata {
param ($Name,$Capacity,$Used, $PercFree)

If($Store.PercFree -gt $Warning)
 {$tableEntry = "<tr><td>$Name</td><td><center>$Capacity</center></td><td><center>$Used</center></td><td><center>$PercFree</center></td></tr>"
 Add-Content $fileName $tableEntry
 Write-Host $tableEntry}

ElseIf($Store.PercFree -lt $Critical)
 {$tableEntry = "<tr><td>$Name</td><td><center>$Capacity</center></td><td><center>$Used</center></td><td><center>$PercFree</center></td></tr>"
 Add-Content $fileName $tableEntry
 Write-Host $tableEntry}

ElseIf($Store.PercFree -lt $Warning)
 { $tableEntry = "<tr><td>$Name</td><td><center>$Capacity</center></td><td><center>$Used</center></td><td><center>$PercFree</center></td></tr>"
 Add-Content $fileName $tableEntry
 Write-Host $tableEntry}

}

# Combine functions into orderly format for the output
writehtmlheader $fileName
writetableheader $fileName
GetDS
writehtmlfooter $fileName

##Disconnect from vCenter server
################################
Disconnect-VIServer -Confirm:$False

LucD · ‎01-03-2013

There were some CR-LF missing in the script. I just corrected the code above, can you try again ?

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

AGFlora · ‎01-03-2013

Same result.

Were you talking about the following being out of place?

Add-Content $fileName $tableEntry
Write-Host $tableEntry}

Before I put those two lines in the proper place the script wouldn't run but still the same result.

Thanks

LucD · ‎01-03-2013

Yes, those were the lines I meant.

But I checked again and saw this line

$row = New-Object PSObject -Property @{

that should be

New-Object PSObject -Property @{

I corrected the code above.

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference

AGFlora · ‎01-03-2013

Excellent that was it!

At first the % numbers were all in red but it's perfect after I changed the fowllwing lines:

From:

If ($Store.PercFree -gt $Warning)

To:

If ($_.PercFree -gt $Warning)

BTW I bought your book. Excellent read so far. I like your writing style.

Thanks again for your help!

LucD · ‎01-03-2013

Thanks, I hope you will find many useful scripts in the book.

Blog: lucd.info Twitter: @LucD22 Co-author PowerCLI Reference