Surface queries' supported platforms in Fleet

[noahtalerman]

It'd be very useful if the Queries dashboard had a column listing the Platform Name (Mac, Linux, MSFT) for each query and the capability to filter queries by the Platform name, just like the queries section on the website.

Goal

As a Fleet user who imports Fleet's Standard query library, I'd like to see the supported platform names next to each query so that I know which devices I can successfully run each query against.

How?

• Add a platform property to queries in Fleet and surface this information in the UI
• Unanswered question: For new queries (those that are not yet part of Fleet's Standard query library), how should platform be determined?
  • Proposed solution 1: Ask user to define platform when saving a query
  • Proposed solution 2: Fleet automatically defines platform after running the query against several hosts and determining which platforms returned results
  • Proposed solution 3: The SQL editor automatically "sniffs" the supported platforms based on the osquery tables present

[noahtalerman]

The ability to see a query's compatible platforms is included in the latest release of Fleet (4.9.0).