[HaBo]

cls
#Define Functions
Function Percent ($Pice, $Total)
{
$Percents = $Pice/($Total/100)
$Ausgabe = $Percents.ToString("##0.##")
return $Ausgabe
}
Function PercentforAvailability ($Pice, $Total)
{
$Percents = $Pice/($Total/100)
$Ausgabe = 100 - $Percents
$Ausgabe = $Ausgabe.ToString("##0.##")
return $Ausgabe
}


#Clear Screen from Old Output
cls
$Hosts = Get-VMHost
$Hosts = $Hosts | Sort-Object
foreach ($ESX in $Hosts)
{
# Getting the Events from the Server
$Server = $ESX.Name
$xy = get-vmhost $Server | Get-VIEvent -Start "01.01.2000" -MaxSamples 99999999| `

where {($_.GetType().Name -eq "HostConnectionLostEvent") -or (($_.GetType().Name -eq "TaskEvent") -and ($_.Info.DescriptionId -like "*MaintenanceMode*")) `
-or ($_.GetType().Name -eq "HostConnectedEvent") } | `
Select CreatedTime,@{N="Hostname";E={$_.Host.Name}},@{N=" Description";E={$_.Info.DescriptionId}},@{N="Event ";E={$_.GetType().Name}}

[array]::Reverse($xy)
$xy = ($xy | select Hostname, Description, Event, CreatedTime -Unique)

# Calculating of the diffrent Times
$X=1
$ZeitPlanedDown=0
$ZeitUnplanedDown=0
$ZeitEnterMaintenance=0
$ZeitExitMaintenance=0
$ZeitMaintenance=0
$Maintenance="false"

#This Loop runs for every Entry of the VIEvents
while ($X -lt $xy.Count)
{
# IF the Server is in Maintenance the Downtime have to be Calculated for "Planned" Downtime,
# this Part of the Programm going active.
IF ($Maintenance -eq "true")
{
# IF The Server leave The Maintenace Mode, Calculate the Time of the Maintenance Mode and
# add the Time to the Full Maintenace Time.
IF ($xy[$x].Description -eq "HostSystem.exitMaintenanceMode")
{
$Maintenance = "false"
#Write-Host "Server verlässt Maintenance"
$ZeitExitMaintenance = $xy[$X].CreatedTime
$ZeitMaintenanceCalculate = $ZeitExitMaintenance - $ZeitEnterMaintenance
$ZeitMaintenance += $ZeitMaintenanceCalculate.TotalSeconds
#Write-Host "MaintenanceZeit: " $ZeitMaintenance
}
Else
{
# IF a "HostConnectedEvent" or a "HostConnectionLost" Event appears run this Part of the Programm.
IF ($xy[$x].Event -like "Host*Event")
{
# IF the Host Reconnect to the vCenter, Calculate the PlanedDowntime and Add this to the Full
# Planned Downtime Time.
IF (($xy[$x].Event -eq "HostConnectedEvent") -and ($xy[$x-1].Event -eq "HostConnectionLostEvent"))
{
$ZeitPlanedDownCalculate = $xy[$x].CreatedTime - $xy[$x-1].CreatedTime
$ZeitPlanedDown += $ZeitPlanedDownCalculate.TotalSeconds
#Write-Host "PlanedDown" $ZeitPlanedDown
}
# If this is "just" a "HostConnectionLost" Event the Programm should do Nothing coze its calculate the Time on a
# other Part of this Programm.
ElseIF (($xy[$x].Event -eq "HostConnectionLostEvent") -and ($xy[$x+1].Event -eq "HostConnectedEvent"))
{
#Write-Host "XXXXXXXXXXXXXX Wird ausgewertet XXXXXXXXXXX"
}
# If There some Other Events, run this Part of the Programm.
Else
{
# Sometimes there are a "HostConnectedEvent" whitout Powerdown before, if this happen
# Run this Part of Programm
IF (($xy[$x].CreatedTime.Hour -eq $xy[$x-1].CreatedTime.Hour) -and ($xy[$x].CreatedTime.Minute -eq $xy[$x-1].CreatedTime.Minute) -and ($xy[$x].CreatedTime.Second -eq $xy[$x-1].CreatedTime.Second))
{
# Just Diagnostic Output, i need it for Programming and dont wanna delete
# Dunno may i need it later for Debug or something.
#Write-Host "XXXXXXXXXXXXXX Doppelter Eintrag XXXXXXXXXXX"
#$xy[$x-1].CreatedTime
#$xy[$x].CreatedTime
#Write-Host "XXXXXXXXXXXXXX Doppelter Eintrag XXXXXXXXXXX"
}
Else
{
# Here i made a Douple Check, this should be fixed later.
# Here i never got output.
IF (($xy[$x].Event -like "HostConnectedEvent") -and ($xy[$x-1].Event -like "HostConnectedEvent"))
{
#Write-Host "Server still Running Event"
}
# IF still some Failure, give me also the Event before and after that i could
# check what happend. Also "just Diagnostic" Part for me.
Else
{
Write-Host "XXXXXXXXXXXXXX 1 FAILURE XXXXXXXXXXX"
Write-Host $xy[$x-1].Event, $xy[$x-1].CreatedTime
Write-Host $xy[$x].Event, $xy[$x].CreatedTime
Write-Host $xy[$x+1].Event, $xy[$x+1].CreatedTime
Write-Host "XXXXXXXXXXXXXX 1 FAILURE XXXXXXXXXXX"
}
}
}
}
Else
{
# Sometimes im not patience and the Server goes not fast enough into Maintenance i push
# the "Enter Maintenance" Button twice. So i Need this IF.
IF (($Maintenance -eq "true") -and ($xy[$x].Description -eq "HostSystem.enterMaintenanceMode"))
{
#Do Nothing
}
# Diagnostic Part, sometimes really usefull.
else
{
Write-Host "XXXXXXXXXXXXXXXFAILUREXXXXXXXXXXXXXXX"
Write-Host "Maintenance" $xy[$X].Event $xy[$X].Description
Write-Host "XXXXXXXXXXXXXXXFAILUREXXXXXXXXXXXXXXX"
}
}
}
}
# Run IF SErver is NOT in Maintenance-Mode
Else
{
# IF Server Enter Maintenance Mode Save Time and Change Value "Maintenance" to "true"
IF ($xy[$x].Description -eq "HostSystem.enterMaintenanceMode")
{
$Maintenance = "true"
$ZeitEnterMaintenance = $xy[$x].CreatedTime
#Write-Host "Server betritt Maintenance"
}
# IF Server doesnt Enter Maintenance Mode
Else
{
#If this is a HostConnected or HostConnectionlost Event run this Part of Programm
IF ($xy[$x].Event -like "Host*Event")
{
# IF Server Reconnect, Calculate Unplaned Downtime and Add to Full UnplanedDowntime Time
IF (($xy[$x].Event -eq "HostConnectedEvent") -and ($xy[$x-1].Event -eq "HostConnectionLostEvent"))
{
$ZeitUnplanedDownCalculate = $xy[$x].CreatedTime - $xy[$x-1].CreatedTime
$ZeitUnplanedDown += $ZeitUnplanedDownCalculate.TotalSeconds
#Write-Host "Unplaned Down" $ZeitUnplanedDown
}
# If there is a Connection Lost Event whit a following HostConnectedEvent do nothing,
# will calculate on a other Part in Programm
ElseIF (($xy[$x].Event -eq "HostConnectionLostEvent") -and ($xy[$x+1].Event -eq "HostConnectedEvent"))
{
#Write-Host "XXXXXXXXXXXXXX Wird ausgewertet XXXXXXXXXXX"
}
# IF there is a Entry i didnt thing about, run this part of Programm
Else
{
# Sometimes Douple Entrys happen, so run this part of Programm for diagnostic
IF (($xy[$x].CreatedTime.Hour -eq $xy[$x-1].CreatedTime.Hour) -and ($xy[$x].CreatedTime.Minute -eq $xy[$x-1].CreatedTime.Minute) -and ($xy[$x].CreatedTime.Second -eq $xy[$x-1].CreatedTime.Second))
{
#Write-Host "XXXXXXXXXXXXXX Doppelter Eintrag XXXXXXXXXXX"
#$xy[$x-1].CreatedTime
#$xy[$x].CreatedTime
#Write-Host "XXXXXXXXXXXXXX Doppelter Eintrag XXXXXXXXXXX"
}
# IF Something else happend.
Else
{
# Douple Check, this part of Programm never come up
IF (($xy[$x].Event -like "HostConnectedEvent") -and ($xy[$x-1].Event -like "HostConnectedEvent"))
{
Write-Host "Server still Running Event"
}
# For diagnostic give me also the Event Before and After that i could Check what happend
Else
{
Write-Host "XXXXXXXXXXXXXX 2 FAILURE XXXXXXXXXXX"
Write-Host $xy[$x-1].Event, $xy[$x-1].CreatedTime
Write-Host $xy[$x].Event, $xy[$x].CreatedTime
Write-Host $xy[$x+1].Event, $xy[$x+1].CreatedTime
Write-Host "XXXXXXXXXXXXXX 2 FAILURE XXXXXXXXXXX"
}
}
}
}
# IF there is Still some Failure, give me please the Event.
Else
{
IF (($xy[$X].Description -like "HostSystem.exitMaintenanceMode") -and ($X -le 2))
{
# First Exit of Maintenance coze the Host ist not a new Installation
# If it is a Update this could happen.
}
Else
{
Write-Host "XXXXXXXXXXXXXXXFAILUREXXXXXXXXXXXXXXX"
Write-Host "NotMaintenance" $xy[$X].Event $xy[$X].Description
Write-Host "XXXXXXXXXXXXXXXFAILUREXXXXXXXXXXXXXXX"
}
}
}
}
# Count UP for the Loop
$X++
}

#Calculatin Runtime
$FirstEvent = $xy[1].CreatedTime
$Livetime = Get-Date
$Livetime = $Livetime - $FirstEvent

# Bring the Time in a Human Readable Format
$TotalMaintenance = New-TimeSpan -Seconds $ZeitMaintenance
$TotalUnplanedDown = New-TimeSpan -Seconds $ZeitunplanedDown
$TotalPlanedDown = New-TimeSpan -Seconds $ZeitPlanedDown

# Output on the Screen
Write-Host "Availability Report for "$Server
$FirstEvent = Get-Date $FirstEvent -Format D
$Today = Get-Date -Format D
Write-Host $FirstEvent " - " $Today
Write-Host " "
$availability = $Livetime.TotalSeconds
$Downtime = $TotalPlanedDown.TotalSeconds + $TotalUnplanedDown.TotalSeconds
$availability = PercentforAvailability $Downtime $availability
Write-Host "Availability: " $availability" %"
Write-Host "Total Time: " $Livetime.Days " Days "$Livetime.Hours" hours" $Livetime.Minutes " minutes"
Write-Host " "
$Uptime = $Livetime.TotalSeconds - $TotalPlanedDown.TotalSeconds - $TotalUnplanedDown.TotalSeconds
$Uptime = New-TimeSpan -Seconds $Uptime
Write-Host "Uptime: " $Uptime.Days " Days " $Uptime.Hours" hours" $Uptime.Minutes " minutes"
$Downtime = New-TimeSpan -Seconds $Downtime
Write-Host "Downtime: " $Downtime.days " Days " $Downtime.Hours" hours" $Downtime.Minutes " minutes"
Write-Host " "
Write-Host "Maintenance"
Write-Host "Maintenance Time: " $TotalMaintenance.Days " Days " $TotalMaintenance.Hours " hours" $TotalMaintenance.Minutes " minutes"
$availability = $Livetime.TotalSeconds
$TimeMaintenace = $TotalMaintenance.TotalSeconds
$PercentMaintenance = Percent $TimeMaintenace $availability
Write-Host "Maintenance is " $PercentMaintenance "% of the Full LiveTime"
Write-Host "Downtime during Maintenance: " $TotalPlanedDown.Days " Days " $TotalPlanedDown.Hours " hours" $TotalPlanedDown.Minutes " minutes"
$availability = $Livetime.TotalSeconds
$TimeDowntime = $TotalPlanedDown.TotalSeconds
$PercentMaintenance = Percent $TimeDowntime $availability
Write-Host "Downtime is " $PercentMaintenance "% of the Full LiveTime and"
$availability = $TotalMaintenance.TotalSeconds
$TimeDowntime = $TotalPlanedDown.TotalSeconds
$PercentMaintenance = Percent $TimeDowntime $availability
Write-Host "Downtime is" $PercentMaintenance "% of the Full Maintenance Time"
Write-Host " "
$availability = $Livetime.TotalSeconds
$TimeDowntime = $TotalUnplanedDown.TotalSeconds
$PercentDowntime = Percent $TimeDowntime $availability
Write-Host "Unplaned Downtime: " $TotalUnplanedDown.Days " Days " $TotalUnplanedDown.Hours " hours" $TotalUnplanedDown.Minutes " minutes"
Write-Host "This is " $PercentDowntime "% of the Full LiveTime"
Write-Host " "
Write-Host " "
Write-Host " "
}

Availability Report for %FQDN%
Montag, 31. Mai 2010 - Mittwoch, 29. Juni 2011

Availability: 99,87 %
Total Time: 393 Days 22 hours 50 minutes

Uptime: 393 Days 10 hours 55 minutes
Downtime: 0 Days 11 hours 55 minutes

Maintenance
Maintenance Time: 0 Days 9 hours 25 minutes
Maintenance is 0,1 % of the Full LiveTime
Downtime during Maintenance: 0 Days 5 hours 22 minutes
Downtime is 0,06 % of the Full LiveTime and
Downtime is 56,98 % of the Full Maintenance Time

Unplaned Downtime: 0 Days 6 hours 32 minutes
This is 0,07 % of the Full LiveTime