A quick powershell script using HTML and CSS to run against your VMware Environment utilising PowerCLI to pull back a report of your snapshots.<\/p>\n
This can be useful for reclaiming space and making the most of your storage or to spot somewhere that you have a usage issue.
\n
\nThis does make the assumption you are using the same credentials to log into each of your VCentres, if you are using differing ones, a service account with the correct permissions on each could be created to run this report.<\/p>\n
[powershell]
\n#Import the PowerCLI module
\nImport-Module VMware.PowerCLI<\/p>\n
# Record the start time for measuring execution time
\n$startTime = Get-Date<\/p>\n
# Get valid credentials
\n$creds = Get-Credential
\n$vcsausername = $creds.UserName<\/p>\n
# Create an array to store VM snapshot data
\n$vmData = @()<\/p>\n
# List of vCenter servers (modify as needed)
\n$vCenterServers = @("vcsa1.your.domain.com", "vcsa2.your.domain.com")<\/p>\n
foreach ($vCenterServer in $vCenterServers) {
\n # Connect to vCenter server
\n Connect-VIServer -Server $vCenterServer -Credential $creds<\/p>\n
# Retrieve VMs with snapshots
\n $vmsWithSnapshots = Get-VM | Where-Object { $_ | Get-Snapshot -ErrorAction SilentlyContinue }<\/p>\n
# Iterate through VMs with snapshots
\n foreach ($vm in $vmsWithSnapshots) {
\n $snapshots = $vm | Get-Snapshot<\/p>\n
foreach ($snapshot in $snapshots) {
\n # Calculate snapshot age in days
\n $snapshotAge = (Get-Date) – $snapshot.Created<\/p>\n
$vmData += [PSCustomObject]@{
\n VDC = $vm.VMHost.Parent.Name
\n VM = $vm.Name
\n SnapshotName = $snapshot.Name
\n SnapshotDescription = $snapshot.Description
\n SnapshotSize = "{0:N2} GB" -f $snapshot.SizeGB
\n SnapshotCreated = $snapshot.Created
\n SnapshotAgeInDays = [math]::Round($snapshotAge.TotalDays, 2)
\n }
\n }
\n }<\/p>\n
# Disconnect from vCenter server
\n Disconnect-VIServer -Server $vCenterServer -Confirm:$false
\n}<\/p>\n
# Sort the results by SnapshotAgeInDays from largest to smallest
\n$vmData = $vmData | Sort-Object -Property SnapshotAgeInDays -Descending<\/p>\n
# Custom CSS for the table and dark mode
\n$customCSS = @"
\n<img src="data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" data-wp-preserve="%3Cstyle%3E%0A%20%20%20%20body%20%7B%0A%20%20%20%20%20%20%20%20background-color%3A%20%23333%3B%0A%20%20%20%20%20%20%20%20color%3A%20%23fff%3B%0A%20%20%20%20%7D%0A%20%20%20%20table%20%7B%0A%20%20%20%20%20%20%20%20width%3A%20100%25%3B%0A%20%20%20%20%20%20%20%20border-collapse%3A%20collapse%3B%0A%20%20%20%20%20%20%20%20font-size%3A%208pt%3B%20%2F*%20Set%20font%20size%20to%208%20points%20*%2F%0A%20%20%20%20%20%20%20%20background-color%3A%20%23444%3B%0A%20%20%20%20%7D%0A%20%20%20%20th%2C%20td%20%7B%0A%20%20%20%20%20%20%20%20border%3A%201px%20solid%20%23ddd%3B%0A%20%20%20%20%20%20%20%20padding%3A%208px%3B%0A%20%20%20%20%20%20%20%20text-align%3A%20left%3B%0A%20%20%20%20%7D%0A%20%20%20%20th%20%7B%0A%20%20%20%20%20%20%20%20background-color%3A%20%23666%3B%0A%20%20%20%20%7D%0A%20%20%20%20p%20%7B%0A%20%20%20%20%20%20%20%20font-size%3A%208pt%3B%20%2F*%20Set%20font%20size%20to%208%20points%20*%2F%0A%20%20%20%20%7D%0A%3C%2Fstyle%3E" data-mce-resize="false" data-mce-placeholder="1" class="mce-object" width="20" height="20" alt="<style>" title="<style>" \/>
\n"@<\/p>\n
# Create an HTML report with custom CSS
\n$logoURL = "https:\/\/www.logostock.com\/logo.png"
\n$htmlReport = @"
\n<!DOCTYPE html>
\n<html>
\n<head>
\n <link href="https:\/\/maxcdn.bootstrapcdn.com\/bootstrap\/4.5.2\/css\/bootstrap.min.css" rel="stylesheet">
\n $customCSS
\n<\/head>
\n<body>
\n <div class="container">
\n <img src="$logoURL" alt="Logo" style="max-width: 200px;">
\n <h1>Snapshot Report<\/h1>
\n $($vmData | ConvertTo-HTML -Fragment)
\n <br> <!– Add a line break –>
\n <p>Report ran on $((Get-Date).ToString(‘dd MMMM yyyy’)) by $($env:USERNAME) using $($vcsausername) to authenticate to VCSA. <br>
\n Report run time was $((Get-Date) – $startTime).<\/p>
\n <\/div>
\n<\/body>
\n<\/html>
\n"@<\/p>\n
# Output the HTML report to a file
\n$htmlReport | Out-File -FilePath "c:\\temp\\SnapshotReport.html"<\/p>\n
# Display the HTML report
\nInvoke-Item "c:\\temp\\SnapshotReport.html"<\/p>\n
[\/powershell]<\/p>\n","protected":false},"excerpt":{"rendered":"
A quick powershell script using HTML and CSS to run against your VMware Environment utilising…<\/p>\n","protected":false},"author":1,"featured_media":988,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19,11,14],"tags":[63,70,76,80],"class_list":["post-1266","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell","category-scripts","category-vmware","tag-powercli","tag-report","tag-snapshots","tag-vmware"],"jetpack_featured_media_url":"https:\/\/ihni.uk\/wp-content\/uploads\/2020\/02\/Powershell.png","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/1266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1266"}],"version-history":[{"count":0,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/posts\/1266\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=\/wp\/v2\/media\/988"}],"wp:attachment":[{"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ihni.uk\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}