Get-DbaComputerSystem

Synopsis

Retrieves comprehensive hardware and system information from Windows computers hosting SQL Server instances.

Description

Collects detailed system specifications including processor details, memory configuration, domain membership, and hardware information from target computers. This function is essential for SQL Server capacity planning, pre-installation system verification, and troubleshooting performance issues by providing complete hardware inventory data.

The function queries WMI classes (Win32_ComputerSystem and Win32_Processor) to gather CPU details, determines hyperthreading status, checks total physical memory, and identifies domain roles. It also detects pending reboots that could affect SQL Server operations and optionally retrieves AWS EC2 metadata for cloud-hosted instances.

Use this command when documenting SQL Server environments, verifying system requirements before installations or upgrades, or investigating hardware-related performance bottlenecks.

Syntax

Get-DbaComputerSystem
    [[-ComputerName] <DbaInstanceParameter[]>]
    [[-Credential] <PSCredential>]
    [-IncludeAws]
    [-EnableException]
    [<CommonParameters>]

Examples

Example: 1

PS C:\> Get-DbaComputerSystem

Returns information about the local computer’s computer system

Example: 2

PS C:\> Get-DbaComputerSystem -ComputerName sql2016

Returns information about the sql2016’s computer system

Example: 3

PS C:\> Get-DbaComputerSystem -ComputerName sql2016 -IncludeAws

Returns information about the sql2016’s computer system and includes additional properties around the EC2 instance.

Optional Parameters

-ComputerName

Specifies the target computer(s) to collect system information from. Defaults to the local computer when not specified.
Use this to inventory multiple SQL Server hosts at once or to gather system details from remote servers for capacity planning and troubleshooting.

-Credential

Alternate credential object to use for accessing the target computer(s).

-IncludeAws

Retrieves additional AWS EC2 metadata when the target computer is hosted on Amazon Web Services. Adds properties like AMI ID, instance type, availability zone, and IAM role information.
Use this switch when documenting cloud-hosted SQL Server environments or when you need AWS-specific details for compliance or cost management purposes.

-EnableException

By default, when something goes wrong we try to catch it, interpret it and give you a friendly warning message.
This avoids overwhelming you with “sea of red” exceptions, but is inconvenient because it basically disables advanced scripting.
Using this switch turns this “nice by default” feature off and enables you to catch exceptions with your own try/catch.