Fleet logo
Menu An icon indicating that interacting with this button will open the navigation menu.
Fleet logo An 'X' icon indicating that this can be interacted with to close the navigation menu.
Multi platform
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, software catalog Integrations
Docs Pricing
More
News Case studies Ask around Meetups Share your story
The handbook Get your license Schedule a demo
Try it yourself

Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

macOS Apple

Linux Linux

Windows Windows

Chrome ChromeOS

logged_in_users

click to open the table of contents
macOS logo Windows logo Linux logo

logged​_in​_users

Users with an active shell on the system.

Column Type Description
host text Remote hostname
pid integer Process (or thread) ID
registry_hive text HKEY_USERS registry hive
Only available on Windows
sid text The user's unique security identifier
Only available on Windows
time bigint Time entry was made
tty text Device name
type text Login type
user text User login name

Example

See the user currently logged in on the console of the computer.

SELECT user, type, tty from logged_in_users WHERE tty='console';
Edit page

Questions?

Ask us anything
{{table.title}} evented table