CODEWITHSUNDEEP
powershell
chancj
chancj

Reputation: 17

unexpected result from PowerShell

I'm expecting the result in PowerShell as following but it was out of my expectation. How do I correct it? Expecting

FriendlyName    |    MediaType| PSComputerName|    Serial Number
------------    |    --------- |--------------  |  -------------
ST500DM002-1BD142|   3        | ABCD-IT       |    6CR4160X2H
Samsung SSD 250GB|   4        | ABCD-IT       |    6CR4160X2H
Result
FriendlyName     |   MediaType| PSComputerName|    Serial Number
------------     |   ---------| --------------|    -------------
ST500DM002-1BD142|   3        | ABCD-IT       |    @{serialnumber=6CR4160X2H}
Samsung SSD 250GB|   4        | ABCD-IT       |    @{serialnumber=6CR4160X2H}

Coding

Get-WmiObject -Class MSFT_PhysicalDisk -ComputerName ABCD-IT -Namespace root\Microsoft\Windows\Storage | Select FriendlyName, MediaType, pscomputername,@{name="Serial Number";expression={Get-WmiObject Win32_Bios | select serialnumber}}

Upvotes: 0

Views: 117

Answers (1)

Scepticalist
Scepticalist

Reputation: 3923

As above, either -ExpandProperty or just drill down to the actual value:

Get-WmiObject -Class MSFT_PhysicalDisk -ComputerName localhost -Namespace root\Microsoft\Windows\Storage | Select FriendlyName, MediaType, pscomputername,@{name="SerialNumber";expression={Get-WmiObject Win32_Bios | Select-Object -ExpandProperty SerialNumber}}

or

Get-WmiObject -Class MSFT_PhysicalDisk -ComputerName localhost -Namespace root\Microsoft\Windows\Storage | Select FriendlyName, MediaType, pscomputername,@{name="SerialNumber";expression={(Get-WmiObject Win32_Bios | Select-Object SerialNumber).SerialNumber}}

Upvotes: 1

Related Questions