5.8

Restoring File System Components
Restore the file system components from the CMFiles$ share locations and any other corporate standard
items.
The default location is C:\Program Files (x86)\VMware\VCM\WebConsole\L1033\Files.
If other custom components are installed, see the disaster recovery documentation for each customization.
Run the Script for Exported Reports
Most of the scheduled reports exported from your previous Collector include a hard-coded server name.
The scripts for exported reports update the old server name export location with the new name.
The scripts modify the parameters passed and the UI string. Any UI strings greater than 8000 characters
must be handled differently. In these cases, the exports will work properly. However, if you edit the
scheduled job the report shows the old location.
If you edit one of these exceptions and click Finish without first correcting the export location, the
connection to the report will break.
Procedure
1. Log in to SQL Server Management Studio as a user with Administrative privileges.
2. In the following script, edit the @oldserver and @newserver variables.
Declare @oldserver varchar(32)
Declare @newserver varchar(32)
set @oldserver = 'OLDSERVERNAME'
set @newserver = 'NEWSERVERNAME'
update dbo.ecm_rpt_reports_scheduled
set export_path = '\\' +
@newserver +
substring(export_path,len(@oldserver)+3, len(export_path)-(len
(@oldserver)+2))
where export_path like '%' + @oldserver + '%'
update dbo.ecm_sysdat_actions_ui_definition_text_xref
set definition_text =
replace(cast(definition_text as varchar(max)), @oldserver,
@newserver)
where
definition_text like '%' + @oldserver + '%'
3. Run the script.
Installing VCM and Restoring Associated Components On the Recovery Machines
VMware, Inc.
43