Ingest pending MDM hosts

[lukeheath]

Goal

As a user, in the Fleet UI, I want to be able to see macOS hosts that are waiting to be automatically enrolled a macOS host to Fleet so that I can change this host's team before the device user unboxes the host.

Related

• Parent epic: List hosts that are pending automatic enrollment #7958
• Blocking: Include MDM pending hosts in hosts list and MDM card #8878 8878
• Blocking: Add new mdm_enrollment_status=pending filter to GET /hosts and GET /labels/:id/hosts endpoints #8879

Requirements

• Ingest new pending MDM hosts from Apple Business Manager API. Likely Get a list of devices or Sync the list of devices.
• We'll likely want to do this check hourly.
• Store pending hosts in the new hosts_pending table.
• Create a related record in hosts table with zero values for any non-nullable columns we don't have data for.
• Populate any related host tables possible (host_mdm, host_operating_system, etc.)
• When the host is unboxed, it will automatically enroll in Fleet. When that happens, we need to remove it from hosts_pending and update the hosts record with the full data set.

Things to consider while working on this:

• Removing the host from hosts_pending at enroll time will make the enrollment operation a bit more complex, so we should bear that in mind.
  • Luke: Note this is not a hard requirement. I added it as a house keeping item, but if updating the record or handling it differently is easier to implement please consider other approaches.
• Check the UI referenced in the parent epic to see where we might want to add indexes to, as this will be yet another column we'll want to filter/order by.

[lukeheath]

@chiiph Here is the issue of ingesting pending hosts from Apple Business Manager. I'm assigning to you to move forward on the Platform roadmap. Feel free to edit as needed, and let me know if you need any other details.