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.
Device management + MDM Orchestration + monitoring Software management + CVEs, usage, app library Integrations
Get started Guides Vitals Queries Policies Software Data tables API SUPPORT Chat Contribute Release notes "Why is Fleet on my computer?" Get your license
Stories
What people are saying News Ask around Take a tour Meetups COMPANY Origins   (Fleet & osquery) The handbook Logos/artwork Why open source?
Pricing Try it yourself
Get applications that were opened within the last 24 hours

Get applications that were opened within the last 24 hours

Returns applications that were opened within the last 24 hours starting with the last opened application.

To learn more about queries, check this guide

SELECT * FROM apps WHERE last_opened_time > (( SELECT unix_time FROM time ) - 86400 ) ORDER BY last_opened_time DESC;
An icon indicating that this section has important information

PowerShell commands are currently work in progress, contributions welcome.

Platform

macOS Windows Linux ChromeOS
Suggest an editEdit