🧬 WQL / PowerShell

Win32_DiskDrive: Physical Disk Drives (WQL)

A minimal WQL reference query against Win32_DiskDrive — the raw SELECT statement plus a one-line runner, useful for learning WMI Query Language independent of any host language.

By WindowsScripting.com · 874 B
DiskDriveQuery.ps1
<#
.SYNOPSIS
    WQL reference: Physical Disk Drives (Win32_DiskDrive).

.DESCRIPTION
    A minimal example of querying Win32_DiskDrive with a raw WQL SELECT
    statement via Get-CimInstance -Query — useful as a WMI Query
    Language reference, independent of any particular scripting
    language's WMI binding.

    The same query string works with Get-WmiObject -Query (older
    PowerShell), GetObject("winmgmts:...").ExecQuery(...) in VBScript
    or JScript, and ManagementObjectSearcher in C# — only the syntax
    around the query changes, not the WQL itself.

.EXAMPLE
    .\DiskDriveQuery.ps1
#>

[CmdletBinding()]
param()

$wqlQuery = "SELECT Model, Size, InterfaceType, Status FROM Win32_DiskDrive"

Write-Host "WQL: $wqlQuery" -ForegroundColor DarkGray
Get-CimInstance -Query $wqlQuery | Format-Table -Property Model, Size, InterfaceType, Status -AutoSize