avd-alert-kql-validation

Create and review KQL for the FederalAVD AVD Alerts add-on. Use when adding or changing scheduled query alerts, comparing alert logic with Microsoft AVD Insights workbooks, investigating query failures, or documenting intentional workbook deviations.

Jump to install

Repository: Azure/FederalAVD
Last source activity: August 18, 2026 at 18:24
Detected SKILL.md language: English
Stars: 17
Forks: 19

Install options

The review-first prompt is selected by default. You can switch to a direct command or download a local copy.

Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.

A direct command skips the review prompt. Inspect the source before running it.

npx skills add https://github.com/Azure/FederalAVD --skill avd-alert-kql-validation

The command stays on one line. Scroll horizontally to inspect it before copying.

Prefer a local copy? Download the files currently available to SkillsMP.

Review the source files

Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.

File Explorer

3 files

SKILL.md

Source instructions · Read-only preview

Back to search Back to installation

federalavd-bicep-maintenance

Modify and validate FederalAVD Bicep templates, generated ARM JSON, parameters, and uiFormDefinition files. Use when changing deployment resources, adding parameters or outputs, synchronizing Bicep with JSON, publishing Template Specs, or debugging portal form behavior.

2026-08-20

federalavd-air-gapped-readiness

Review FederalAVD deployments and image artifacts for Azure Government Secret or Top Secret air-gapped readiness. Use when auditing downloads.json, finding public network dependencies, preparing transfer inventories, validating pre-staged files, or checking that image builds and host pools avoid internet runtime downloads.

2026-08-18

federalavd-artifact-authoring

Create, update, and validate FederalAVD image artifacts and software download definitions. Use when adding customer-example artifacts, editing downloads.json, packaging installers, documenting download sources, or preparing artifacts for connected or air-gapped image builds.

2026-08-18

View all from this repository

AVD Alert KQL Validation

Use this workflow for log-based alerts under deployments/add-ons/avdAlerts/.

Procedure

Read deployments/add-ons/avdAlerts/README.md, especially Query Design and Validation, and locate the corresponding operator response in ALERT-RESPONSE.md.

Identify the authoritative AVD Insights workbook for the condition. Use the official Microsoft workbook sources listed in workbook sources.

Extract and structurally validate the repository queries:

& .github/skills/avd-alert-kql-validation/scripts/Test-AvdAlertQueries.ps1 `
  -ModulePath deployments/add-ons/avdAlerts/modules

To inspect standalone KQL, add -OutputDirectory <temporary-folder>. Do not commit generated extraction output.

Compare table selection, joins, event names or IDs, status filters, casts, deduplication, and aggregation with the workbook query covering the same condition.

Adapt interactive workbook queries for alert semantics: remove render, return rows suitable for the configured aggregation and threshold, and use a bounded time window.

Verify overrideQueryTimeRange is at least windowSize multiplied by numberOfEvaluationPeriods and that persistent-event behavior matches autoMitigate.

Preserve cloud compatibility. Do not introduce workspace-specific functions or preview-only KQL without confirming support in every target cloud.

Document every intentional deviation in the add-on README. The reason must describe alert semantics, noise suppression, cloud compatibility, or source-data behavior.

Build the affected Bicep entry template and update ALERT-RESPONSE.md when operator action, thresholds, or dimensions change.

name	avd-alert-kql-validation
description	Create and review KQL for the FederalAVD AVD Alerts add-on. Use when adding or changing scheduled query alerts, comparing alert logic with Microsoft AVD Insights workbooks, investigating query failures, or documenting intentional workbook deviations.
argument-hint	[alert resource, KQL condition, or module]