Skip to content

Getting Started with CQL

Master the CrowdStrike Query Language

▶️ Getting Started with CQL
Learn CQL structure, search basics, functions, and field selection fundamentals

Query Language Syntax

Learn CQL structure and fundamentals to build powerful queries.

Search Basics

Run your first queries and discover how to search your data.

Query Functions

Built-in functions for data analysis, transformation, and aggregation.

Field Selection

Extract and filter specific fields from your event data.

🧠 Core Query Concepts
Filters, operators, regex patterns, and writing effective queries

Query Filters

Filter and refine results to find exactly what you need in your data.

Asking From Events

Event-based search techniques to query structured and unstructured data.

Operators

Comparison operators, logical operators, and mathematical operations.

Regular Expression Syntax

Pattern matching with regex for advanced text search and extraction.

Write Queries

Practical guide to writing effective queries and managing query structure.

Advanced Capabilities
Parsing, joins, sequences, aggregations, correlations, and complete function library

Parse Data

Extract structured data from unstructured logs.

Query Joins & Lookups

Combine data from multiple sources.

Sequence Query Functions

Analyze event sequences and patterns.

Aggregate Query Functions

Summarize and group data with aggregations.

Geomaps

Visualize geographical data on interactive maps.

Case Statements

Conditional logic for query results.

Correlate

Pattern matching and event correlation based on proximity and sequences.

Functions Library

Complete reference of CQL functions.

📈 Visualization & Automation
Widgets, dashboards, scheduled queries, and automated actions

Widgets

Visual display of query results with charts, tables, and graphs.

Dashboards

Combined views of multiple widgets for comprehensive monitoring.

Automation

Scheduled queries, alerts, and automated actions.

💡 Best Practice & Troubleshooting
Query optimization, performance tuning, and debugging techniques

Statement Order for Optimal Speed

Learn how to structure queries for best performance. Understand filter placement, function ordering, and optimization techniques to reduce query execution time and improve efficiency.

Troubleshooting Queries

Debug and resolve common query issues. Learn techniques for identifying performance bottlenecks, fixing syntax errors, understanding error messages, and optimizing slow queries.

👥 Top Queries by Role
Curated query lists tailored to your role with complete examples and explanations

Security Operations (SecOps)

Essential queries for security analysts investigating threats, detecting anomalies, and monitoring security events. Includes authentication analysis, threat hunting, and incident response queries.

IT Operations (ITOps)

Essential queries for infrastructure monitoring, system administration, and operational tasks. Includes resource usage, service health checks, and capacity monitoring queries.

DevOps Engineers - Platform

Essential queries for infrastructure monitoring, data ingestion tracking, and event processing. Includes parser alerts, ingest queue monitoring, and platform health queries.

DevOps Engineers - Application

Essential queries for application monitoring, performance analysis, and troubleshooting. Includes error tracking, latency analysis, and deployment monitoring queries.

Site Reliability Engineers (SRE) - Application

Essential queries for application performance monitoring, trend detection, and reliability analysis. Includes response time percentiles, sliding window analysis, and pattern detection queries.

Site Reliability Engineers (SRE) - Infrastructure

Essential queries for infrastructure reliability, system health monitoring, and capacity planning. Includes resource optimization, scaling decisions, and infrastructure incident management queries.

Data Analysts

Essential queries for infrastructure monitoring, system administration, and operational tasks. Includes resource usage, service health checks, and capacity monitoring queries.

🌐 External Learning Resources
Explore additional resources from the CrowdStrike community and helpful tools for working with CQL

External Resources

Explore additional resources from the CrowdStrike community and helpful tools for working with CQL


🔔 New Pages
🔔 Recently Updated Pages