# =============================================================================================================
# Script: Get-RVTools.ps1
# Version: 1.1
# Date: 7/1/2019
# By: TJ Totland, IBM
# =============================================================================================================
<#
.SYNOPSIS
With this RVTools Automation script, you can start the the RVTools export all to xlsx function for multiple vCenter servers.
.DESCRIPTION
With this script you can start the the RVTools export all to xlsx function for multiple vCenter servers.
.EXAMPLE
.\RVToolsBatchMultipleVCs.ps1
#>
# Set RVTools path
[string] $RVTools = "C:\Program Files (x86)\Robware\RVTools\RVTools.exe"
Set-Location $PSScriptRoot # Changes directory to the same directory the script is running from
# ----------------------------------------------------------
# Set parameters (additional parameters in the For-Each Loop
# ----------------------------------------------------------
$CSVFile = import-csv “.\ServerList.csv”
[string] $XlsxDir1 = ".\Reports\"
ForEach($CSVItem in $CSVFile) {
# -----------------------------------------------------
# Set parameters
# -----------------------------------------------------
$Datetime = get-date -format `yyyyMMdd-HHmm.ss
$VCServer = $CSVItem.VCServer
$User = $CSVItem.User
$EncryptedPassword = $CSVItem.EncryptedPassword
[string] $XlsxFile1 = $Datetime + "-" + $VCServer + "_RVTools-Export.xlsx" # Start cli of RVTools
Write-Host "$VCServer at $Datetime : Export Started" # -ForegroundColor DarkYellow
# Adds all the arguments into a variable to be added to RVTools.exe command
$Arguments = "-u $User -p $EncryptedPassword -s $VCServer -c ExportAll2xlsx -d $XlsxDir1 -f $XlsxFile1 -DBColumnNames -ExcludeCustomAnnotations"
# Runs the RVTools process with all arguments from above
$Process = Start-Process -FilePath "$RVTools" -ArgumentList $Arguments -NoNewWindow -Wait -PassThru
# Checks for Error and writes to Host Screen if problem
if($Process.ExitCode -eq -1) {
Write-Host "$VCServer at $Datetime : Connection FAILED!" -ForegroundColor Red
# exit 1
} else {
Write-Host "$VCServer at $Datetime : Export Successful" -ForegroundColor DarkYellow
}
}
