OpenParable
Skip to content
← Back to skills

Log Analytics Workspace Queryer

DevOps & Security
log-analytics-workspace-queryer

Log Analytics Workspace Queryer is an Agent Skill for devops & security published in the Azure/Azure-Sentinel repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Uses REST API to query Log Analytics workspaces. Use this skill when you need to query a Log Analytics workspace, for example, to check if the table exists in the workspace, or to validate an ASIM parser.

View on GitHub ↗
QUICK START

How to use this skill

Bring this guide into your coding agent with a prompt tailored to the tool you use.

  1. Open your project in Codex.
  2. Copy and paste the prompt below.
  3. Review files and risks before approving any action.
Prompt to paste
Inspect the Agent Skill at https://github.com/Azure/Azure-Sentinel/blob/HEAD/.github/skills/log-analytics-workspace-queryer/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/log-analytics-workspace-queryer, but wait for my approval before writing files or running scripts.

Copying this prompt does not install or run the skill. Review third-party files before use.

Query Log Analytics workspace using REST API

Inputs

This skill requires two inputs. This information should come from another skill and you do not need to ask the user for it.

  • KQL query — the query to run against the Log Analytics workspace.
  • Workspace ID — the GUID of the Log Analytics workspace.

Step 1: Run the query

Execute the PowerShell script at scripts/queryLogAnalytics.ps1 (relative to this skill's directory) by passing the workspace ID and KQL query as parameters:

.\scripts\queryLogAnalytics.ps1 -WorkspaceId "<workspaceId>" -Query "<KQL query>"

Step 2: Return results

Return the full query output to the calling skill. The calling skill is responsible for interpreting and filtering the results (e.g., filtering for Error or Warning patterns during ASIM validation).