Category Archives: PowerCLI

VMware Tools Check – PowerCLI Email Report

The last two posts I made utilize PowerCLI and VMware tools to gather information for reporting. So what happens if VMware tools is not running…. things fall through the cracks!

Luckily, we can report on VMware tools status too.

#Timestamp the transcript and start it
$currentdate = (Get-Date).tostring("yyyy-MM-dd")
$transfilename = 'ToolsRunningCheck_' + $currentdate + '.txt'
$transfilepath = 'C:\scripts\Transcripts\' + $transfilename
Start-Transcript $transfilepath -NoClobber -Append

#Load PowerCLI snapins and dot source them
Add-PSSnapin vmware.vimautomation.core
. "C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1"


Connect-VIServer vcenterserver.company.com

#Generating timestamped log name for powercli html output
$outfilename = 'ToolsRunningCheck_' + $currentdate + '.htm'
$outfilepath = 'C:\Scripts\Output\' + $outfilename

$PoweredOnVMs = Get-VM | Where-Object {$_.PowerState -eq "PoweredOn"}

$VMswithoutRunningTools = $PoweredOnVMs | Get-View | Where-Object {($_.Guest.ToolsStatus -match "toolsNotInstalled") -or ($_.Guest.ToolsStatus -match "toolsNotRunning") }   | Select-Object Name,@{Name="Status";Expression={$_.Guest.ToolsStatus}}

if ($VMswithoutRunningTools) { $VMswithoutRunningTools | Sort-Object Name | ConvertTo-Html | Out-File $outfilepath }

#variables for email output
$eto = "youremail@company.com"
$efrom = "PowerCLI_Reports <PowerCLIReports@company.com>"
$esubject = "Virtual Machines with VMware Tools problems"
If ($VMswithoutRunningTools) { $ebody = (Get-Content $outfilepath | Out-String) }
$eserver = "smtpserver.company.com"




If ($VMswithoutRunningTools) { Send-MailMessage -From $efrom -To $eto -Subject $esubject -BodyAsHtml -Body $ebody -smtpserver $eserver }
Else { Send-MailMessage -From $efrom -To $eto  -Subject $esubject -Body "There are no VMs reporting VMware Tools is not installed" -smtpserver $eserver }

#Timestamp the transcript and start it

$currentdate = (Get-Date).tostring("yyyy-MM-dd")

$transfilename = 'ToolsRunningCheck_' + $currentdate + '.txt'

$transfilepath = 'C:\scripts\Transcripts\' + $transfilename

Start-Transcript $transfilepath -NoClobber -Append

#Load PowerCLI snapins and dot source them

Add-PSSnapin vmware.vimautomation.core

. "C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1"

Connect-VIServer vcenterserver.company.com

#Generating timestamped log name for powercli html output

$outfilename = 'ToolsRunningCheck_' + $currentdate + '.htm'

$outfilepath = 'C:\Scripts\Output\' + $outfilename

$PoweredOnVMs = Get-VM | Where-Object {$_.PowerState -eq "PoweredOn"}

$VMswithoutRunningTools = $PoweredOnVMs | Get-View | Where-Object {($_.Guest.ToolsStatus -match "toolsNotInstalled") -or ($_.Guest.ToolsStatus -match "toolsNotRunning") } | Select-Object Name,@{Name="Status";Expression={$_.Guest.ToolsStatus}}

if ($VMswithoutRunningTools) { $VMswithoutRunningTools | Sort-Object Name | ConvertTo-Html | Out-File $outfilepath }

#variables for email output

$eto = "youremail@company.com"

$efrom = "PowerCLI_Reports <PowerCLIReports@company.com>"

$esubject = "Virtual Machines with VMware Tools problems"

If ($VMswithoutRunningTools) { $ebody = (Get-Content $outfilepath | Out-String) }

$eserver = "smtpserver.company.com"

If ($VMswithoutRunningTools) { Send-MailMessage -From $efrom -To $eto -Subject $esubject -BodyAsHtml -Body $ebody -smtpserver $eserver }

Else { Send-MailMessage -From $efrom -To $eto -Subject $esubject -Body "There are no VMs reporting VMware Tools is not installed" -smtpserver $eserver }

Old Snapshots – PowerCLI Email Report

Posted by Chris Allen on January 24, 2015 No comments

Whether your developers are keeping snapshots around for months or your backup program is leaving behind old snapshots due to backup failures, its always good to know about your aging snapshots.

Below is a script which will find all VMs with snapshots older than 7 days. As usual you can customize this to meet your needs, for me I like to keep transcripts and output files for archival and troubleshooting.

$currentdate = (Get-Date).tostring("yyyy-MM-dd")
$transfilename = 'OldSnapsTranscript_' + $currentdate + '.txt'
$transfilepath = 'C:\scripts\Transcripts\' + $transfilename
Start-Transcript $transfilepath -NoClobber -Append

#Load PowerCLI snapins and dot source them
Add-PSSnapin vmware.vimautomation.core
. "C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1"


Connect-VIServer vcenterserver.company.com

#Generating timestamped log name for powercli html output
$7daysago = (Get-Date).AddDays(-7)
$outfilename = 'Old_Snaps_' + $currentdate + '.htm'
$outfilepath = 'C:\scripts\Output\' + $outfilename


$vmswithstalesnaps = Get-VM |
Get-Snapshot | Where-Object {$_.created -lt $7daysago } |
Select-Object vm,Name,Created,@{Name="MbSize";Expression={[math]::Truncate($_.SizeMb)}}

#Convert it to html and save the output if it exists
If ($vmswithstalesnaps) { $vmswithstalesnaps | Sort-Object created | ConvertTo-Html | Out-File $outfilepath }




#variables for email output
$eto = "youremail@company.com"
$efrom = "PowerCLI_Reports <PowerCLIReports@company.com>"
$esubject = "Virtual Machine Stale SnapShot Report"
If ($vmswithstalesnaps) { $ebody = (Get-Content $outfilepath | Out-String) }
$eserver = "smtpserver.company.com"

#check the variable for a value to determine which email to send
If ($vmswithstalesnaps) { Send-MailMessage -From $efrom -To $eto -Subject $esubject -BodyAsHtml -Body $ebody -smtpserver $eserver }
Else { Send-MailMessage -From $efrom -To $eto  -Subject $esubject -Body "There are no VMs with snapshots older than 7 days in this report" -smtpserver $eserver }

$currentdate = (Get-Date).tostring("yyyy-MM-dd")

$transfilename = 'OldSnapsTranscript_' + $currentdate + '.txt'

$transfilepath = 'C:\scripts\Transcripts\' + $transfilename

Start-Transcript $transfilepath -NoClobber -Append

#Load PowerCLI snapins and dot source them

Add-PSSnapin vmware.vimautomation.core

. "C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1"

Connect-VIServer vcenterserver.company.com

#Generating timestamped log name for powercli html output

$7daysago = (Get-Date).AddDays(-7)

$outfilename = 'Old_Snaps_' + $currentdate + '.htm'

$outfilepath = 'C:\scripts\Output\' + $outfilename

$vmswithstalesnaps = Get-VM |

Get-Snapshot | Where-Object {$_.created -lt $7daysago } |

Select-Object vm,Name,Created,@{Name="MbSize";Expression={[math]::Truncate($_.SizeMb)}}

#Convert it to html and save the output if it exists

If ($vmswithstalesnaps) { $vmswithstalesnaps | Sort-Object created | ConvertTo-Html | Out-File $outfilepath }

#variables for email output

$eto = "youremail@company.com"

$efrom = "PowerCLI_Reports <PowerCLIReports@company.com>"

$esubject = "Virtual Machine Stale SnapShot Report"

If ($vmswithstalesnaps) { $ebody = (Get-Content $outfilepath | Out-String) }

$eserver = "smtpserver.company.com"

#check the variable for a value to determine which email to send

If ($vmswithstalesnaps) { Send-MailMessage -From $efrom -To $eto -Subject $esubject -BodyAsHtml -Body $ebody -smtpserver $eserver }

Else { Send-MailMessage -From $efrom -To $eto -Subject $esubject -Body "There are no VMs with snapshots older than 7 days in this report" -smtpserver $eserver }

Virtual Machine Guest Disk Free Space – PowerCLI Email Report

Posted by Chris Allen on January 24, 2015 No comments

I expanded upon a useful sharing from over at the VMware community site.

Below is some code you can use to run against vcenter to get an emailed report of all virtual machines with low free space. The VMs need to have vmware tools running for this report. Don’t worry, I’ll post a script to check on that too!

As a personal preference I like to create a service account with logon as batch rights on a system to run this script. I then provision this same service account with read only privileges to vCenter. Once those things are setup the powershell script can be ran from task scheduler (using least privileged, yay).

Another thing I like to do is to capture transcripts and outputs of any scripts I run. This way if I have an SMTP issue or lose the email, I can go back and check files to see what was in previous reports or any errors that the script encountered.

You will want to edit the vcenter server name, the output file path, and email addresses before using this script. The script will email any VMs with drives that have less than 10% free space, of course, you can customize that % as well.

$currentdate = (Get-Date).tostring("yyyy-MM-dd")
$transfilename = 'OldSnapsTranscript_' + $currentdate + '.txt'
$transfilepath = 'C:\scripts\Transcripts\' + $transfilename
Start-Transcript $transfilepath -NoClobber -Append


#Load PowerCLI snapins and dot source them
Add-PSSnapin vmware.vimautomation.core
. "C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1"


#Connect to vcenter
Connect-VIServer vcenterserver.company.com

#Generating timestamped log name for powercli html output
$outfilename = 'VMFreeSpace_' + $currentdate + '.htm'
$outfilepath = 'C:\Scripts\Output\' + $outfilename

$PoweredOnVMwithTools = Get-VM | Where-Object {($_.PowerState -eq "PoweredOn") -and (($_.Extensiondata.Guest.ToolsStatus -eq "toolsOk") -or ($_.Extensiondata.Guest.ToolsStatus -eq "toolsOld")) }

$DriveReportArray = @()

ForEach ($VM in $PoweredOnVMwithTools){
ForEach ($Drive in $VM.ExtensionData.Guest.Disk){

$Path = $Drive.DiskPath

 

#Calculations 

$Freespace = [math]::Round($Drive.FreeSpace / 1MB)

$Capacity = [math]::Round($Drive.Capacity/ 1MB)

 

$SpaceOverview = "$Freespace" + "/" + "$capacity" 

$PercentFree = [math]::Round(($FreeSpace)/ ($Capacity) * 100) 

 

#VMs with less space

if ($PercentFree -lt 10) {     

    
    $newobj = New-Object -TypeName PSObject
    
    $newobj | Add-Member -Type NoteProperty -Name VM -Value $VM.name

    $newobj | Add-Member -Type NoteProperty -Name Disk -Value $Path

    $newobj | Add-Member -Type NoteProperty -Name FreeMB -Value $Freespace

    $newobj | Add-Member -Type NoteProperty -Name PercentFree -Value $PercentFree

    $DriveReportArray += $newobj
  

}

 

} # End ForEach ($Drive in in $VM.Extensiondata.Guest.Disk)

 

} # End ForEach ($VM in $PoweredOnVMwithTools)


if ($DriveReportArray) { $DriveReportArray | Sort-Object FreeMB | ConvertTo-Html | Out-File $outfilepath }


#variables for email output
$eto = "youremail@company.com"
$efrom = "PowerCLI_Reports <PowerCLIReports@company.com>"
$esubject = "Virtual Machine Guest Disks Low Free Space Report"
If ($DriveReportArray) { $ebody = (Get-Content $outfilepath | Out-String) }
$eserver = "smtpserver.company.com"

If ($DriveReportArray) { Send-MailMessage -From $efrom -To $eto -Subject $esubject -BodyAsHtml -Body $ebody -smtpserver $eserver }
Else { Send-MailMessage -From $efrom -To $eto  -Subject $esubject -Body "There are no VMs with low free space in this report" -smtpserver $eserver }

$currentdate = (Get-Date).tostring("yyyy-MM-dd")

$transfilename = 'OldSnapsTranscript_' + $currentdate + '.txt'

$transfilepath = 'C:\scripts\Transcripts\' + $transfilename

Start-Transcript $transfilepath -NoClobber -Append

#Load PowerCLI snapins and dot source them

Add-PSSnapin vmware.vimautomation.core

. "C:\Program Files (x86)\VMware\Infrastructure\vSphere PowerCLI\Scripts\Initialize-PowerCLIEnvironment.ps1"

#Connect to vcenter

Connect-VIServer vcenterserver.company.com

#Generating timestamped log name for powercli html output

$outfilename = 'VMFreeSpace_' + $currentdate + '.htm'

$outfilepath = 'C:\Scripts\Output\' + $outfilename

$PoweredOnVMwithTools = Get-VM | Where-Object {($_.PowerState -eq "PoweredOn") -and (($_.Extensiondata.Guest.ToolsStatus -eq "toolsOk") -or ($_.Extensiondata.Guest.ToolsStatus -eq "toolsOld")) }

$DriveReportArray = @()

ForEach ($VM in $PoweredOnVMwithTools){

ForEach ($Drive in $VM.ExtensionData.Guest.Disk){

$Path = $Drive.DiskPath

#Calculations

$Freespace = [math]::Round($Drive.FreeSpace / 1MB)

$Capacity = [math]::Round($Drive.Capacity/ 1MB)

$SpaceOverview = "$Freespace" + "/" + "$capacity"

$PercentFree = [math]::Round(($FreeSpace)/ ($Capacity) * 100)

#VMs with less space

if ($PercentFree -lt 10) {

$newobj = New-Object -TypeName PSObject

$newobj | Add-Member -Type NoteProperty -Name VM -Value $VM.name

$newobj | Add-Member -Type NoteProperty -Name Disk -Value $Path

$newobj | Add-Member -Type NoteProperty -Name FreeMB -Value $Freespace

$newobj | Add-Member -Type NoteProperty -Name PercentFree -Value $PercentFree

$DriveReportArray += $newobj

}

} # End ForEach ($Drive in in $VM.Extensiondata.Guest.Disk)

} # End ForEach ($VM in $PoweredOnVMwithTools)

if ($DriveReportArray) { $DriveReportArray | Sort-Object FreeMB | ConvertTo-Html | Out-File $outfilepath }

#variables for email output

$eto = "youremail@company.com"

$efrom = "PowerCLI_Reports <PowerCLIReports@company.com>"

$esubject = "Virtual Machine Guest Disks Low Free Space Report"

If ($DriveReportArray) { $ebody = (Get-Content $outfilepath | Out-String) }

$eserver = "smtpserver.company.com"

If ($DriveReportArray) { Send-MailMessage -From $efrom -To $eto -Subject $esubject -BodyAsHtml -Body $ebody -smtpserver $eserver }

Else { Send-MailMessage -From $efrom -To $eto -Subject $esubject -Body "There are no VMs with low free space in this report" -smtpserver $eserver }

Packet Lost

Get-Content $TodaysThoughts | Out-Blog

Category Archives: PowerCLI

VMware Tools Check – PowerCLI Email Report

Old Snapshots – PowerCLI Email Report

Virtual Machine Guest Disk Free Space – PowerCLI Email Report

Categories

Recent Posts

Find Me

Packet Lost

Get-Content $TodaysThoughts | Out-Blog

Category Archives: PowerCLI

VMware Tools Check – PowerCLI Email Report

Old Snapshots – PowerCLI Email Report

Virtual Machine Guest Disk Free Space – PowerCLI Email Report

Categories

Tags

Recent Posts

Find Me