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

osquery

what can I do if am locked outside of fleet web ui, and I don't know the password and my email is not configured

Hey <@U03F31J68TH>! Is your account the only one set up in Fleet?

Any chance you've recently authenticated in `fleetctl`?

I’m reaching out to the team now to see if there’s a workaround that isn’t occurring to me. 

If you’ve got database access, you can change the password by running:


```
update users set salt = 'qBO+OrK6AikTOVxDWZGurOQF5DuK2HaW', password = '$2a$12$JdnjJxajBwszEimsqhKgvO9nC3WUUK5rD4CMtdDUw0bjg/kpF65gC' where email = '';```


Using your actual email address in the `where` clause. This will change the password to wyu6rwf@vqd*ned.UKV

Then log in and change the password to something else