CommVault Simpana 9.0 changing FTP site location details

As noted in this post, Simpana 9.0 SP1B onwards removed the ability to change the FTP site location used for updates via the GUI. If you’d like to modify these values, you can use the following qoperations to perform it from command line, you’ll need to first authenticate using qlogin etc.

 
Update with desired ftp location;

qoperation execscript -sn SetKeyIntoGlobalParamTbl.sql -si "Patch FTP Site" -si y -si "download.ftp.com"

Update with the username and password, using plain text:

qoperation execscript -sn SetKeyIntoGlobalParamTbl.sql -si "Patch FTP Site UserName" -si y -si "user"
qoperation execscript -sn SetKeyIntoGlobalParamTbl.sql -si "Patch FTP Site Password" -si y -p1 "password"

In the ftp site, do not include ftp:// as this is NOT REQUIRED.