+10 for this feature. ;)

it should actually not be that hard, it could start as a rake task to compare MAC addresses, and later on with a UI.. any takers? :)

here is an example patch, it does not include UI nor rake task, but gives an example:

diff --git a/app/models/compute_resource.rb b/app/models/compute_resource.rb
index 7da5982..3c4dea2 100644
--- a/app/models/compute_resource.rb
+++ b/app/models/compute_resource.rb
@@ -176,6 +176,25 @@ class ComputeResource < ActiveRecord::Base
     []
   end

+  def import hosts
+    #fetch all vms
+
+    logger.debug 'fetching all vms'
+    vms = self.vms
+    hosts.where(:compute_resource_id => nil).each do |host|
+      # find host based on mac
+      logger.debug "searching vms that match #{host}" 
+      vm = vms.detect {|vm| vm.mac == host.mac if vm.respond_to?(:mac)}
+      if vm.present?
+        logger.debug "found match Host:#{host}, VM: #{vm}" 
+        host.compute_resource_id = self.id
+        host.uuid                = vm.identity
+        host.save(:validate => false) # don't want to trigger callbacks
+      end
+    end
+    true
+  end
+

it currently assume there is a mac address (so both facts already exists on foreman and fog knows how to respond to mac).

to use within the console:

ComputeResource.all.each {|cr| cr.import Host }

Jason, would you mind sending this as a PR?

I would assume we need both levels (on the CR level as a whole, and per VM).

thanks!

https://github.com/theforeman/foreman/pull/803

I change the patch a bit and made it so you can do all at once at the CR level or individual at the CR_VM level, as you suggested.

I can 'update hosts set uuid=NULL where id=*; update hosts set compute_resource_id=NULL;' in mysql and see all my hosts pretty much looking like bare metal, without a vm page, and without console/power management capabilities, etc. I can then either one by one or all at once reassign the CRID/VMUUID back and get all that stuff back.