Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.
google_chrome_profiles
Profiles configured in Google Chrome.
Column | Type | Description |
---|---|---|
text | Email address linked to the Google account this profile uses, if any. | |
ephemeral | boolean | Boolean indicating if the profile is ephemeral or not. |
name | text | Name of the Chrome profile. |
username | text | Operating system level username of the account where this profile is located. |
List the Google Chrome accounts logged in to with fleetdm.com
email addresses, joined to the
users table, to see the description of the operating system
account that owns it.
SELECT gp.email, gp.username, u.description FROM google_chrome_profiles gp JOIN users u ON gp.username=u.username WHERE gp.email LIKE '%fleetdm.com';
This table is from the Mac Admins osquery extension.