Azure Advisor Report

# Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0)

## English

Copyright (c) 2025-2026 yamapan (aktsmm)

This work is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0
International License.

You are free to:

- **Share** — copy and redistribute the material in any medium or format
- **Adapt** — remix, transform, and build upon the material

Under the following terms:

- **Attribution** — You must give appropriate credit, provide a link to the
  license, and indicate if changes were made. You may do so in any reasonable manner,
  but not in any way that suggests the licensor endorses you or your use.

- **NonCommercial** — You may not use the material for commercial purposes.
  *(Please contact the author if you wish to use this material for commercial purposes.)*

- **ShareAlike** — If you remix, transform, or build upon the material, you must
  distribute your contributions under the same license as the original.

No additional restrictions — You may not apply legal terms or technological
measures that legally restrict others from doing anything the license permits.

**AI/ML Training Restriction** — Use of this content for AI/ML training, data
mining, or other analytical purposes is prohibited without explicit permission.

Full license text: https://creativecommons.org/licenses/by-nc-sa/4.0/legalcode

---

## 日本語

Copyright (c) 2025-2026 yamapan (aktsmm)

この作品はクリエイティブ・コモンズ 表示-非営利-継承 4.0 国際ライセンスの下に提供されています。

あなたは以下の条件に従う限り、自由に：

- **共有** — どのようなメディアやフォーマットでも資料を複製・再配布できます
- **翻案** — 資料をリミックス、変形、および加工することができます

以下の条件に従ってください：

- **表示** — あなたは適切なクレジットを表示し、ライセンスへのリンクを提供し、
  変更があったらその旨を示さなければなりません。これらは合理的であればどのような方法で
  行っても構いませんが、許諾者があなたやあなたの利用行為を支持していると示唆するような
  方法は除きます。

- **非営利** — あなたは営利目的でこの資料を利用してはなりません。
  （※商用利用をご希望の場合は、別途ご連絡ください。）

- **継承** — もしあなたがこの資料をリミックス、変形、または加工した場合、
  あなたはあなたの貢献部分を元の作品と同じライセンスの下で配布しなければなりません。

追加的な制約は課せません — あなたは、このライセンスが他の者に許諾することを法的に
制限するような法的条項や技術的手段を適用してはなりません。

**AI/MLトレーニング制限** — 本コンテンツをAI/MLモデルのトレーニング、データマイニング、
その他の解析目的での使用は明示的な許可なく禁止されています。

ライセンス全文: https://creativecommons.org/licenses/by-nc-sa/4.0/legalcode.ja

---

## Special Permission for Microsoft Employees / Microsoft 社員向け特別許諾

### English

Microsoft Corporation employees are granted permission to use, copy, modify, and
distribute this material for any purpose within the scope of their employment
duties at Microsoft, including internal business use and customer-facing
activities, without the NonCommercial restriction of this license.

This special permission applies only to work performed as part of official
Microsoft business activities.

### 日本語

Microsoft Corporation の社員は、Microsoft での業務の範疇において、本資料を社内業務
および顧客対応を含むあらゆる目的で使用、複製、改変、配布することが許諾されます。
この場合、本ライセンスの「非営利」制限は適用されません。

この特別許諾は、Microsoft の公式な業務活動の一環として行われる作業にのみ適用されます。

---

## Disclaimer / 免責事項

### English

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR
A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR
COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN
ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

### 日本語

本ソフトウェアは「現状のまま」で提供され、明示または黙示を問わず、商品性、
特定目的への適合性、および権利非侵害についての保証を含むがこれに限定されない、
いかなる種類の保証も伴いません。作者または著作権者は、契約行為、不法行為、
またはそれ以外であろうと、ソフトウェアに起因または関連し、あるいはソフトウェアの
使用またはその他の扱いによって生じる一切の請求、損害、その他の責任について
責任を負いません。

"""
Azure Advisor Monthly Report - PowerPoint Generator (Template)

Usage:
    py -3 generate_pptx.py --output report.pptx

This script generates a widescreen PowerPoint report with Azure Advisor
recommendations and cost trend analysis.

Customize the DATA section below with actual values from Azure CLI / Cost Management API.
"""
import sys, io, os, argparse
sys.stdout = io.TextIOWrapper(sys.stdout.buffer, encoding='utf-8', errors='replace')

from pptx import Presentation
from pptx.util import Inches, Pt, Cm
from pptx.dml.color import RGBColor
from pptx.enum.text import PP_ALIGN
from pptx.enum.shapes import MSO_SHAPE

# ============================================================
# CONFIG - Customize these
# ============================================================
FONT_ASCII = 'Calibri'
FONT_EAST_ASIAN = 'BIZ UDPGothic'
MIN_CONTENT_FONT_SIZE = 14
SLIDE_W = Inches(13.333)
SLIDE_H = Inches(7.5)

# Layout constants (prevent overlap)
HEADER_H = Inches(1.1)       # Header bar height
CONTENT_TOP = Inches(1.3)    # Content starts below header
MARGIN = Inches(0.5)         # Page margin
FULL_W = Inches(12.3)        # Full-width content
LEFT_W = Inches(7.5)         # Left column width (60%)
RIGHT_X = Inches(8.3)        # Right column X position
RIGHT_W = Inches(4.5)        # Right column width (40%)
GAP = Inches(0.3)            # Vertical gap between blocks

# Colors
DARK_BLUE = RGBColor(0x00, 0x32, 0x6E)
MS_BLUE = RGBColor(0x00, 0x78, 0xD4)
RED = RGBColor(0xE7, 0x4C, 0x3C)
WHITE = RGBColor(0xFF, 0xFF, 0xFF)
LIGHT_GRAY = RGBColor(0xF0, 0xF0, 0xF0)
DARK_GRAY = RGBColor(0x33, 0x33, 0x33)
LIGHT_BLUE = RGBColor(0xD6, 0xEA, 0xF8)
LIGHT_RED = RGBColor(0xFA, 0xDB, 0xD8)
LIGHT_GREEN = RGBColor(0xD5, 0xF5, 0xE3)

# ============================================================
# HELPER FUNCTIONS
# ============================================================

def _set_font(font, size, bold=False, color=DARK_GRAY):
    """Apply consistent font settings."""
    font.size = Pt(max(size, MIN_CONTENT_FONT_SIZE))
    font.bold = bold
    font.color.rgb = color
    font.name = FONT_ASCII
    font._element.attrib['{http://schemas.openxmlformats.org/drawingml/2006/main}altLang'] = 'ja-JP'
    # Set East Asian font via XML for proper fallback
    from pptx.oxml.ns import qn
    rPr = font._element
    ea = rPr.find(qn('a:ea'))
    if ea is None:
        from lxml import etree
        ea = etree.SubElement(rPr, qn('a:ea'))
    ea.set('typeface', FONT_EAST_ASIAN)

def add_bg(sl, l, t, w, h, c):
    """Add colored rectangle background."""
    s = sl.shapes.add_shape(MSO_SHAPE.RECTANGLE, l, t, w, h)
    s.fill.solid(); s.fill.fore_color.rgb = c; s.line.fill.background()

def tb(sl, l, t, w, h, txt, fs=12, b=False, c=DARK_GRAY, a=PP_ALIGN.LEFT):
    """Add text box with proper font settings."""
    bx = sl.shapes.add_textbox(l, t, w, h); tf = bx.text_frame; tf.word_wrap = True
    p = tf.paragraphs[0]; p.text = txt; _set_font(p.font, fs, b, c); p.alignment = a
    return tf

def ap(tf, txt, fs=12, b=False, c=DARK_GRAY):
    """Add paragraph to text frame."""
    p = tf.add_paragraph(); p.text = txt; _set_font(p.font, fs, b, c)
    p.space_before = Pt(2)

def tbl(sl, l, t, w, h, data, hc=MS_BLUE, col_widths=None):
    """Add table with header coloring and optional column width ratios."""
    r, co = len(data), len(data[0])
    ts = sl.shapes.add_table(r, co, l, t, w, h).table
    # Apply column widths if specified (list of relative proportions)
    if col_widths and len(col_widths) == co:
        total = sum(col_widths)
        for j, cw in enumerate(col_widths):
            ts.columns[j].width = int(w * cw / total)
    for i, rd in enumerate(data):
        for j, ct in enumerate(rd):
            cell = ts.cell(i, j); cell.text = str(ct)
            for p in cell.text_frame.paragraphs:
                _set_font(p.font, MIN_CONTENT_FONT_SIZE, bold=(i == 0), color=WHITE if i == 0 else DARK_GRAY)
                if i == 0:
                    p.alignment = PP_ALIGN.CENTER
            if i == 0:
                cell.fill.solid(); cell.fill.fore_color.rgb = hc
            elif i % 2 == 0:
                cell.fill.solid(); cell.fill.fore_color.rgb = LIGHT_GRAY

def hdr(sl, title, sub=None):
    """Slide header bar."""
    add_bg(sl, Inches(0), Inches(0), SLIDE_W, HEADER_H, DARK_BLUE)
    tb(sl, MARGIN, Inches(0.2), Inches(12), Inches(0.6), title, fs=24, b=True, c=WHITE)
    if sub:
        tb(sl, MARGIN, Inches(0.65), Inches(12), Inches(0.4), sub, fs=13,
           c=RGBColor(0xA0, 0xC0, 0xE0))

def ibox(sl, l, t, w, h, title, lines, bg=LIGHT_BLUE, tc=DARK_BLUE):
    """Insight box with background."""
    add_bg(sl, l, t, w, h, bg)
    tf = tb(sl, l + Inches(0.1), t + Inches(0.05), w - Inches(0.2), h - Inches(0.1),
            title, fs=12, b=True, c=tc)
    for ln in lines:
        ap(tf, ln, fs=11, c=DARK_GRAY)

def add_notes(sl, text):
    """Add speaker notes to a slide."""
    notes_slide = sl.notes_slide
    notes_slide.notes_text_frame.text = text


# ============================================================
# DATA - Replace with actual values
# ============================================================

REPORT_TITLE = "Azure 環境 簡易月次レポート"
REPORT_DATE = "2026年3月31日"
CUSTOMER_NAME = ""  # e.g., "お客様名様"

# Subscription info: [(env_label, sub_name, sub_id_short, annual_usage)]
SUBSCRIPTIONS = [
    ("本番系", "従量課金", "xxxxxxxx-...", "$XXX,XXX"),
    ("評価系", "従量課金（評価）", "yyyyyyyy-...", "$XX,XXX"),
]

# Cost trend: monthly totals (JPY)
COST_MONTHS = ["2025/10", "2025/11", "2025/12", "2026/01", "2026/02", "2026/03"]
COST_PROD = ["0", "0", "0", "0", "0", "0"]           # Production monthly
COST_PROD_MOM = ["-", "+0%", "+0%", "+0%", "+0%", "+0%"]  # MoM change
COST_EVAL = ["0", "0", "0", "0", "0", "0"]           # Evaluation monthly

# Service breakdown: [service, m1, m2, m3, m4, m5, m6, trend]
COST_SERVICES_PROD = [
    ["Service A", "0", "0", "0", "0", "0", "0", "横ばい"],
]

# Advisor recommendations: [recommendation, count, impact, resources]
ADVISOR_COST_PROD = [
    ["VM 適正サイズ化", "N台", "$XX,XXX", "vm-name-1, vm-name-2 ほかN台"],
]
ADVISOR_COST_EVAL = [
    ["VM 適正サイズ化", "N台", "$XX,XXX", "vm-name-1 ほかN台"],
]

ADVISOR_SEC_PROD = [
    ["推奨事項", "N", "High", "resource-1, resource-2 ほかN台"],
]
ADVISOR_SEC_EVAL = [
    ["推奨事項", "N", "High", "resource-1 ほかN台"],
]

ADVISOR_REL_PROD = [
    ["推奨事項", "N", "High", "resource-1 ほかN台"],
]
ADVISOR_REL_EVAL = [
    ["推奨事項", "N", "High", "resource-1 ほかN台"],
]

# Portal links (with tenant ID)
PORTAL_LINKS = [
    ("本番系 Advisor", "https://portal.azure.com/#@{tenantId}/blade/..."),
    ("評価系 Advisor", "https://portal.azure.com/#@{tenantId}/blade/..."),
]


# ============================================================
# SLIDE GENERATION
# ============================================================

prs = Presentation()
prs.slide_width = SLIDE_W
prs.slide_height = SLIDE_H

# ----- S1: Title -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
add_bg(sl, Inches(0), Inches(0), SLIDE_W, Inches(4), DARK_BLUE)
title_text = f"{CUSTOMER_NAME} {REPORT_TITLE}" if CUSTOMER_NAME else REPORT_TITLE
tb(sl, Inches(1), Inches(0.8), Inches(11), Inches(1.2), title_text, fs=34, b=True, c=WHITE)
tb(sl, Inches(1), Inches(2.0), Inches(11), Inches(0.6),
   "Azure Advisor 推奨事項 / コスト推移分析", fs=16, c=RGBColor(0xA0, 0xC0, 0xE0))
tb(sl, Inches(1), Inches(4.5), Inches(5), Inches(0.4),
   f"レポート作成日: {REPORT_DATE}", fs=14, c=DARK_GRAY)
tb(sl, Inches(1), Inches(5.0), Inches(6), Inches(0.4),
   "データ取得: Azure Advisor / Cost Management API", fs=11, c=DARK_GRAY)

# Subscription table on title slide
sub_data = [["環境", "サブスクリプション名", "Subscription ID", "年間利用額"]]
for env, name, sid, annual in SUBSCRIPTIONS:
    sub_data.append([env, name, sid, annual])
tbl(sl, Inches(6.5), Inches(4.5), Inches(6.3), Inches(1.5), sub_data,
    col_widths=[1, 3, 3, 2])
add_notes(sl, f"表紙スライド。対象: {len(SUBSCRIPTIONS)} サブスクリプション。データ取得日: {REPORT_DATE}")

# ----- S2: Cost Trend -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
hdr(sl, "コスト推移・分析")
tb(sl, MARGIN, CONTENT_TOP, Inches(6), Inches(0.3),
   "本番系 月別コスト推移", fs=13, b=True, c=DARK_BLUE)

trend_data = [[""] + COST_MONTHS, ["合計"] + COST_PROD, ["前月比"] + COST_PROD_MOM]
tbl(sl, MARGIN, CONTENT_TOP + Inches(0.4), FULL_W, Inches(0.8), trend_data)

if COST_SERVICES_PROD:
    svc_top = CONTENT_TOP + Inches(1.4)
    tb(sl, MARGIN, svc_top, Inches(12), Inches(0.3),
       "本番系 サービス別月次推移", fs=12, b=True, c=DARK_BLUE)
    svc_data = [["サービス"] + COST_MONTHS + ["変動"]] + COST_SERVICES_PROD
    svc_h = min(Inches(0.35) * len(svc_data), Inches(2.0))
    tbl(sl, MARGIN, svc_top + Inches(0.4), FULL_W, svc_h, svc_data)

# ----- S3: Cost Optimization -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
hdr(sl, "コスト最適化")

# Production cost table
tb(sl, MARGIN, CONTENT_TOP, Inches(6), Inches(0.3),
   "本番系", fs=13, b=True, c=DARK_BLUE)
cost_prod_data = [["推奨事項", "件数", "年間削減", "対象リソース例"]] + ADVISOR_COST_PROD
cost_h = min(Inches(0.35) * len(cost_prod_data), Inches(2.0))
tbl(sl, MARGIN, CONTENT_TOP + Inches(0.4), FULL_W, cost_h, cost_prod_data,
    col_widths=[5, 1, 2, 5])

# Evaluation cost table
eval_top = CONTENT_TOP + Inches(0.4) + cost_h + GAP
tb(sl, MARGIN, eval_top, Inches(6), Inches(0.3),
   "評価系", fs=13, b=True, c=DARK_BLUE)
cost_eval_data = [["推奨事項", "件数", "年間削減", "対象リソース"]] + ADVISOR_COST_EVAL
eval_h = min(Inches(0.35) * len(cost_eval_data), Inches(1.5))
tbl(sl, MARGIN, eval_top + Inches(0.4), FULL_W, eval_h, cost_eval_data,
    col_widths=[5, 1, 2, 5])
add_notes(sl, "コスト最適化: Advisor Cost カテゴリの推奨事項。年間削減額は Advisor 推定値。")

# ----- S4: Security (Production) -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
hdr(sl, "セキュリティ — 本番系")
sec_data = [["推奨事項", "件数", "影響度", "対象リソース（代表3件 + 残数）"]] + ADVISOR_SEC_PROD
sec_h = min(Inches(0.35) * len(sec_data), Inches(3.5))
tbl(sl, MARGIN, CONTENT_TOP, FULL_W, sec_h, sec_data, hc=RGBColor(0xC0, 0x39, 0x2B),
    col_widths=[5, 1, 1, 6])
add_notes(sl, "セキュリティ（本番系）: Advisor Security カテゴリ。High 影響度を優先対応。")

# ----- S5: Security (Evaluation) -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
hdr(sl, "セキュリティ — 評価系")
sec2_data = [["推奨事項", "件数", "影響度", "対象リソース（代表3件 + 残数）"]] + ADVISOR_SEC_EVAL
sec2_h = min(Inches(0.35) * len(sec2_data), Inches(3.0))
tbl(sl, MARGIN, CONTENT_TOP, FULL_W, sec2_h, sec2_data, hc=RGBColor(0xC0, 0x39, 0x2B),
    col_widths=[5, 1, 1, 6])
add_notes(sl, "セキュリティ（評価系）: 本番と同様に High 影響度を中心に確認。")

# ----- S6: Reliability (Production) -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
hdr(sl, "信頼性・可用性 — 本番系")
rel_data = [["推奨事項", "件数", "影響度", "対象リソース"]] + ADVISOR_REL_PROD
rel_h = min(Inches(0.35) * len(rel_data), Inches(3.5))
tbl(sl, MARGIN, CONTENT_TOP, LEFT_W, rel_h, rel_data, hc=RGBColor(0x29, 0x80, 0xB9),
    col_widths=[5, 1, 1, 5])
ibox(sl, RIGHT_X, CONTENT_TOP, RIGHT_W, Inches(2.5),
     "💡 改善ポイント",
     ["Zone 冗長化やバックアップ設定を", "優先的に確認してください"],
     bg=LIGHT_GREEN, tc=RGBColor(0x1A, 0x5E, 0x3A))
add_notes(sl, "信頼性（本番系）: Advisor HighAvailability カテゴリ。Zone 冗長・Backup を優先。")

# ----- S7: Reliability (Evaluation) -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
hdr(sl, "信頼性・可用性 — 評価系")
rel2_data = [["推奨事項", "件数", "影響度", "対象リソース"]] + ADVISOR_REL_EVAL
rel2_h = min(Inches(0.35) * len(rel2_data), Inches(3.5))
tbl(sl, MARGIN, CONTENT_TOP, LEFT_W, rel2_h, rel2_data, hc=RGBColor(0x29, 0x80, 0xB9),
    col_widths=[5, 1, 1, 5])
add_notes(sl, "信頼性（評価系）: 評価環境の冗長化は必要性を判断の上対応。")

# ----- S8: Appendix -----
sl = prs.slides.add_slide(prs.slide_layouts[6])
hdr(sl, "補足情報")

tf = tb(sl, MARGIN, CONTENT_TOP + Inches(0.2), Inches(6), Inches(4),
        "Azure Portal リンク", fs=14, b=True, c=DARK_BLUE)
for label, url in PORTAL_LINKS:
    ap(tf, "")
    ap(tf, label, fs=12, b=True)
    ap(tf, url, fs=9, c=MS_BLUE)

ibox(sl, Inches(7), CONTENT_TOP + Inches(0.2), Inches(5.8), Inches(4),
     "❗ 免責事項",
     ["本レポートのコスト削減見込額は Azure Advisor の推定値に基づく概算値です。",
      "実際の削減額は利用状況・価格改定・為替変動等により異なる場合があります。",
      "",
      "注意事項:",
      "・推奨事項の件数・対象リソースは日々変動します",
      "・最新の状況は Azure Portal からご確認ください",
      "",
      f"データ取得日: {REPORT_DATE}"],
     bg=LIGHT_RED, tc=RED)
add_notes(sl, "補足情報: Portal 直リンクと免責事項。データ取得日を明示。")


# ============================================================
# SAVE
# ============================================================

if __name__ == "__main__":
    parser = argparse.ArgumentParser(description="Generate Azure Advisor monthly report PPTX")
    parser.add_argument("--output", "-o", default="report.pptx", help="Output file path")
    args = parser.parse_args()
    out = args.output
    tmp = out + '.tmp.pptx'
    prs.save(tmp)
    if os.path.exists(out):
        os.remove(out)
    os.rename(tmp, out)
    print(f"Saved: {out}")

param(
    [Parameter(Mandatory = $true)]
    [string]$SubscriptionId,

    [string]$OutputDir = "output",

    [string]$ApiVersion = "2025-01-01"
)

$ErrorActionPreference = "Stop"

$categories = @(
    @{ Name = "Cost"; File = "advisor-cost.json" },
    @{ Name = "Security"; File = "advisor-security.json" },
    @{ Name = "HighAvailability"; File = "advisor-reliability.json" },
    @{ Name = "OperationalExcellence"; File = "advisor-opex.json" }
)

New-Item -ItemType Directory -Path $OutputDir -Force | Out-Null

$visible = az account list --all --query "[?id=='$SubscriptionId'].{name:name,id:id,tenantId:tenantId,state:state}" -o json | ConvertFrom-Json
if (-not $visible -or @($visible).Count -eq 0) {
    throw "Subscription '$SubscriptionId' is not visible in the current Azure CLI login context."
}

az account set --subscription $SubscriptionId | Out-Null
$account = az account show --query "{name:name,id:id,tenantId:tenantId}" -o json | ConvertFrom-Json
$account | ConvertTo-Json -Depth 5 | Set-Content -LiteralPath (Join-Path $OutputDir "advisor-preflight.json") -Encoding UTF8

$token = az account get-access-token --resource https://management.azure.com/ --query accessToken -o tsv
$httpClient = [System.Net.Http.HttpClient]::new()
$httpClient.Timeout = [TimeSpan]::FromSeconds(60)
$httpClient.DefaultRequestHeaders.Authorization = [System.Net.Http.Headers.AuthenticationHeaderValue]::new("Bearer", $token)

function Get-RecommendationsByCategory {
    param(
        [Parameter(Mandatory = $true)]
        [string]$Category
    )

    $encodedFilter = [System.Uri]::EscapeDataString("Category eq '$Category'")
    $nextUrl = "https://management.azure.com/subscriptions/$SubscriptionId/providers/Microsoft.Advisor/recommendations?api-version=$ApiVersion&`$filter=$encodedFilter"
    $items = New-Object System.Collections.Generic.List[object]

    while ($nextUrl) {
        $json = $httpClient.GetStringAsync($nextUrl).GetAwaiter().GetResult()
        $response = $json | ConvertFrom-Json
        foreach ($item in @($response.value)) {
            $items.Add($item)
        }
        $nextUrl = $response.nextLink
    }

    return $items
}

try {
    foreach ($category in $categories) {
        $items = Get-RecommendationsByCategory -Category $category.Name
        $outputPath = Join-Path $OutputDir $category.File
        if (@($items).Count -eq 0) {
            Set-Content -LiteralPath $outputPath -Value '[]' -Encoding UTF8
        }
        else {
            $items | ConvertTo-Json -Depth 20 | Set-Content -LiteralPath $outputPath -Encoding UTF8
        }
        Write-Output ("{0}={1}" -f $category.Name, @($items).Count)
    }
}
finally {
    $httpClient.Dispose()
}

import http.client
import json
import os
import shutil
import subprocess
import sys
import urllib.parse
from collections import defaultdict


def get_access_token() -> str:
    token_from_env = os.environ.get("AZURE_ACCESS_TOKEN")
    if token_from_env:
        return token_from_env.strip()

    az_executable = shutil.which("az.cmd") or shutil.which("az.exe") or shutil.which("az")
    if not az_executable:
        raise FileNotFoundError("Azure CLI executable was not found in PATH.")

    result = subprocess.run(
        [
            az_executable,
            "account",
            "get-access-token",
            "--resource",
            "https://management.azure.com/",
            "--query",
            "accessToken",
            "-o",
            "tsv",
        ],
        check=True,
        capture_output=True,
        text=True,
        encoding="utf-8",
        errors="replace",
    )
    return result.stdout.strip()


def fetch_json(connection: http.client.HTTPSConnection, url: str, token: str) -> dict:
    if url.startswith("/"):
        request_target = url
    else:
        parsed_url = urllib.parse.urlsplit(url)
        request_target = parsed_url.path
        if parsed_url.query:
            request_target += "?" + parsed_url.query

    request_target = request_target.replace(" ", "%20")

    connection.request("GET", request_target, headers={"Authorization": f"Bearer {token}"})
    response = connection.getresponse()
    payload = response.read()

    if response.status >= 400:
        raise RuntimeError(payload.decode("utf-8", errors="replace"))

    return json.loads(payload.decode("utf-8"))


def build_initial_url(subscription_id: str, start_date: str, end_date: str, page_size: int) -> str:
    filter_value = f"properties/usageStart ge '{start_date}' and properties/usageEnd le '{end_date}'"
    query = urllib.parse.urlencode(
        {
            "metric": "ActualCost",
            "$filter": filter_value,
            "$top": str(page_size),
            "api-version": "2019-10-01",
        }
    )
    return (
        f"https://management.azure.com/subscriptions/{subscription_id}"
        f"/providers/Microsoft.Consumption/usageDetails?{query}"
    )


def main() -> int:
    if len(sys.argv) not in (5, 6):
        print(
            "Usage: py -3 scripts/get-legacy-usage-summary.py <subscription_id> <start_date> <end_date> <output_path> [page_size]",
            file=sys.stderr,
        )
        return 2

    subscription_id, start_date, end_date, output_path = sys.argv[1:5]
    page_size = int(sys.argv[5]) if len(sys.argv) == 6 else 100
    token = get_access_token()
    next_url = build_initial_url(subscription_id, start_date, end_date, page_size)
    connection = http.client.HTTPSConnection("management.azure.com", timeout=60)

    total_cost = 0.0
    currency = None
    item_count = 0
    page_count = 0
    service_totals = defaultdict(float)

    try:
        while next_url:
            print(f"FETCH_PAGE={page_count + 1}", flush=True)
            payload = fetch_json(connection, next_url, token)
            page_count += 1
            print(f"PAGE_ITEMS={len(payload.get('value', []))}", flush=True)

            for item in payload.get("value", []):
                properties = item.get("properties", {})
                cost = float(properties.get("cost") or 0.0)
                service_name = (
                    properties.get("consumedService")
                    or properties.get("product")
                    or properties.get("resourceName")
                    or "Unknown"
                )
                billing_currency = properties.get("billingCurrency")

                total_cost += cost
                service_totals[service_name] += cost
                item_count += 1

                if not currency and billing_currency:
                    currency = billing_currency

            next_url = payload.get("nextLink")
    finally:
        connection.close()

    top_services = [
        {
            "serviceName": service_name,
            "cost": round(cost, 4),
        }
        for service_name, cost in sorted(service_totals.items(), key=lambda pair: pair[1], reverse=True)[:10]
    ]

    summary = {
        "subscriptionId": subscription_id,
        "startDate": start_date,
        "endDate": end_date,
        "pageSize": page_size,
        "currency": currency,
        "totalCost": round(total_cost, 4),
        "itemCount": item_count,
        "pageCount": page_count,
        "topServices": top_services,
    }

    with open(output_path, "w", encoding="utf-8") as file_handle:
        json.dump(summary, file_handle, ensure_ascii=False, indent=2)

    print(f"TOTAL={summary['totalCost']}")
    print(f"CURRENCY={summary['currency']}")
    print(f"ITEMS={summary['itemCount']}")
    print(f"PAGES={summary['pageCount']}")
    for index, item in enumerate(top_services, start=1):
        print(f"TOP{index}={item['serviceName']}|{item['cost']}")

    return 0


if __name__ == "__main__":
    raise SystemExit(main())