Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

Hey! This might be a stupid question but I've tried all I could think of so you're my last hope. My Windows workstation isn’t showing as online in FleetDM - well technically it does since it registers and it shows online for a couple of seconds and then it's gone.

Should anyone have the same issue, running _fleetctl debug connection_ revealed that even though I have a certificate issued by a well known authority, it was deemed unknown. Adding _--insecure_ when generating fleetd solved it temporarily and then I believe I need to somehow trust the issuing CA.

Hey <@U09SKME2QBB>, I think you’re on the right track if the `--insecure` flag gets things working. If you haven’t already come across it, take a look at this article that explains how certificates are used in fleetd and how you can go about trusting a non-default CA: <https://fleetdm.com/guides/certificates-in-fleetd#basic-article|https://fleetdm.com/guides/certificates-in-fleetd#basic-article>