菜单
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.
用 Codex 或 Claude 帮你安装 复制这段 Prompt，粘贴到 Codex、Claude 或其他助手里，让它检查 Skill 页面并帮你完成安装。
This creates the parameterized version of the ASIM schema parser. You should already have the parameter-less version of the parser to help facilitate the parameter parser creation.
This starts the process of creating a new ASIM schema parser by generating the initial version of the parser based on the requirements gathered. Use this skill when you have gathered all necessary information for the new ASIM parser and are ready to create the initial version of the parser.
Orchestrates the creation and validation of a new ASIM schema parser. Use this skill when asked to create a new ASIM parser.
Packages the created and validated ASIM schema parser into a GitHub PR for the Azure-Sentinel repository. Use this skill when asked to package a parser into a GitHub PR.
Gets the ASIM parser of interest and deploys it to the customer's LA workspace.
Prompts the user for inputs to create a new ASIM schema parser. Use this skill when you need to gather information from the user to create a new ASIM parser.
基于 SOC 职业分类
| name | log-analytics-workspace-queryer |
| description | 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. |
This skill requires two inputs. This information should come from another skill and you do not need to ask the user for it.
Before querying, verify the user is authenticated by running az account show. If this fails, ask the user to run az login before continuing.
Use the following PowerShell script to execute the KQL query against the workspace. Replace <kql query> and <workspaceId> with the actual values.
## 1. Declare the query
$query = <kql query that needs to be run against the Log Analytics workspace>
## 2. Write payload to file (avoids all shell-escaping issues)
$payload = @{query = $query} | ConvertTo-Json -Depth 5 -Compress
[System.IO.File]::WriteAllText("$env:TEMP\la_query.json", $payload, [System.Text.Encoding]::UTF8)
## 3. Get access token
$token = (az account get-access-token --resource https://api.loganalytics.io --query accessToken -o tsv)
if (-not $token) {
Write-Error "Failed to get access token. Ensure you are logged in with 'az login'."
return
}
## 4. POST via Invoke-WebRequest
$resp = Invoke-WebRequest -Method Post `
-Uri "https://api.loganalytics.io/v1/workspaces/<workspaceId>/query" `
-Headers @{Authorization="Bearer $token"; "Content-Type"="application/json"} `
-Body ([System.IO.File]::ReadAllBytes("$env:TEMP\la_query.json")) `
-SkipHttpErrorCheck
## 5. Parse and display results
if ($resp.StatusCode -eq 200) {
$tables = ($resp.Content | ConvertFrom-Json).tables
$columns = $tables[0].columns
$rows = $tables[0].rows
if ($rows.Count -gt 100) {
Write-Host "Showing first 100 of $($rows.Count) rows."
$rows = $rows | Select-Object -First 100
}
$rows | ForEach-Object {
$row = $_
$obj = [ordered]@{}
for ($i = 0; $i -lt $columns.Count; $i++) {
$obj[$columns[$i].name] = $row[$i]
}
[PSCustomObject]$obj
} | Format-Table -AutoSize
} else {
($resp.Content | ConvertFrom-Json).error.innererror | ConvertTo-Json -Depth 4
}
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).