Page History

This article explains how to fix a VMware element that was automatically added to up.time through the vSync process but is only collecting performance metrics provided by vCenter for the VM and not from the up.time Agent.

When a new VM is created in a vCenter system that is monitored by up.time, that VM will automatically get added to up.time. If the up.time Agent is installed on that VM (or if WMI collection is an option), then the up.time Monitoring Station will notice that on a regularly scheduled vSync scan. When the Agent (or WMI) is discovered, the VM element will be converted from using VM-basic collection to use VM+Agent (or VM+WMI) collection. VM-basic collection only collects performance metrics for the VM element from vCenter, whereas VM+Agent collection means that performance metrics for that VM element are collected from vCenter as well as the up.time Agent.

...

SELECT e.entity_id, e.name, e.display_name, (e.monitored+0) AS '"Monitored'" FROM entity e
LEFT JOIN entity_subtype es ON e.entity_subtype_id=es.entity_subtype_id
LEFT JOIN erdc_base eb ON e.defining_erdc_base_id=eb.erdc_base_id
LEFT JOIN vmware_object vo ON e.entity_id=vo.entity_id
WHERE es.name='Virtual Machine'
AND eb.name != 'MonitorDummyVmware'
AND e.entity_id NOT IN
(SELECT entity_id FROM erdc_instance WHERE name LIKE 'Configuration Update Gatherer');

...

• using an UPDATE statement very similar to the SELECT statement above, we'll switch the affected elements to use VM-basic collection again

UPDATE entity e, (
	SELECT e2.entity_id FROM entity e2
	LEFT JOIN entity_subtype es ON ee2.entity_subtype_id = es.entity_subtype_id
	LEFT JOIN erdc_base eb ON ee2.defining_erdc_base_id = eb.erdc_base_id
	LEFT JOIN vmware_object vo ON ee2.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'
	)
) t 
SET e.defining_erdc_base_id = (SELECT eb1.erdc_base_id FROM erdc_base eb1 WHERE eb1.name = "MonitorDummyVmware")
WHERE'MonitorDummyVmware')
WHERE e.entity_id = t.entity_id;

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. es.name='Virtual Machine'
	AND eb.name != 'MonitorDummyVmware'
	AND ee2.entity_id NOT IN
	(SELECT entity_id FROM erdc_instance WHERE name LIKE 'Configuration Update Gatherer'
	)
);

It is very unusual for the failed conversion to happen again for the same element but if the symptom mentioned above (NPE error in Poll Agent output) appear again, try the SQL statements again.

...

1. in the up.time UI, click the dropdown button beside your username in the top right corner and select Support
2. scroll down and click the Agent Scanner link (about half way down the page)
3. enter the hostname of the agent system
4. select the Uptime Agent radio button
5. enter 9998 in the Port field
6. check each of the Agent Command boxes

7. click the Query button (above the Agent Command boxes)

...