Report snapshots of all the virtual machines in your VMWare environment with PowerCLI

report_snapshots.ps1

<#
.DEPLOY INSTRUCTIONS
    http://www.dangtrinh.com/2016/01/generate-snapshots-report-of-all-vmware.html
.SYNOPSIS
    Simple HTML report showing all snapshots on your VMware vSphere
    environment
.DESCRIPTION
    Run this script to produce a simple HTML report showing all the 
    snapshots in your vSphere environment.  This script is designed to
    run without prompting you for credentials, saving the password in
    a (mostly) secure, encrypted file.  You must run the script once 
    manually to produce the proper credential file before putting it 
    into a scheduled task.
    
    You must modify the $Key variable below to get unique encryption, 
    otherwise anyone who downloads this script would have the same encryption 
    key you do!
    
    Credit to Daniel for the idea of using a unique key value in the
    ConvertTo-SecureString cmdlet allowing multiple computers to use this
    credential file.
    LINK: http://poshcode.org/3752
    
    Requires VMware PowerCLI be installed.
    
    *** IMPORTANT ***
    Required:  Modify the $Key variable to get unique encryption on your
    credentials.
    
    Idea for the unique
.PARAMETER VIServer
    Name of your vSphere vCenter server, or the name of your ESXi host.
.PARAMETER Admin
    Name of the administrative account needed to authenticate to vSphere.
.PARAMETER PathToCredentials
    Path where the script will save the credential file.
.PARAMETER PathToReport
    Path where the HTML report will be saved.
.PARAMETER To
    Who the emailed report is going to
.PARAMETER From
    Who the emailed report is coming from
.PARAMETER SMTPServer
    The IP address or name of the SMTP relay you want to use
.EXAMPLE
    .\Report-Snapshots.ps1 -VIServer VCenter1 -Admin Administrator -PathToCredentials \\server\share\cred -PathToReport \\server\share\reports
    
    Create a report of all the snapshots of VM's under the control of the
    VCenter1 vCenter server.  You will authenticate using the Administrator
    account and save the credential file on "server", in the share called
    "share" and the directory "cred".  The resulting HTML report will be
    saved on the same server and share, but in the directory "reports".
.EXAMPLE
    .\Report-Snapshots.ps1 -VIServer VCenter1 -Admin Administrator -PathToCredentials \\server\share\cred -PathToReport \\server\share\reports -To "[email protected]" -From "[email protected]" -SMTPServer "MyExchange1"
    
    Same as the example above, but overriding the default mailing parameters
    to send to [email protected], from [email protected] and using the MyExchange1
    server to relay the email.
.INPUTS
    None
.OUTPUTS
    HTML Report:  SnapshotReport.HTML
.NOTES
    Author:            Martin Pugh
    Maintainer:        Trinh Nguyen (me.dangtrinh.com)
    Key Idea:          Daniel (http://poshcode.org/3752)
    Twitter:           @thesurlyadm1n
    Spiceworks:        Martin9700
    Blog:              www.thesurlyadmin.com
       
    Changelog:
       1.3             Fixed credential function (was calling it wrong, how come no one told me?!).  Added
                       PathToCredentials and PathToReport to default to script path.  BIG: added new field
                       'Creator'.  Modified error handling (minor).  
       1.2             Updated Get-Credentials function to support domain level credentials in the
                       domainname\username format.
       1.1             By request added a calculation on how old the snapshot is in days. Discovered 
                       a "bug" when running the script on a VMware 4.1 system: the
                       SizeGB property does not exist!  Changed to use SizeMB and then manually
                       calculate the snapshot size in GB. Added some better error trapping.  Also
                       parameterized the email settings.
       1.0             Initial Release
.LINK
    http://community.spiceworks.com/scripts/show/1871-vm-snapshot-report
.LINK
    http://poshcode.org/3752
#>
Param (
    [Alias("Host")]
    [string]$VIServer = "Your vCenter Server",
    [string]$Admin = "root",
    [string]$PathToCredentials,
    [string]$PathToReport,

    #[string]$To = "[email protected]",
    [string]$From = "Notification Email <[email protected]>",
    [string]$SMTPServer = "smtp.gmail.com",
    [string]$SMTPPort = "587",
    [string]$SMTPPasswd = "yourGMailPass",
    [string]$SMTPUser = "yourGMailUser"
)

#You must change these values to securely save your credential files
$Key = [byte]57,86,31,23,73,75,85,52,77,33,0,21,56,76,99,14

#region Functions

Function Get-Credentials {
    Param (
	    [String]$AuthUser = $env:USERNAME,
        [string]$PathToCred
    )

    #Build the path to the credential file
    $CredFile = $AuthUser.Replace("\","~")
    If (-not $PathToCred)
    {
        $PathToCred = Split-Path $MyInvocation.MyCommand.Path
    }
    $File = Join-Path -Path $PathToCred -ChildPath "\Credentials-$CredFile.crd"
	#And find out if it's there, if not create it
    If (-not (Test-Path $File))
	{	(Get-Credential $AuthUser).Password | ConvertFrom-SecureString -Key $Key | Set-Content $File
    }
	#Load the credential file 
    $Password = Get-Content $File | ConvertTo-SecureString -Key $Key
    $AuthUser = (Split-Path $File -Leaf).Substring(12).Replace("~","\")
    $AuthUser = $AuthUser.Substring(0,$AuthUser.Length - 4)
	$Credential = New-Object System.Management.Automation.PsCredential($AuthUser,$Password)
    Return $Credential
}


Function Set-AlternatingRows {
    [CmdletBinding()]
         Param(
             [Parameter(Mandatory=$True,ValueFromPipeline=$True)]
             [object[]]$HTMLDocument,
      
             [Parameter(Mandatory=$True)]
             [string]$CSSEvenClass,
      
             [Parameter(Mandatory=$True)]
             [string]$CSSOddClass
         )
     Begin {
         $ClassName = $CSSEvenClass
     }
     Process {
         [string]$Line = $HTMLDocument
         $Line = $Line.Replace("<tr>","<tr class=""$ClassName"">")
         If ($ClassName -eq $CSSEvenClass)
         {    $ClassName = $CSSOddClass
         }
         Else
         {    $ClassName = $CSSEvenClass
         }
         $Line = $Line.Replace("<table>","<table width=""50%"">")
         Return $Line
     }
}


Function Get-SnapshotCreator {
    Param (
        [string]$VM,
        [datetime]$Created
    )

    (Get-VIEvent -Entity $VM -Types Info -Start $Created.AddSeconds(-10) -Finish $Created.AddSeconds(10) | Where FullFormattedMessage -eq "Task: Create virtual machine snapshot" | Select -ExpandProperty UserName).Split("\")[-1]
}
#endregion

If (-not (Get-PSSnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue))
{   Try { Add-PSSnapin VMware.VimAutomation.Core -ErrorAction Stop }
    Catch { Throw "Problem loading VMware.VimAutomation.Core snapin because ""$($Error[1])""" }
}

If (-not $PathToCredentials)
{
    $PathToCredentials = Split-Path $MyInvocation.MyCommand.Path
}

If (-not $PathToReport)
{
    $PathToReport = Split-Path $MyInvocation.MyCommand.Path
}

$Cred = Get-Credentials $Admin $PathToCredentials
Try {
    $Conn = Connect-VIServer $VIServer -Credential $Cred -ErrorAction Stop 3>$null
}
Catch {
    Throw "Error connecting to $VIServer because ""$($Error[1])"""
}

$Header = @"
<style>
TABLE {border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}
TR:Hover TD {Background-Color: #C1D5F8;}
TH {border-width: 1px;padding: 3px;border-style: solid;border-color: black;background-color: #6495ED;}
TD {border-width: 1px;padding: 3px;border-style: solid;border-color: black;}
.odd  { background-color:#ffffff; }
.even { background-color:#dddddd; }
</style>
<title>
Snapshot Report - $VIServer
</title>
"@

$Report = Get-VM | 
    Get-Snapshot | 
    Select VM,
    Name,
    Description,
    @{Name="SizeGB";Expression={ [math]::Round($_.SizeGB,2) }},
    @{Name="Creator";Expression={ Get-SnapshotCreator -VM $_.VM -Created $_.Created }},
    Created,
    @{Name="Days Old";Expression={ (New-TimeSpan -End (Get-Date) -Start $_.Created).Days }}

If (-not $Report)
{   $Report = [PSCustomObject]@{
        VM = "No snapshots found on any VM's controlled by $VIServer"
        Name = ""
        Description = ""
        Size = ""
        Creator = ""
        Created = ""
        'Days Old' = ""
    }
}

$Report = $Report | 
    ConvertTo-Html -Head $Header -PreContent "<p><h2>Snapshot Report - $VIServer</h2></p><br>" | 
    Set-AlternatingRows -CSSEvenClass even -CSSOddClass odd
$Report | Out-File $PathToReport\SnapShotReport.html

# If you want to send the report to multiple addresses
$TO_ADDR = "[email protected]", "[email protected]", "[email protected]"
$secpasswd = ConvertTo-SecureString $SMTPPasswd -AsPlainText -Force
$mycreds = New-Object System.Management.Automation.PSCredential ($SMTPUser, $secpasswd)
$MailSplat = @{
    To         = $TO_ADDR
    From       = $From
    Subject    = "$VIServer Snapshot Report"
    Body       = ($Report | Out-String)
    BodyAsHTML = $true
    SMTPServer = $SMTPServer
    port       = $SMTPPort
    Credential = $mycreds
}

Send-MailMessage @MailSplat -UseSsl

Good Job Martin. Its almost perfect. How can i run it for multiple vcenters.