deploying-osquery-for-endpoint-monitoring

name	deploying-osquery-for-endpoint-monitoring
description	Deploys and configures osquery for real-time endpoint monitoring using SQL-based queries to inspect running processes, open ports, installed software, and system configuration. Use when building visibility into endpoint state, threat hunting across fleet, or implementing compliance monitoring. Activates for requests involving osquery deployment, endpoint visibility, fleet management, or SQL-based endpoint querying.
domain	cybersecurity
tags	["endpoint","osquery","endpoint-monitoring","threat-hunting","fleet-management"]
subdomain	endpoint-security
mitre_attack	["T1547","T1049","T1620","T1053.003","T1548.001","T1552"]
version	1.0.0
author	oyi77
license	Apache-2.0
nist_csf	["PR.PS-01","PR.PS-02","DE.CM-01","PR.IR-01"]

Deploying Osquery For Endpoint Monitoring

Overview

Cybersecurity skill for deploying osquery for endpoint monitoring. Follows industry best practices and security standards.

When to Use

Trigger phrases:

• "deploying osquery for endpoint monitoring"
• "Deploying osquery across Windows, macOS, and Linux endpoints for fleet-wide visi"
• "Building threat hunting queries using osquery's SQL interface"
• "Monitoring endpoint compliance (installed software, open ports, running services"

Use this skill when:

• Deploying osquery across Windows, macOS, and Linux endpoints for fleet-wide visibility
• Building threat hunting queries using osquery's SQL interface
• Monitoring endpoint compliance (installed software, open ports, running services)
• Integrating osquery data with SIEM or Kolide/Fleet for centralized management

Do not use for real-time alerting (osquery is periodic/on-demand; use EDR for real-time).

When NOT to Use

• When you lack proper authorization for testing
• For production systems without change management
• When the task requires legal or compliance expertise beyond technical scope

Prerequisites

• Osquery package for target OS (https://osquery.io/downloads)
• Fleet management server (Kolide Fleet or FleetDM) for enterprise deployment
• TLS certificates for secure agent-to-server communication
• Log aggregation pipeline (Filebeat, Fluentd) for osquery result logs

Workflow

# Example: IOC detection
import re

IOC_PATTERNS = {
    "ip": r"\b(?:\d{1,3}\.){3}\d{1,3}\b",
    "domain": r"\b[a-z0-9-]+\.[a-z]{2,}\b",
    "hash_md5": r"\b[a-f0-9]{32}\b",
    "hash_sha256": r"\b[a-f0-9]{64}\b",
}

def extract_iocs(text: str) -> dict:
    return {k: re.findall(v, text) for k, v  IOC_PATTERNS.items()}