Lucd,
For clear understanding here is the complete script.
# VAR DECLARATIONS
$date = ((Get-Date).ToString("MMddyyyy"))
#$vCenterFile = "vCenters7.csv"
$vCenterFile = "vCenters-Encrypted.csv"
$hostInvFile = "host_inventory-$date.csv"
$vcInvFile = "host_inv_vc_errors-$date.csv"
Clear-Host
$path = Split-Path ($MyInvocation.MyCommand.Path)
Set-Location $path
# Load PowerCLI snapin
if (-not (Get-PSSnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue)) {
Add-PSSnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue
if ($LASTEXITCODE -eq 0) {
sleep 5
Add-PSSnapin VMware.VimAutomation.Core -ErrorAction SilentlyContinue
if (!$?) {
Write-Error "Unable to add VMware.VimAutomation.Core snapin"
Start-Process -FilePath 'http://communities.vmware.com/community/vmtn/server/vsphere/automationtools/powercli'
exit
}
}
}
# Verify PowerCLI version
if ((Get-PowerCLIVersion).Major -lt 5) {
$Response = Read-Host "PowerCLI 5 not found. Script may not run properly. Do you want to continue? [n = No, default = Yes]"
if ($Response -eq "n") {
Start-Process -FilePath 'http://communities.vmware.com/community/vmtn/server/vsphere/automationtools/powercli'
exit
}
Remove-Variable Response -Confirm:$false
}
# Verify PowerShell version
if ($Host.Version.Major -lt 2) {
Write-Error "PowerShell version 2 or greater is required"
exit
}
Set-PowerCLIConfiguration -ProxyPolicy NoProxy -DefaultVIServerMode Single -InvalidCertificateAction Ignore -Confirm:$false | Out-Null
trap { continue }
if (!(Test-Path $path\$vCenterFile)) {
Write-error "Missing vCenter file"
exit
}
$allVC = Import-Csv $path\$vCenterFile -ErrorAction SilentlyContinue | Sort vCenter
if (-not (Test-Path $path\$date)) {
New-Item -ItemType Directory $path\$date -ErrorAction SilentlyContinue | Out-Null
}
$hostInvFile = "$path\$date\" + $hostInvFile
$vcInvFile = "$path\$date\" + $vcInvFile
if (Test-Path $hostInvFile) {
rm $hostInvFile -Confirm:$false | Out-Null
}
New-Item $hostInvFile -ItemType File | Out-Null
if (Test-Path $vcInvFile) {
rm $vcInvFile -Confirm:$false | Out-Null
}
New-Item $vcInvFile -ItemType File | Out-Null
Set-Content -Encoding UTF8 -Path $hostInvFile "vCenter,Cluster,Host,NTP,Hosttime"
Set-Content -Encoding UTF8 -Path $vcInvFile "vCenter,Connection"
$vcarray = @()
$vmhosts = @()
$esxpass = Read-Host "Enter ESX root password" -AsSecureString
$rootCred = New-Object System.Management.Automation.PSCredential("root",$esxpass)
foreach ($vc in $allVC) {
$vCenter = $vc.vCenter
if ($vc.Comment -notmatch "host") {
$vcUser = $vc.User
$vcPass = ConvertTo-SecureString -String $vc.Pass -Key (1..16)
$vcCred = New-Object System.Management.Automation.PSCredential($vcUser,$vcPass)
Write-Host $vCenter":"
$vcConnect = Connect-VIServer $vCenter -Credential $vcCred -WarningAction SilentlyContinue -ErrorAction SilentlyContinue
} else {
Write-Host $vCenter":"
$vcConnect = Connect-VIServer $vCenter -cred $rootCred -WarningAction SilentlyContinue -ErrorAction SilentlyContinue
}
if (!$vcConnect) {
$vcConnection = "Failed"
Write-Host " >Failed" -ForegroundColor Red
Add-Content -Path $vcInvFile "$vcenter,$vcConnection"
}
else {
Write-Host " >Successful"
$vcConnection = "Successful"
$vmhosts = Get-VMHost | Sort Name
foreach ($esx in $vmhosts) {
$hostVC=$vcenter
$hostCluster=$esx.Parent.Name
$hostHost=$esx.Name
$dns = ($esx | Get-VMHostNetwork).DnsAddress
$hostDNS = "$dns"
$ntp = $esx | Get-VMHostNtpServer
The below is the one i am unable to fix. The host current time. Please help.
#$time = ($esx | get-esxcli)|select @{n='Time';e={$esxcli.system.time.get()}}
#$time = $esx | Get-VMhost $_.ConfigManager.DateTimeSystem
$hostTime = "$time"
}
Add-Content -Path $hostInvFile "$hostVC,$hostCluster,$hostHost,$hostNTP,$hostTime"
}
Add-Content -Path $vcInvFile "$vcenter,$vcConnection"
Disconnect-VIServer -Server $vcenter -Confirm:$false -ErrorAction SilentlyContinue
}
Invoke-Item $path\$date
Write-Host "Execution completes ... Exiting"
Thanks
vKar
