powerquery

Execute PowerQuery commands against SentinelOne's Singularity Data Lake.

59|30|Updated Aug 19, 2025
One-click install
npx skills add https://github.com/Sentinel-One/ai-siem --skill powerquery
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: powerquery
Source: https://github.com/Sentinel-One/ai-siem/tree/main/plugins/s1-secops-skills/skills/powerquery
Command: npx skills add https://github.com/Sentinel-One/ai-siem --skill powerquery

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill provides a comprehensive set of PowerQuery commands for querying and analyzing data from SentinelOne's Singularity Data Lake, enabling users to perform complex threat hunting, investigations, and detection rule development.

Core Features & Use Cases

  • PowerQuery Language Support: Offers a full range of PowerQuery commands for data filtering, transformation, and analysis.
  • Threat Hunting: Facilitates the creation of PowerQueries for deep visibility, event search, and threat hunting tasks.
  • Investigations: Enables the development of PowerQueries for detailed analysis and reporting.
  • Detection Rule Development: Provides the necessary PowerQuery commands to create effective detection rules.
  • Use Case: For example, a user can create a PowerQuery to search for all events where a PowerShell script has executed and then identify the destination IP addresses.

Quick Start

To create a PowerQuery that identifies PowerShell scripts executing with suspicious arguments, use the following command: event.type = 'Process Creation' src.process.name = 'powershell.exe' src.process.cmdline matches '.*\s(.*?\.exe).*' | group count() by dst.ip.address

Frequently Asked Questions about powerquery

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query SentinelOne's Singularity Data Lake for threat hunting?

You can query SentinelOne's Singularity Data Lake by executing PowerQuery commands to perform advanced data filtering, transformation, and threat hunting. This allows deep visibility into events for identifying malicious activity like suspicious PowerShell executions.

Can I use PowerQuery to develop detection rules in SentinelOne?

Yes, PowerQuery provides the necessary commands to create effective detection rules within SentinelOne. You can develop queries to match specific threat patterns and process creation events, enabling automated detection and response.

How do I find the destination IP addresses of PowerShell executions using PowerQuery?

To find destination IP addresses from PowerShell executions, use a PowerQuery filtering for event.type = 'Process Creation' and src.process.name = 'powershell.exe'. You can then group the results by dst.ip.address to aggregate the network connections.

Do I need to know the SentinelOne data schema to run PowerQuery commands?

Yes, running PowerQuery commands requires knowledge of both the PowerQuery language and SentinelOne's data schema. Understanding fields like src.process.cmdline and dst.ip.address is essential for accurate event search and threat hunting.

What is the best way to analyze process creation events in SentinelOne?

The best way to analyze process creation events is using PowerQuery to filter by event.type = 'Process Creation'. This allows you to investigate process command lines, group data by specific fields, and identify suspicious script arguments.

Are there limitations when using PowerQuery for security investigations?

PowerQuery is specifically designed for querying the Singularity Data Lake, meaning its use is limited to the SentinelOne ecosystem. Effective investigations depend on your knowledge of the PowerQuery syntax and the available data schema.