PowerCLI script to move/migrate virtual machines to datastore and convert to thin provisioning
Connect-VIServer vcenterserver
$input = Import-Csv C:\Temp\vmlist.csv
foreach ($row in $input)
{
$VMName=$row.VMName
$DSName=$row.DSName
Move-VM -VM $VMName -Datastore (Get-Datastore $DSName) -DiskStorageFormat Thin -RunAsync
}
Disconnect-VIServer vcenterserver -Confirm:$false
<#
Content of vmlist.csv
VMName,DSName
vm1,DS1
vm2,DS8
vm3,DS6
#>
Snapshot report using PowerCLI script
#### HTML Output Formatting #######
$a = "<style>"
$a = $a + "BODY{font-family:Calibri;font-size:12pt;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse; padding-right:5px}"
$a = $a + "TH{border-width: 1px;padding: 5px;border-style: solid;border-color: black;color:black;background-color:#FFFFFF }"
$a = $a + "TD{border-width: 1px;padding: 5px;border-style: solid;border-color: black;background-color:Silver}"
$a = $a + "</style>"
Connect-VIServer vcenterserver
Remove-Item D:\temp\SnapshotReport.html
$CurrentDate = Get-Date
$CurrentDate = $CurrentDate.ToString('dd-MMM-yyyy')
$HeadLines = "<BR><i>Snapshot Report - $CurrentDate </i>"
$post = "<BR><i>Snapshots older than 10 Days as of $CurrentDate </i>"
Get-VM | ?{$_.PowerState -eq "PoweredOn"} | Get-Snapshot | Where-Object {$_.Created -lt (Get-Date).AddDays(-10)} | Select-Object VM, Description, Created, @{Label=”Age”;Expression={(New-TimeSpan -Start $_.Created -End (Get-Date)).Days}}, @{Label=”SizeGB”;Expression={“{0:N2} GB” -f ($_.SizeGB)}} | Sort-Object "Age" -Descending | ConvertTo-html -Head $a -PreContent $post -Body "<H2> </H2>" >> D:\temp\SnapshotReport.html
$body = [System.IO.File]::ReadAllText('D:\temp\SnapshotReport.html')
Send-MailMessage -To To@Mailaddress.com -From From@Mailaddress.com -Subject "Snapshot Report - $CurrentDate" -Body $body -SmtpServer smtp.Mailaddress.com -BodyAsHtml
Disconnect-VIServer vcenterserver -Confirm:$False
PowerShell Script to Add new Column to exisiting CSV file
$vmlists = Import-Csv 'D:\temp\file.csv'
$counter = $vmlists.count
foreach($vm in $vmlists)
{
$vmName=$vm.Name
$NewColumnValue = Read-Host "Enter the DatastoreName for $vmName"
$vm | Add-Member -NotePropertyName Datastore -NotePropertyValue $NewColumnValue
$counter = $counter -1
Write-Host $counter
}
$vmlists | Export-Csv 'D:\temp\file.csv' -NoTypeInformation
Exsisting CSV File:
"Name","PowerState","IP Address","NetworkName","Cluster","VMHost"
"vm1","PoweredOn","192.168.1.6","vlan1","cluster1","host01"
"vm2","PoweredOn","192.168.1.7","vlan2","cluster1","host02"
OutPut CSV File
"Name","PowerState","IP Address","NetworkName","Cluster","VMHost","Datastore"
"vm1","PoweredOn","192.168.1.6","vlan1","cluster1","host01","datastore01"
"vm2","PoweredOn","192.168.1.7","vlan2","cluster1","host02","datastore01"
PowerCLI script to create snapshots for multiple VMs
#### HTML Output Formatting #######
$a = "<style>"
$a = $a + "BODY{background-color:Lavender ;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:thistle}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:PaleGoldenrod}"
$a = $a + "</style>"
################################################################################################
################################################
# Snapshot Information
#################################################
Connect-VIServer vcenter_server
Remove-Item C:\Temp\Snapshot.html
$Date = Get-date -format F
$Name = Read-Host "Enter Your Name"
$Description = Read-Host "Enter the Requester Name & Reason"
$toAddr = Read-Host "Enter the To Email Address"
$vmname = gc C:\Temp\Servers.txt
get-vm $vmname | new-snapshot -name "$Name - $Date" -Description $Description -Quiesce -Memory | Select VM,Created,Name,Description | ConvertTo-html -Head $a -Body "<H2> </H2>" >> C:\Temp\Snapshot.html
$body = [System.IO.File]::ReadAllText('C:\Temp\Snapshot.html')
Send-MailMessage -To $toAddr -From From@Mailaddress.com -Subject "VMware Snapshots Created for the $Description" -Body $body -SmtpServer smtp.Mailaddress.com -BodyAsHtml
Disconnect-viserver vcenter_server -confirm:$false
#################### END of SCRIPT ####################################
PowerCLI script to schedule snapshots
##############START OF FUNCTION###############
Function Get-VIScheduledTasks {
PARAM ( [switch]$Full )
if ($Full) {
# Note: When returning the full View of each Scheduled Task, all date times are in UTC
(Get-View ScheduledTaskManager).ScheduledTask | %{ (Get-View $_).Info }
} else {
# By default, lets only return common headers and convert all date/times to local values
(Get-View ScheduledTaskManager).ScheduledTask | %{ (Get-View $_ -Property Info).Info } |
Select-Object Name, Description, Enabled, Notification, LastModifiedUser, State, Entity,
@{N="EntityName";E={ (Get-View $_.Entity -Property Name).Name }},
@{N="LastModifiedTime";E={$_.LastModifiedTime.ToLocalTime()}},
@{N="NextRunTime";E={$_.NextRunTime.ToLocalTime()}},
@{N="PrevRunTime";E={$_.LastModifiedTime.ToLocalTime()}},
@{N="ActionName";E={$_.Action.Name}}
}
}
Function Get-VMScheduledSnapshots {
Get-VIScheduledTasks | ?{$_.ActionName -eq 'CreateSnapshot_Task'} |
Select-Object @{N="VMName";E={$_.EntityName}}, Name, NextRunTime, Notification
}
Function New-VMScheduledSnapshot {
PARAM (
[string]$vmName,
[string]$runTime,
[string]$notifyEmail=$null,
[string]$taskName="$vmName Scheduled Snapshot"
)
# Verify we found a single VM
$vm = (get-view -viewtype virtualmachine -property Name -Filter @{"Name"="^$($vmName)$"}).MoRef
if (($vm | Measure-Object).Count -ne 1 ) { "Unable to locate a specific VM $vmName"; break }
# Validate datetime value and convert to UTC
try { $castRunTime = ([datetime]$runTime).ToUniversalTime() } catch { "Unable to convert runtime parameter to date time value"; break }
if ( [datetime]$runTime -lt (Get-Date) ) { "Single run tasks can not be scheduled to run in the past. Please adjust start time and try again."; break }
# Verify the scheduled task name is not already in use
if ( (Get-VIScheduledTasks | ?{$_.Name -eq $taskName } | Measure-Object).Count -eq 1 ) { "Task Name `"$taskName`" already exists. Please try again and specify the taskname parameter"; break }
$spec = New-Object VMware.Vim.ScheduledTaskSpec
$spec.name = $taskName
$spec.description = "Snapshot of $vmName scheduled for $runTime"
$spec.enabled = $true
if ( $notifyEmail ) {$spec.notification = $notifyEmail}
($spec.scheduler = New-Object VMware.Vim.OnceTaskScheduler).runAt = $castRunTime
($spec.action = New-Object VMware.Vim.MethodAction).Name = "CreateSnapshot_Task"
$spec.action.argument = New-Object VMware.Vim.MethodActionArgument[] (4)
($spec.action.argument[0] = New-Object VMware.Vim.MethodActionArgument).Value = "$vmName scheduled snapshot"
($spec.action.argument[1] = New-Object VMware.Vim.MethodActionArgument).Value = "Snapshot created using $taskName"
($spec.action.argument[2] = New-Object VMware.Vim.MethodActionArgument).Value = $false # Snapshot memory
($spec.action.argument[3] = New-Object VMware.Vim.MethodActionArgument).Value = $false # quiesce guest file system (requires VMware Tools)
[Void](Get-View -Id 'ScheduledTaskManager-ScheduledTaskManager').CreateScheduledTask($vm, $spec)
Get-VMScheduledSnapshots | ?{$_.Name -eq $taskName }
}
Function Remove-VIScheduledTask {
PARAM ([string]$taskName)
(Get-View -Id ((Get-VIScheduledTasks -Full | ?{$_.Name -eq $taskName}).ScheduledTask)).RemoveScheduledTask()
}
##############END OF FUNCTION###############
Copy the above Function as a .ps1 file to this location: "C:\Windows\System32\WindowsPowerShell\v1.0"
You can then call these functions in your script.
##############BEGINNING OF SCRIPT###############
#### HTML Output Formatting #######
$a = "<style>"
$a = $a + "BODY{background-color:White ;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:Green}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:PaleGoldenrod}"
$a = $a + "</style>"
################################################################################################
Connect-VIServer vcenter_server
Remove-Item C:\Temp\ScheduleSnapshotReport.html
""
"Deleting all old scheduled snapshots that are already complete ..."
Get-VMScheduledSnapshots | ?{$_.NextRunTime -eq $null} | %{ Remove-VIScheduledTask $_.Name }
$report = @()
$date = Get-Date
$input = Import-Csv C:\Temp\server.csv
""
"Creating new scheduled snapshots ..."
foreach ($row in $input)
{
$VMName=$row.VMName
$Sched=$row.Schedule
$Mail=$row.Email
New-VMScheduledSnapshot $VMName $Sched "$Mail"
$report += $row
}
$report | ConvertTo-html -Head $a -Body "<H2> </H2>" >> C:\Temp\ScheduleSnapshotReport.html
$body = [System.IO.File]::ReadAllText('C:\Temp\ScheduleSnapshotReport.html')
$text = '<font=Arial>Snapshots have been scheduled for the virtual machines listed below as per the specified date and time. A confirmation mail will be sent to the email mentioned upon completion of the snapshot.</font>'
""
"Sending a confirmation e-mail to To@MailAddress.com ..."
Send-MailMessage -To To@MailAddress.com -From From@MailAddress.com -Subject "Scheduled Snapshot Report - $date" -Body "$text $body" -SmtpServer smtp.MailAddress.com -BodyAsHtml
Disconnect-VIServer vcenter_server -Confirm:$false
##############END OF SCRIPT###############
Content of server.csv
PowerCLI script to remove the ISO from virtual machine
Connect-VIServer vcenterserver
Get-CDDrive -VM (Get-Content D:\Scripts\CDRom\serverlist.txt) | Set-CDDrive -nomedia -Confirm:$false | Get-VMQuestion | Set-VMQuestion –Option "Yes"
Disconnect-VIServer vcenterserver -Confirm:$false
PowerCLI script to gather report on virtual machines mounted with CDROM/ISO
#### HTML Output Formatting #######
$a = "<style>"
$a = $a + "BODY{background-color:White ;}"
$a = $a + "TABLE{border-width: 1px;border-style: solid;border-color: black;border-collapse: collapse;}"
$a = $a + "TH{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:Green}"
$a = $a + "TD{border-width: 1px;padding: 0px;border-style: solid;border-color: black;background-color:PaleGoldenrod}"
$a = $a + "</style>"
################################################################################################
Remove-Item C:\Temp\CDROM.html
$CurrentDate = Get-Date
$CurrentDate = $CurrentDate.ToString('dd-MMM-yyyy')
Connect-viserver vcenterserver
Get-VM | Get-CDDrive | select @{N="VM";E="Parent"},IsoPath | where {$_.IsoPath -ne $null} | ConvertTo-html -Head $a -Body "<H2> </H2>" >> C:\Temp\CDROM.html
$body = [System.IO.File]::ReadAllText('C:\Temp\CDROM.html')
Send-MailMessage -To ToMailAddress -From FromMailAddress -Subject "Virtual Machine Mounted with CDROM/ISO as on $CurrentDate" -Body $body -SmtpServer SMTPServer -BodyAsHtml
Disconnect-VIServer vcenterserver -Confirm:$False
