Page History

UPDATE entity
SET defining_erdc_base_id = (
	SELECT eb1.erdc_base_id FROM erdc_base eb1 WHERE eb1.name = 'MonitorDummyVmware'
)
WHERE entity_id IN (
	SELECT e2.entity_id FROM entity e2
	LEFT JOIN entity_subtype es ON e2.entity_subtype_id = es.entity_subtype_id
	LEFT JOIN erdc_base eb ON e2.defining_erdc_base_id = eb.erdc_base_id
	LEFT JOIN vmware_object vo ON e2.entity_id = vo.entity_id
	WHERE es.name='Virtual Machine'
	AND eb.name != 'MonitorDummyVmware'
	AND e2.entity_id NOT IN
	(SELECT entity_id FROM erdc_instance WHERE name LIKE 'Configuration Update Gatherer'
	)
);