Skip to main content

Osquery: The Basics

Let's cover the basics of Osquery.

Task 1: Introduction

Task 2: Connect with the Lab

Task 3: Osquery: Interactive Mode

Task 4: Schema Documentation

Task 5: Creating SQL Queries

Task 6: Challenge and Conclusion

Back to all walkthroughs
Room Icon

Osquery: The Basics

Max room.

Let's cover the basics of Osquery.

easy

60 min

34,384

User profile photo.
User profile photo.

To access material, start machines and answer questions login.

Osquery is an open-source monitoring agent created by Facebook in 2014. It converts the operating system into a relational database and allows us to ask questions from the tables using queries, like returning the list of running processes, a user account created on the host, and the process of communicating with certain suspicious domains. It is widely used by Security Analysts, Incident Responders, Threat Hunters, etc. Osquery can be installed on multiple platforms: Windows, , macOS, and FreeBSD.

Learning Objectives

  • Learn what is Osquery, and what problem it solves
  • Discover OSquery for , and security teams
  • Explore Osquery usage in interactive () mode 
  • Dive deeper into table joins and complex queries

Note: It is highly beneficial if you're already familiar with SQL queries. If not, check out this SQL Tutorial.

Answer the questions below

Move on to the next task!