Built-in Linux labels too strict to match all applicable distros

[spalmesano0]

Fleet versions

• Discovered: 4.86.0
• Reproduced: 4.86.0

Web browser and operating system: N/A

---

💥  Actual behavior

Pop!_OS (and possibly other distros) devices have a platform_like of ubuntu debian. This technically should go under the label Ubuntu Linux and Debian-based Linux hosts, but since the queries for the labels are exact (=) rather than includes (LIKE with wildcards), they don't match.

Some queries also use platform or name, when platform_like may be better to use (at least as a fallback).

Here are the current built-in labels and queries:

      "name": "Ubuntu Linux",
      "query": "select 1 from os_version where platform = 'ubuntu';",

      "name": "CentOS Linux",
      "query": "select 1 from os_version where platform = 'centos' or name like '%centos%'",

     "name": "Red Hat Linux",
      "query": "SELECT 1 FROM os_version WHERE name LIKE '%red hat%'",
      
      "name": "Fedora Linux",
      "query": "select 1 from os_version where name = 'Fedora Linux';",

      "name": "Debian-based Linux hosts",
      "query": "SELECT 1 FROM os_version WHERE platform_like = 'debian';",

      "name": "RPM-based Linux hosts",
      "query": "SELECT 1 FROM os_version WHERE platform_like = 'rhel';",

🛠️ Expected behavior

TODO

🧑‍💻  Steps to reproduce

These steps:

• Have been confirmed to consistently lead to reproduction in multiple Fleet instances.
• Describe the workflow that led to the error, but have not yet been reproduced in multiple Fleet instances.

1. Enroll a Linux computer that is supported, but isn't a mainline distro (such as Debian, Ubuntu, Fedora, etc.). Pop!_OS is one known distro that exhibits this behavior.
2. Check the labels that should be applicable for the distro.

🕯️ More info (optional)

N/A