Automation

I have below script to check the ESXi host disconnection time from VCenter. I am trying to change the Date format from DD/MM/YYYY 24HH:MM to MM/DD/YYYY 24HH:MM  using $date = Get-Date -format "mmddyyyy" but nothing useful.

$esx = Get-VMHost

Get-VIEvent -Entity $esx -MaxSamples 99999 -Start (Get-Date).AddDays(-7)| `

where {"HostConnectionLostEvent","HostConnectedEvent" -contains $_.GetType().Name} | `

Sort-Object -Property {$_.CreatedTime.DateTime} | `

Select @{N="Hostname";E={$_.Host.Name}},

       @{N="Time";E={$_.CreatedTime.ToShortDateString() + " " + $_.CreatedTime.ToShortTimeString()}},

       @{N="Status";E={if($_.GetType().Name -eq "HostConnectedEvent"){"Connected"}else{"Not connected"}}}|

Export-Csv Disconnected.csv -NoTypeInformation -UseCulture

Current output is

I need the output like below

any one can help please.

Did you try like this?

@{N='Time';E={$_.CreatedTime.ToString('MM/dd/yy HH:mm') }}

Hi LucD,

Thank you very much. It gives the output as expected format. Is it possible to get the order . as like below or Just need to calculate the time difference between disconnected and connected time.

Regards

Ranjithbabhu

Try something like this

Hi LucD,  This works perfect for single ESXi server.

But if i run for entire VCenter (around 140 host) its keep on running. May be the while loop somewhere getting struck.

$esx = Get-VMHost

Get-VIEvent -Entity $esx -MaxSamples 99999 -Start (Get-Date).AddDays(-7) |

#Get-VIEvent -Entity $esx -MaxSamples ([int]::MaxValue) -Start (Get-Date).AddDays(-7) |

Where-Object { "HostConnectionLostEvent", "HostConnectedEvent" -contains $_.GetType().Name } |

Group-Object -Property { $_.Host.Name } -PipelineVariable group |

ForEach-Object -Process {

    $events = $group.Group | Sort-Object -Property { $_.CreatedTime.DateTime }

    $i = 0

    while ($i -lt $events.Count) {

       while ($events[$i] -isnot [VMware.Vim.HostConnectionLostEvent]) {

            $i++

        }

        $disconnect = $events[$i]

        $i++

        while ($events[$i] -isnot [VMware.Vim.HostConnectedEvent]) {

           $i++

        }

        $connect = $events[$i]

        New-Object PSObject -Property ([ordered]@{

                HostName     = $group.Name

                Disconnected = $disconnect.CreatedTime.ToString('MM/dd/yy HH:mm')

                Connected    = $connect.CreatedTime.ToString('MM/dd/yy HH:mm')

                Outage       = (New-TimeSpan -Start $disconnect.CreatedTime -End $connect.CreatedTime).ToString("h':'m':'s")

            })

        $i++

    }

}|

Export-Csv Disconnected_state_inVC.csv -NoTypeInformation -UseCulture

$global:DefaultVIServers | ForEach-Object { Disconnect-VIServer $_ -Confirm:$false }

I suspect the Get-VIEvent call might take a lot of time to complete.

Add some Write-Host statements to see where it takes most of the time.

But in the below script  same Get-VIEvent command completed within 10 Minutes.  I suspect if there might be only multiple connected events  and there is no disconnected events. In below script  i can see sometimes host connected events  only.

$esx = Get-VMHost

Get-VIEvent -Entity $esx -MaxSamples 99999 -Start (Get-Date).AddDays(-30)| `

where {"HostConnectionLostEvent","HostConnectedEvent" -contains $_.GetType().Name} | `

Sort-Object -Property {$_.CreatedTime.DateTime} | `

Select @{N="Hostname";E={$_.Host.Name}},

       @{N='Time';E={$_.CreatedTime.ToString('MM/dd/yy HH:mm') }},

      # @{N="Time";E={$_.CreatedTime.ToShortDateString() + " " + $_.CreatedTime.ToShortTimeString()}},

       @{N="Status";E={if($_.GetType().Name -eq "HostConnectedEvent"){"Connected"}else{"Not connected"}}}|

Export-Csv Disconnected_state_inVC1.csv -NoTypeInformation -UseCulture

$global:DefaultVIServers | ForEach-Object { Disconnect-VIServer $_ -Confirm:$false }

This host is recently joined on this Vcenter.