Skip to main content

get-migration-assessment

Use when retrieving existing SQL Server migration assessment data from Azure Resource Graph with the required instance-level and database-level queries.

معلومات المصدر

المستودع
microsoft/microsoft-sql
آخر نشاط في المصدر
٢٣ سبتمبر ٢٠٢٦ في ٢٠:١٩
لغة SKILL.md المكتشفة
الإنجليزية
النجوم
١٥
التفرعات
٣

خيارات التثبيت

يُحدَّد Prompt الذي يراجع المصدر أولًا بشكل افتراضي. يمكنك التبديل إلى أمر مباشر أو تنزيل نسخة محلية.

مراجعة ملفات المصدر

اقرأ SKILL.md وأي ملفات مرافقة يعرضها SkillsMP قبل أن تقرر التثبيت.

مستكشف الملفات
5 ملفات

عرض SKILL.md

SKILL.md
تعليمات المصدر · معاينة للقراءة فقط
name
get-migration-assessment
description
Use when retrieving existing SQL Server migration assessment data from Azure Resource Graph with the required instance-level and database-level queries.
allowed-tools
Bash(az:*, curl:*) PowerShell Grep View
# Get Migration Assessment These claims were checked on 2026-09-15 against the bundled `skill-contract.yml`, Azure Resource Graph query contract, response schema, and assessment output contract. ## When to Use Use for existing Azure SQL Server assessment, readiness, blocker, SKU, and cost data. This skill does not trigger a new assessment. ## Workflow ### Step 1: Resolve Inputs Use [ARM resource identification](references/arm-resource-identification.md) when inputs are missing. Reuse identifiers already in context. Confirm a defaulted subscription by display name and ID. ### Step 2: Query Instance Data Build and execute the instance query from `references/arg-queries.md` when retrieving server-level data. ### Step 3: Query Database Data When retrieving database-level data, build and execute the database query from `references/arg-queries.md` for every returned instance. ### Step 4: Interpret Results Use `references/response-schema.md` when interpreting results. For every `NotReady` target, identify the server or database blocker. If blocker details are unavailable, report a data gap. If assessment data or `assessmentUploadTime` is missing, state that no migration assessment data is available and identify likely causes: it has not been enabled or run, results have not uploaded, the agent is not configured, or permissions are insufficient. ### Step 5: Render Results Use [assessment output](references/assessment-output.md) when rendering the combined readiness and SKU recommendation. - Multiple instances -> show a summary table, then render each instance. For multiple instances, include aggregate readiness, cost, and common blocker insights when the returned data supports them. ## Check it worked - Both query phases completed for every instance. - Pagination completed. - Every `NotReady` result has a cause or data-gap note. - Missing settings or readiness are stated explicitly. - **Cleanup verification:** Clear the in-memory ARM token and confirm no temporary request body or response file remains unless the user asked to retain it. ## Notes - Use ARG as the assessment read transport. - Execute queries through the `curl` adapter in `references/arg-queries.md` whenever requesting ARG data. - Exclude `master`, `model`, `msdb`, and `tempdb`. - Show subscription display name with its ID. - Follow the output template exactly. ## Error Handling - 401/403 -> verify Azure CLI login and read permission on the target scope. - 429 -> honor `Retry-After`; report persistent throttling. - Invalid resource URI -> show the expected Azure SQL Server instance resource-ID format. - Empty result -> show the subscription display name/ID and resource group that were searched. ## References - Open `references/arg-queries.md` before executing instance or database queries. - Open `references/response-schema.md` when interpreting ARG results. - [ARM resource identification](references/arm-resource-identification.md) - [Assessment output](references/assessment-output.md)
عرض على GitHub