Knowledgebase

VMware VCM - Set new machines to HTTP instead of DCOM

If you use the following SQL trigger the VCM system behaviour will be changed to automatically create machines always in HTTP mode instead of DCOM.

Please notice that this is not a supported change and it will remove the ability to setup DCOM. 

USE [VCM]
GO
/****** Object: Trigger [dbo].[trg_http_con] Script Date: 03/01/2013 10:28:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author: Yves Sandfort, Claude Vocat
-- Create date: 23.09.2013
-- Description: Update windows clients to talk http
-- =============================================
CREATE TRIGGER [trg_http_con]
ON ecm_dat_machines
FOR INSERT,UPDATE
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for trigger here
UPDATE ecm_dat_machines
SET machine_connection_mechanism_primary = 2,
machine_connection_mechanism_secondary = NULL,
machine_connection_http_port = 26542
WHERE prov_os_machine_id is NULL and machine_id in (select machine_id from inserted)
END

Kommentieren

Go back