RVTOOLS Automation

[KarthikeyanRam1]

Hi All,

I need Powercli script to generate Rvtools report of multiple VCentre and automatically mail us as a single zip file. Please help me as we have 7 Vcentres and we are supporting multiple clients

Thanks a lot for you help in advance.

Thanks,

Karthikeyan Raman

[LucD]

Have a look at 1.  Re: Invoke multiple vcenters from rvtoolsbatch

[KarthikeyanRam1]

Hi LucD,

I have mutiple VC with different username and password. The passthrough will not work. Please help me to work rvtools script across all the VCentre.

I want to use the accounts saved by New-VICredentialStoreItem -Host "vCenter1" -User "domain\useracnt" -Password "password"

Thanks,

Karthikeyan Raman

[KarthikeyanRam1]

Hi Lucd,

I've configured the script according to my need and it works awesome.

I've used rvtools password encryption feature in 3.9.5 to protect my password as well

As rvtools report generation takes time and before the completion of rvtools report generation the sendsmtp got executed

Hence i introduced start -sleep 500 before the smtp code

Thanks

[IFSC SYSAD GIFT CITY]

Hi,

I ran the script and getting the following error: -

Error: Export failed! RVTools returned exitcode -1, probably a connection error! Script is stopped

Though connectivity from the server to the vcenter is working ok..
Can u pls let me know what I am missing...

[LucD]

Without seeing any code it is difficult to analyse your issue.

------------------------------

Blog: lucd.info  Twitter: @LucD22  Co-author PowerCLI Reference

------------------------------

[IFSC SYSAD GIFT CITY]

Please find below:-

# Save current directory
$SaveCurrentDir = (get-location).Path

# Set RVTools path
[string] $RVToolsPath = "C:\Program Files (x86)\Dell\RVTools"

# cd to RVTools directory
set-location $RVToolsPath

# -----------------------------------------------------
# Set parameters for vCenter 1 and start RVTools export
# -----------------------------------------------------
[string] $VCServer = "10.200.242.175"                                                    # my test vCenter server
[string] $User = "vsphere.local\administrator"                                                    

[string] $XlsxDir1 = "C:\Users\admin\Desktop\New folder"
[string] $XlsxFile1 = "vCenter1.xlsx"

# Start cli of RVTools
Write-Host "Start export for vCenter $VCServer" -ForegroundColor DarkYellow
$Arguments = "-u $User -p /***/ -s $VCServer -c ExportAll2xlsx -d $XlsxDir1 -f $XlsxFile1"

Write-Host $Arguments

$Process = Start-Process -FilePath ".\RVTools.exe" -ArgumentList $Arguments -NoNewWindow -Wait -PassThru

if($Process.ExitCode -eq -1)
{
    Write-Host "Error: Export failed! RVTools returned exitcode -1, probably a connection error! Script is stopped" -ForegroundColor Red
    exit 1
}

$OutputFile = "C:\Users\admin\Desktop\New folder\vCenter1.xlsx"

# Back to starting dir
Set-Location $SaveCurrentDir

[LucD]

Seems to work for me.
The only explanation I can think of is that the password is not correct.

------------------------------

Blog: lucd.info  Twitter: @LucD22  Co-author PowerCLI Reference

------------------------------

[Christian Moore]

Thanks for this, I was having the exact same issue and until I read your comment about password issue I was looking at all other possibilities like allowing port 443 and port 902, was starting to thing RVTools didn't support NAT.

Error: Export failed! RVTools returned exitcode -1, probably a connection error! Script is stopped

Turns out I had a accidentally added a space in my encrypted password " _RVToolsV3%" I removed space before the underscore "_RVToolsV3%" and ran script again and success.

Thank You.

[Christian Moore]

This is my script, after I got it all working I setup a scheduled task to run it every week.

If passing through firewall with NATed IP's in place add port 443 and port 902

____________________________________________

# Save current directory
$SaveCurrentDir = (get-location).Path
 
# Set RVTools path
[string] $RVToolsPath = "C:\Program Files (x86)\Dell\RVTools"
 
# cd to RVTools directory
set-location $RVToolsPath
 
 
# -----------------------------------------------------
# Set parameters for vCenter 1 and start RVTools export
# -----------------------------------------------------
[string] $VCServer = "192.168.223.26"                                                    # my test vCenter server
[string] $User = "vc_service_account"                                                    
 
# use -passthroughAuth or an encrypted password. You can encrypt your password with the provided PowerShell script RVToolsPasswordEncryption.ps1
[string] $EncryptedPassword = "%encrypted password%"
 
[string] $XlsxDir1 = "C:\RVTools"
[string] $XlsxFile1 = "tmvnc01.xlsx"
 
# Start cli of RVTools
Write-Host "Start export for vCenter $VCServer" -ForegroundColor DarkYellow
$Arguments = "-u $User -p $EncryptedPassword -s $VCServer -c ExportAll2xlsx -d $XlsxDir1 -f $XlsxFile1"
 
Write-Host $Arguments
 
$Process = Start-Process -FilePath ".\RVTools.exe" -ArgumentList $Arguments -NoNewWindow -Wait -PassThru
 
if($Process.ExitCode -eq -1)
{
    Write-Host "Error: Export failed! RVTools returned exitcode -1, probably a connection error! Script is stopped" -ForegroundColor Red
    exit 1
}
 
 
# ---------------------
# Mail output xlsx file
# ---------------------
 
# Define variables
$FromAddress = "%smtprelayserver%"
$ToAddress = "%email address to send to%"
$Subject = "RVTools TMvnc01 export for all vCenter Servers"
$Body = "Attached is an export of all VM Servers and their corresponding usage of CPU, Memory and Hard Disk space"
$AttachmentPath = "C:\RVTools\tmvnc01.xlsx"  # Replace with the actual file path
 
# Send the email
Send-MailMessage -From $FromAddress -To $ToAddress -Subject $Subject -Body $Body -Attachment $AttachmentPath -SmtpServer %smtprelayserver% -Port 25 -Credential (New-Object -TypeName System.Management.Automation.PSCredential -ArgumentList "%smtprelayserver%", (ConvertTo-SecureString -String "DroopyWARM69water##" -AsPlainText -Force))
 
# Back to starting dir
Set-Location $SaveCurrentDir

[Arnaud Dexant]

Hi,

i'm looking to automate Rvtools export and tried to run a script as task scheduled, but seems Rvtools needs GUI, so it can't be run like "whether user is logged or not"

is your script running like that? or only when user is logged?

-------------------------------------------

[Christian Moore]

Hi @Arnaud Dexant

Yes my script is running fine through Task Scheduler.  you need to have a SMTP Relay Server that the servers can access to export the report and email it.

I set my Task to run "whether user is logged or not" and set the user that it should run the script as.

Also in Task Scheduler you need to make sure you set the Start Program as and set Powershell Argument below
-NoProfile -ExecutionPolicy ByPass -File "C:\%File Location%\RVToolsBatchMultipleVCs.ps1"

-------------------------------------------

[mviel]

Hi @IFSC SYSAD GIFT CITY

Maybe it would be better to open a new Ticket and not add to a  content to a 7 Year old Ticket ,  my2Cent. 

As you didnt included  much info on the circumstances , there could be also a Bug hitting you . 

https://knowledge.broadcom.com/external/article/318142/export-data-failure-sorry-the-data-could.html

[MohammadHadi Milani]

This post is too old but maybe its useful to try

I made it before

https://www.vmtechnics.com/2024/09/16/automate-rvtools-report-generation-with-powershell/

-------------------------------------------