x-pack/osquerybeat/ext/osquery-extension/README.md
This osquery extension provides additional custom tables that enhance osquery's capabilities with Elastic-specific functionality. The extension is designed to work seamlessly with Osquerybeat and provides deep system insights across Linux, macOS, and Windows platforms.
The extension adds several custom tables to osquery that provide:
| Name | Type | Linux | macOS | Windows |
|---|---|---|---|---|
elastic_amcache_application | table | ❌ | ❌ | ✅ |
elastic_amcache_application_file | table | ❌ | ❌ | ✅ |
elastic_amcache_application_shortcut | table | ❌ | ❌ | ✅ |
elastic_amcache_applications_view | view | ❌ | ❌ | ✅ |
elastic_amcache_device_pnp | table | ❌ | ❌ | ✅ |
elastic_amcache_driver_binary | table | ❌ | ❌ | ✅ |
elastic_amcache_driver_package | table | ❌ | ❌ | ✅ |
elastic_browser_history | table | ✅ | ✅ | ✅ |
elastic_file_analysis | table | ❌ | ✅ | ❌ |
elastic_host_groups | table | ✅ | ✅ | ❌ |
elastic_host_processes | table | ✅ | ❌ | ❌ |
elastic_host_users | table | ✅ | ✅ | ❌ |
elastic_jumplists | table | ❌ | ❌ | ✅ |
host_groups | view | ✅ | ✅ | ❌ |
host_processes | view | ✅ | ❌ | ❌ |
host_users | view | ✅ | ✅ | ❌ |
From the osquerybeat directory:
# Build for current platform
mage buildext
# The extension binary will be created at:
# Linux: ext/osquery-extension/build/linux/osquery-extension
# macOS: ext/osquery-extension/build/darwin/osquery-extension
# Windows: ext/osquery-extension/build/windows/osquery-extension.ext
The extension is automatically loaded by Osquerybeat. To use it manually with osquery:
# Start osquery with the extension
osqueryi --extension /path/to/osquery-extension [--allow-unsafe]
# Verify tables are loaded
osqueryi> .tables
=> elastic_browser_history
# Query the tables
osqueryi> SELECT * FROM elastic_browser_history LIMIT 10;