Error executing distributed query: fleet_detail_query_software_windows: no such table: atom_packages

[gstorme]

Fleet version: 4.14.0

Operating system: Windows Server 2019

🧑‍💻  Expected behavior

Software inventory is enabled, I'd expect a software inventory for all hosts

💥  Actual behavior

Some hosts show "No installed software detected on this host."

More info

The logfile contains

distributed.cpp:144] Error executing distributed query: fleet_detail_query_software_windows: no such table: atom_packages

Running osquery (5.2.2) shell shows me this table does exist:

osquery> .tables
  => appcompat_shims
  => arp_cache
  => atom_packages

Because this table causes issues on domain controllers when the software inventory is enabled, (https://github.com/fleetdm/fleet/issues/4261) I have disabled this table in the global agent options: disable_tables: 'chrome_extensions,firefox_addons,atom_packages'

This was a workaround to have a software inventory, but some hosts don't show any software.