Wednesday, September 2, 2026

Powershell select query for windows with tables

 Get-CimInstance -Query "select * from Win32_OperatingSystem "

Get-CimInstance -Query "SELECT * FROM Win32_SystemDriver WHERE Name='ntfs'"


Get-CimInstance -Query "select * from win32_baseService where Name='Themes'"


tables


Win32_Service

Win32_SystemDriver


⚙️ Operating System Core & Drivers
  • Win32_Service: Standard Windows background services (the counterpart to system drivers).
  • Win32_PnPSignedDriver: Digital signature and version details for Plug-and-Play drivers (great for checking if a driver is outdated).
  • Win32_Bus: Physical and logical expansion buses (like PCI, USB).
  • Win32_DeviceChangeEvent: Monitors when devices/drivers are added or removed from the system.
🔌 Physical Hardware & Devices
  • Win32_PnPEntity: Every Plug-and-Play device recognized by Device Manager (cameras, mice, keyboards, etc.).
  • Win32_DiskDrive: Physical hard drives and SSDs (shows model, serial number, and size).
  • Win32_VideoController: Graphics cards/GPUs and active video drivers.
  • Win32_NetworkAdapter: Physical and virtual network cards.
🖥️ System Management & Memory
  • Win32_Processor: CPU details (cores, clock speed, current load).
  • Win32_PhysicalMemory: Physical RAM sticks (shows capacity, speed, and manufacturer).
  • Win32_BIOS: Motherboard BIOS/UEFI version, serial number, and manufacturer.
  • Win32_OperatingSystem: General Windows details (build version, boot time, registered user).