UIM VMware probe. Export VM UUID

Document ID : KB000123175
Last Modified Date : 08/01/2019
Show Technical Document Details
Issue:
Does the UIM vmware probe already retrieve the VM UUIDs from VCenter?
Resolution:
The UUID of each guest is collected by the probe and held in the db in table cm_device_attribute it has the dev_attr_key VirtualID

you would need to look up the dev_id for the vm from the cm_device table and then use this to query the cm_device_attribute table
eg

1. look up the dev_id for the vm from the cm_device table
SELECT dev_id ,dev_name FROM [CA_UIM].[dbo].[CM_DEVICE] where dev_name = 'svr2012' 
result 
dev_iddev_name
D9553bd962be2f38f89d37d7923e378fbsvr2012


2.use this to query the cm_device_attribute table
SELECT dev_attr_value FROM [CA_UIM].[dbo].[CM_DEVICE_ATTRIBUTE] where dev_id = 'D9553bd962be2f38f89d37d7923e378fb' AND dev_attr_key = 'VirtualID'

Result
dev_attr_value
5236009a-152b-ad79-0303-ebac72745d1b