RVTools: Automate report

1, Using RVToolsPasswordEncryption.exe to encrypted password

2. Set the Short date format

<a href="https://s4.51cto.com/wyfs02/M00/98/23/wKioL1k3woWg0eHRAAA3LsWAmV0956.png" target="_blank"></a>

3. BAT file to run RVtools(RVtools.bat), revise the account and password accordingly(highlight with red color)

rem #########################

rem Name RVToolsBatch

rem By Hunter

rem Date Apr 2017

rem Version 3.9.5

rem =====================================

rem Include robware/rvtools in searchpath

set path=%path%;c:\program files\robware\rvtools 3.9.5

rem =========================

rem Set environment variables

set $datetime=%date:~6,4%%DATE:~3,2%%DATE:~0,2%

set $VCServer=VC name or IP

set $AttachmentDir=C:\temp

set $AttachmentFile=RVTOOLS_%$datetime%_%$VCServer%.xls

rem ===================

rem Start RVTools batch

RVTools.exe -u ABC_DM\hunter -p _RVToolsPWDSAimNtfac7sBlN8HczNdjvHyqknIETj5oy7/gE3uISc= -s %$VCServer% -c ExportAll2xls -d %$AttachmentDir% -f %$AttachmentFile%

timeout /T 30

3.Create a window schedule task to run the bat file

1)  create a task

2) Add the BAT script to window task, and set the triggers condition.

More reference

<a href="http://cloudmaniac.net/rvtools-automate/" target="_blank">http://cloudmaniac.net/rvtools-automate/</a>

<a href="http://robware.net/download/RVTools.pdf" target="_blank">http://robware.net/download/RVTools.pdf</a>

本文轉自學海無涯部落格51CTO部落格，原文連結http://blog.51cto.com/549687/1931597如需轉載請自行聯系原作者

520feng2007