Tech TIP: CA UIM DA & Virtual Machines at physical_infrastructure group

Document created by Tomas Vrbka Employee on Feb 24, 2017Last modified by Tomas Vrbka Employee on Feb 24, 2017
Version 2Show Document
  • View in full screen mode

If you are using CA UIM Physical & vmware Data Adapters same time  for servers that has agent and monitored by vmware probe same time, you can observe virtual machines grouped under physical_infrastructure. 

 

Problem has no OOB solution at product itself and no change is planned at CA in that but you can make a workaround consisting filling up column SERVER_DIM.PHYSICAL_HOST

So called Oracle corellated update:

UPDATE SERVER_DIM s SET (s.PHYSICAL_HOST) = 
(
SELECT sv.PHYSICAL_HOST FROM SERVER_VIRT_DIM_ACTIVE_VIEW sv
WHERE
s.SERVER_DIM_ID = sv.SERVER_DIM_ID and
s.END_DATE IS NULL and
sv.END_DATE IS NULL and
s.PHYSICAL_HOST IS NULL and
sv.PHYSICAL_HOST IS NOT NULL
)
WHERE EXISTS
(
SELECT 1 FROM SERVER_VIRT_DIM_ACTIVE_VIEW sv
WHERE
s.SERVER_DIM_ID = sv.SERVER_DIM_ID and
s.END_DATE IS NULL and
sv.END_DATE IS NULL and
s.PHYSICAL_HOST IS NULL and
sv.PHYSICAL_HOST IS NOT NULL
);

The command takes values of SERVER_VIRT_DIM_ACTIVE_VIEW.PHYSICAL_HOST and copy the value to SERVER_DIM.PHYSICAL_HOST.

DM groups Data Adapter then is able to handle VM as VM and make groups fine.

Run this command by scheduled job just before you run DM groups Data Adapter

 

Regards Tomáš

 

PS This has also influence on some CCR reports which looks for SERVER_DIM.PHYSICAL_HOST column. (explore xml(s) at C:\NETQOS\portal\Integration\DataManager)

Attachments

    Outcomes