Powershell: How to combine the output of 2 commands to associate disk letter with disk MediaType?

Question

I'm using the following command to get disk info:

get-ciminstance -ClassName Win32_LogicalDisk

The problem is, it doesn't contain the MediaType property (HDD, SSD, or in numerical form 4, 3 respectively).

I suppose I need to combine (associate) it with another command, like:

• Get-PhysicalDisk or
• Get-WmiObject -Class MSFT_PhysicalDisk -Namespace root\Microsoft\Windows\Storage

I'm calling these commands from Node.js, so I can run separate commands and combine the results afterwards. It doesn't have to be 1 command. I'm just not sure how to correlate them, because Powershell API are inconsistent:

This one returns numbers

(Get-WmiObject -Class MSFT_PhysicalDisk -Namespace root\Microsoft\Windows\Storage).DeviceID

And this one returns drive letters

(get-ciminstance -ClassName Win32_LogicalDisk).DeviceID

I found this code in another thread but I'm not sure how to add the MediaType property in it:

Get-WmiObject Win32_DiskDrive | ForEach-Object {
  $disk = $_
  $partitions = "ASSOCIATORS OF " +
                "{Win32_DiskDrive.DeviceID='$($disk.DeviceID)'} " +
                "WHERE AssocClass = Win32_DiskDriveToDiskPartition"
  Get-WmiObject -Query $partitions | ForEach-Object {
    $partition = $_
    $drives = "ASSOCIATORS OF " +
              "{Win32_DiskPartition.DeviceID='$($partition.DeviceID)'} " +
              "WHERE AssocClass = Win32_LogicalDiskToPartition"
    Get-WmiObject -Query $drives | ForEach-Object {
      New-Object -Type PSCustomObject -Property @{
        Disk        = $disk.DeviceID
        DiskSize    = $disk.Size
        DiskModel   = $disk.Model
        Partition   = $partition.Name
        RawSize     = $partition.Size
        DriveLetter = $_.DeviceID
        VolumeName  = $_.VolumeName
        Size        = $_.Size
        FreeSpace   = $_.FreeSpace
      }
    }
  }
}

Answer 1

I've had mixed results with getting mediatype and other properties. Some systems return the actual values, others return the integer instead. Here is a snippet from a script of mine that may help you solve this.

Get-CimInstance Win32_Diskdrive -Filter "Partitions>0" | ForEach-Object {
    $disk = Get-CimInstance -ClassName MSFT_PhysicalDisk -Namespace root\Microsoft\Windows\Storage -Filter "SerialNumber='$($_.SerialNumber.trim())'"

    foreach($partition in $_ | Get-CimAssociatedInstance -ResultClassName Win32_DiskPartition){
        foreach($logicaldisk in $partition | Get-CimAssociatedInstance -ResultClassName Win32_LogicalDisk){
            [PSCustomObject]@{
                Disk          = $_.DeviceID
                DiskModel     = $_.Model
                DiskSize      = $_.Size
                HealthStatus  = $disk.HealthStatus
                BusType       = $disk.BusType
                MediaType     = "{0} ({1})" -f $_.MediaType,$disk.MediaType
                Partition     = $partition.Name
                PartitionSize = $partition.Size
                VolumeName    = $logicaldisk.VolumeName
                DriveLetter   = $logicaldisk.DeviceID
                VolumeSize    = $logicaldisk.Size
                FreeSpace     = $logicaldisk.FreeSpace
            }
        }
    }
}

For those times when the code is returned instead, this can be ran instead.

$mediatypelist = @{
    '0' = 'Unspecified'
    '3' = 'HDD'
    '4' = 'SSD'
    '5' = 'SCM'
}

$healthstatuslist = @{
    '0' = 'Healthy'
    '1' = 'Warning'
    '2' = 'Unhealthy'
    '5' = 'Unknown'
}

$bustypelist = @{
    '0' = 'Unknown'
    '1' = 'SCSI'
    '2' = 'ATAPI'
    '3' = 'ATA'
    '4' = 'IEEE 1394'
    '5' = 'SSA'
    '6' = 'Fibre Channel'
    '7' = 'USB'
    '8' = 'RAID'
    '9' = 'iSCSI'
    '10' = 'Serial Attached SCSI (SAS)'
    '11' = 'Serial ATA (SATA)'
    '12' = 'Secure Digital (SD)'
    '13' = 'Multimedia Card (MMC)'
    '14' = 'This value is reserved for system use.'
    '15' = 'File-Backed Virtual'
    '16' = 'Storage Spaces'
    '17' = 'NVMe'
    '18' = 'This value is reserved for system use.'
}

Get-CimInstance Win32_Diskdrive -Filter "Partitions>0" | ForEach-Object {
    $disk = Get-CimInstance -ClassName MSFT_PhysicalDisk -Namespace root\Microsoft\Windows\Storage -Filter "SerialNumber='$($_.SerialNumber.trim())'"

    foreach($partition in $_ | Get-CimAssociatedInstance -ResultClassName Win32_DiskPartition){
        foreach($logicaldisk in $partition | Get-CimAssociatedInstance -ResultClassName Win32_LogicalDisk){
            [PSCustomObject]@{
                Disk          = $_.DeviceID
                DiskModel     = $_.Model
                DiskSize      = $_.Size
                HealthStatus  = $healthstatuslist["$($disk.HealthStatus)"]
                BusType       = $bustypelist["$($disk.BusType)"]
                MediaType     = "{0} ({1})" -f $_.MediaType,$mediatypelist["$($disk.MediaType)"]
                Partition     = $partition.Name
                PartitionSize = $partition.Size
                VolumeName    = $logicaldisk.VolumeName
                DriveLetter   = $logicaldisk.DeviceID
                VolumeSize    = $logicaldisk.Size
                FreeSpace     = $logicaldisk.FreeSpace
            }
        }
    }
}

Answer 2

I don't know if there is a more sophisticated way but I think it provides the result you expect.

$PhysicalDiskList = 
    Get-PhysicalDisk
$LogicalDiskList = 
    Get-CimInstance -ClassName CIM_LogicalDisk | 
        Where-Object -Property 'DriveType' -EQ -Value 3
$Result = 
foreach ($LogicalDisk in $LogicalDiskList) {
    $DiskPartition = 
        Get-CimAssociatedInstance -InputObject $LogicalDisk -ResultClass CIM_DiskPartition
    $PhysicalDisk = 
        $PhysicalDiskList | 
            Where-Object -Property 'DeviceID' -EQ -Value $DiskPartition.DiskIndex
    [PSCustomObject]@{
        DriveLetter = $LogicalDisk.DeviceID
        VolumeName  = $LogicalDisk.VolumeName
        Size        = $LogicalDisk.Size
        FreeSpace   = $LogicalDisk.FreeSpace
        DriveModel  = $PhysicalDisk.FriendlyName
        MediaType   = $PhysicalDisk.MediaType
    }
}

$Result | 
    Format-Table -AutoSize

It returns on my system the following:

DriveLetter VolumeName          Size    FreeSpace DriveModel                 MediaType
----------- ----------          ----    --------- ----------                 ---------
C:          System      254493077504  49397727232 SAMSUNG MZNTY256HDHP-000L7 SSD
D:          Data       1000067821568 643155914752 WDC WD10SPCX-08S8TT0       HDD