win11-24h2-files

Compare original and translation side by side

🇺🇸

Original

English

🇨🇳

Translation

Chinese

Windows 11 24H2 Files

Windows 11 24H2 文件信息查询

Query ~2M file entries across 45+ Windows 11 24H2 cumulative updates (builds 26100.863 - 26100.7705+).

可查询45个以上Windows 11 24H2累积更新版本（内部版本号26100.863 至 26100.7705+）中的约200万条文件记录。

Database

数据库信息

Location:

~/moz_artifacts/win11_24h2_files.db

Schema:

files(kb_number, release_date, build, update_type, file_name, file_version, date, time, file_size)

Indexes:

file_name

kb_number

build

file_version

位置：

~/moz_artifacts/win11_24h2_files.db

表结构：

files(kb_number, release_date, build, update_type, file_name, file_version, date, time, file_size)

索引：

file_name

kb_number

build

file_version

Quick Start

快速开始

bash

undefined

bash

undefined

Search for files

搜索文件

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py search ntdll.dll

Version history for specific file

查询特定文件的版本历史

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py history ntdll.dll

Compare two builds

对比两个内部版本的文件差异

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py diff 26100.6584 26100.6899

List all patches

列出所有可用补丁

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py builds

Database stats

查看数据库统计信息

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py stats

Custom SQL

执行自定义SQL查询

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT DISTINCT file_version FROM files WHERE file_name='kernel32.dll' ORDER BY build"

undefined

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT DISTINCT file_version FROM files WHERE file_name='kernel32.dll' ORDER BY build"

undefined

Commands

命令说明

search

search（文件搜索）

Find files by name pattern (case-insensitive contains match by default).

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py search kernel          # contains "kernel"
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py search kernel32.dll --exact  # exact match
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py search .sys --limit 100

按文件名模式查找文件（默认不区分大小写的包含匹配）。

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py search kernel          # 搜索包含"kernel"的文件
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py search kernel32.dll --exact  # 精确匹配文件名
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py search .sys --limit 100

history

history（版本历史追踪）

Track how a file's version changed across all patches. Shows

marker when version changed.

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py history ntdll.dll
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py history tcpip.sys

追踪特定文件在所有补丁中的版本变化，版本变更时会显示

标记。

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py history ntdll.dll
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py history tcpip.sys

diff

diff（版本差异对比）

Compare file changes between two builds. Shows added, removed, and changed files.

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py diff 26100.6584 26100.6899
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py diff 26100.2894 26100.7705 --limit 20

对比两个内部版本之间的文件变化，显示新增、移除和修改的文件。

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py diff 26100.6584 26100.6899
uv run ~/.claude/skills/win11-24h2-files/scripts/query.py diff 26100.2894 26100.7705 --limit 20

builds

builds（补丁列表）

List all available patches with file counts.

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py builds

列出所有可用补丁及其文件数量。

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py builds

sql

sql（自定义SQL查询）

Run arbitrary SQL queries for complex analysis.

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT file_name, COUNT(DISTINCT file_version) as versions FROM files GROUP BY file_name ORDER BY versions DESC LIMIT 20"

执行任意SQL查询以进行复杂分析。

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT file_name, COUNT(DISTINCT file_version) as versions FROM files GROUP BY file_name ORDER BY versions DESC LIMIT 20"

Common Queries

常用查询示例

Find files that changed most frequently:

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT file_name, COUNT(DISTINCT file_version) as ver_count FROM files GROUP BY file_name HAVING ver_count > 10 ORDER BY ver_count DESC LIMIT 30"

Find all kernel-mode drivers (.sys) in a specific build:

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT file_name, file_version FROM files WHERE build='26100.6584' AND file_name LIKE '%.sys' ORDER BY file_name"

Check if a specific file version exists:

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT kb_number, build, release_date FROM files WHERE file_name='ntoskrnl.exe' AND file_version='10.0.26100.6584'"

查找变更最频繁的文件：

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT file_name, COUNT(DISTINCT file_version) as ver_count FROM files GROUP BY file_name HAVING ver_count > 10 ORDER BY ver_count DESC LIMIT 30"

查找特定内部版本中的所有内核模式驱动（.sys文件）：

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT file_name, file_version FROM files WHERE build='26100.6584' AND file_name LIKE '%.sys' ORDER BY file_name"

检查特定文件版本是否存在：

bash

uv run ~/.claude/skills/win11-24h2-files/scripts/query.py sql "SELECT kb_number, build, release_date FROM files WHERE file_name='ntoskrnl.exe' AND file_version='10.0.26100.6584'"