Title
#kolide
Dan Achin

Dan Achin

10/15/2020, 9:38 PM
Hello Kolide. I'm wondering if there is a way to forcefully remove clients from Fleet or if they go away automatically at some interval (post MIA)?
zwass

zwass

10/15/2020, 9:39 PM
You can configure
host_expiry
in the "advanced options" in the UI or via fleetctl.
Dan Achin

Dan Achin

10/15/2020, 9:52 PM
k, thanks. lemme check that out.
9:55 PM
ah, yes I see that, thanks. If we wanted to be more granular, can we remove things from the DB or something - basically emulate whatever this setting does but targeted at hosts?
9:57 PM
i just might not want to kill all hosts that haven't checked in for X days, just some, based on specific criteria. although, I supposed if we let some hosts expire that we actually want in there, once they come back up they would just re-register.
zwass

zwass

10/15/2020, 9:58 PM
Yeah, you have that right. They would re-register as long as they have a still-valid enroll secret.
9:59 PM
You can delete hosts from the DB however you like though.
Dan Achin

Dan Achin

10/15/2020, 9:59 PM
not that we want to go in there and do that...but is it as easy as finding the hosts table and removing entries? is the schema documented somewhere?
zwass

zwass

10/15/2020, 10:01 PM
Yeah it should be. The schema is only really documented insofar as it is the sum of the db migrations. You can always use
show create table hosts
to see it though.
Dan Achin

Dan Achin

10/15/2020, 10:27 PM
thanks much