Hunt Lab Overview
Hunt Lab is the advanced query interface of SenseOn. Security teams use it to analyse raw telemetry with flexible SQL-based queries. It supports deep investigations, proactive threat hunts, IT hygiene checks, and compliance reports. All of these are in the SenseOn platform.
When you respond to an incident or do routine threat hunts, Hunt Lab gives you direct access to the necessary data.
What You Can Do with Hunt Lab
- Investigate threats and anomalies with custom queries
- Hunt for indicators of compromise (IOCs) and new patterns
- Audit endpoint configurations and software versions
- Do checks of compliance with internal policies and external frameworks
Key Features
1. SQL Query Interface
Use SQL to query the raw telemetry data that SenseOn collects: - Write custom queries in the built-in editor (it uses Monaco Editor, the same editor that VS Code uses) - Refer to the schema guide for tables and columns - Filter by host, timestamp, event type, and more - The editor supports syntax highlighting, bracket matching, and keyboard shortcuts throughout
2. Query Execution Modes
Hunt Lab supports three execution modes. The mode to use depends on your data source and on the performance that you want:
| Mode | When to use |
|---|---|
| Standard query | General-purpose queries against the SenseOn telemetry store (ClickHouse). The platform returns the results asynchronously. It puts the query in a queue and returns the results when the query is complete. |
| Synchronous query | Use this mode when you must have results immediately and you expect your query to return quickly. The request blocks until the result is ready. Suitable for small, targeted lookups. |
| MySQL query | Use this mode to query data sources that use MySQL, not ClickHouse. This mode is available for specific data sets. To find which tables use this mode, refer to the schema guide. |
Query queue: When the platform has a heavy load, it puts standard queries in a queue. The query status bar shows the queue position and the estimated wait time.
3. CHSQL Query Language
Hunt Lab uses CHSQL. CHSQL is a SQL dialect that is based on ClickHouse SQL, with extensions that are specific to SenseOn. Key points:
- CHSQL queries are read-only. CHSQL does not let you do INSERT, UPDATE, or DELETE operations.
- The CHSQL parser does a check of your query before you submit it. It highlights syntax errors inline in the editor.
- Date and time functions use ClickHouse conventions. For examples, refer to the Hunt Lab Training series.
- For timestamp comparisons, use
toDateTime()andtoDate(), not string literals.
4. Pre-Built Query Library
Use templates to start quickly. There are templates for: - Investigations: Pivot from known suspicious behaviour - Threat Hunting: Scan for common TTPs or anomalies - IT Hygiene: Find outdated software, patches that are not installed, or protocol misuse - GRC: Do a check of control coverage and monitor regulatory adherence
5. Hunter: AI query assistant
The AI chat of Hunt Lab uses Hunter. Hunter is one of the specialist agents that Horus, the AI orchestrator of SenseOn, coordinates. Hunter hunts across your telemetry and helps you build queries. Thus, you can go from a question to results, and you do not have to memorise the schema.
Hunter can:
- Write CHSQL from a plain-language request: if you describe what you want to find, Hunter drafts the query.
- Debug and explain queries: if a query does not return what you expect, paste the query. Hunter explains the issue or rewrites the query.
- Suggest tables and columns: Hunter shows you the correct telemetry tables for your investigation.
- Interpret results: Hunter summarises what a result set tells you. It also suggests follow-up pivots.
How to access: open Hunt Lab. Start a conversation in the in-product chat. Hunter knows the query that you work on. Thus, you can ask follow-up questions in context.
Example prompts:
- "Show me PowerShell processes that spawned a network connection in the last 24 hours."
- "Why is this query returning no rows?"
- "Which table has DNS request telemetry?"
Hunter is not the human support chat. For help from the SenseOn SOC team, use the support chat that Support describes. The support chat connects you to a person, not to the AI assistant.
6. Structured Output
Hunt Lab shows query results in a table that is easy to read: - View the results directly in the platform - Export the results to CSV to share, archive, or report them
7. Turn a query into a detection
When a query returns what you expect, select Create detection in the Hunt Lab toolbar. This changes the query into a scheduled detection that raises observations on its own. You can author detections only in Hunt Lab. Thus, each custom detection starts with a query that you ran in Hunt Lab. For the full workflow, refer to Custom Detections.
Note: Create detection shows only if SenseOn enabled custom detections for your organisation. It stays disabled until the current query runs successfully.