I'm trying out fleet and wonder how others have so...
# fleet
k
I'm trying out fleet and wonder how others have solved the problem I'm having, I have a default installation of fleetdm, In the host tab I see my test servers, I know I can add certain columns. My issue then, currently fleetdm is not our single source of truth regards to id of our servers, we have an ID for each server already and would like to utilize this in fleet aswell, This ID is not based on the servers hostname or fqdn, it behaves more like an UUID. Is there a way for me to use for example
Copy code
{
  "options": {
    "host_identifier": "specified",
    "specified_identifier": "my-external-ID"
  }
}
and having fleet pick up this value and allow me to add a column in the hosts tab which I then can filter on etc? or if someone else have solved my problem another way?
what I'm after is beeing able to show the value of
Copy code
SELECT value FROM osquery_flags WHERE name="specified_identifier";
on each host
for example, in the hosts tab, if I filter by a label which filter with
Copy code
SELECT value AS specified_identifier FROM osquery_flags WHERE name = 'specified_identifier' AND specified_identifier != '';
then it would be great if the resulting hosts list actually showed the value in a new column in that list
could be a column named "label output" or similar
g
Hey @Kiranos, as you're already using the specified_identifier in a flag file and if I'm understanding you correctly, you're probably looking for a combination of https://github.com/fleetdm/fleet/issues/40187 (which we just shipped in 4.84), and this part (https://github.com/fleetdm/fleet/issues/31025) which I don't believe has been done yet. The first part would allow you to surface that result from osquery_flags in the reports page on the host. And then the second one for surfacing that as a column on the hosts page.
k
nice thanks will follow the second issue 👍
👍 1