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, app library Integrations
Docs
Stories
News Ask around Schedule a demo Share your story COMPANY The handbook What people are saying
Pricing 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

time

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

time

Track current date and time in UTC.

Column Type Description
datetime text Current date and time (ISO format) in UTC
day integer Current day in UTC
hour integer Current hour in UTC
iso_8601 text Current time (ISO format) in UTC
local_timezone text Current local timezone in of the system
minutes integer Current minutes in UTC
month integer Current month in UTC
seconds integer Current seconds in UTC
timestamp text Current timestamp (log format) in UTC
timezone text Timezone for reported time (hardcoded to UTC)
unix_time integer Current UNIX time in UTC
weekday text Current weekday in UTC
win_timestamp bigint Timestamp value in 100 nanosecond units
Only available on Windows
year integer Current year in UTC

Example

View the timezone a system is configured in. 

SELECT local_timezone FROM time;
Edit page

Questions?

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