All our VMs currently have two CI records in the CMDB, one a VMware virtual machine instance from when the vCenter is discovered and the other a windows server record from when the IP address is discovered. Each record has an "instantiated by" relationship set up in the related items section for it's counterpart record. I'm trying to get the State field from the VMware Virtual Machine Instance record to automatically populate and update if the server changes states on the Windows Server record side. I tried adding an attribute on the Windows server record that references the virtual machine instance table but all that did was give us a way to "lookup" servers from the virtual machine instance table which isn't what we're looking for for this. Is it possible to have a field on a record behave this way and what would be the best way to accomplish it?
