I'm trying to figure out how to get the information from all of our machines using Powershell to import into AutoPilot.

I think I've got most of it working, but the commands I have found using Powershell do not work as expected when pulling the Product ID. We have a mix of the different types of keys, so I'm wondering if that is it. If I use the command (Get-WmiObject -query ‘select * from SoftwareLicensingService’).OA3xOriginalProductKey I get the following:

Get-WmiObject : A positional parameter cannot be found that accepts argument '*'.

I can use the command line and pull that info, but how do I get it into the variable?

Get system information

$serialNumber = Get-WmiObject win32_bios | Select-Object -ExpandProperty SerialNumber

$productId = wmic path softwarelicensingservice get OA3xOriginalProductKey

$hardwareHash = Get-WmiObject -Class "Win32_ComputerSystemProduct" | Select-Object -ExpandProperty UUID

$model = Get-WmiObject -Class "Win32_ComputerSystem" | Select-Object -ExpandProperty Model

Define output file path

$outputFile = "\SERVER\output.csv"

Create output file if it doesn't exist

if (-not (Test-Path $outputFile)) {

New-Item -Path $outputFile -ItemType File

}

Append system information to output file

$data = [pscustomobject]@{

SerialNumber = $serialNumber

ProductId = $productId

HardwareHash = $hardwareHash

Model = $model

}

$data | Export-Csv -Path $outputFile -Append -NoTypeInformation

Your query works for me on Win 11 using PS 5.1.

Maybe a typo somewhere?

Here, try this.

# Get system information
$serialNumber = Get-WmiObject win32_bios | Select-Object -ExpandProperty SerialNumber
$productId = (Get-WmiObject -query "select * from SoftwareLicensingService").OA3xOriginalProductKey
$hardwareHash = Get-WmiObject -Class "Win32_ComputerSystemProduct" | Select-Object -ExpandProperty UUID
$model = Get-WmiObject -Class "Win32_ComputerSystem" | Select-Object -ExpandProperty Model

#Define output file path
$outputFile = "C:\temp\test.csv"    # "

# Not needed. Export-csv will create the file if its not there. 
#Create output file if it doesn't exist
#if (-not (Test-Path $outputFile)) {
#    New-Item -Path $outputFile -ItemType File
#}

# Append system information to output file
$data = [pscustomobject]@{
    SerialNumber = $serialNumber
    ProductId = $productId
    HardwareHash = $hardwareHash
    Model = $model
}

$data | Export-Csv -Path $outputFile -Append -NoTypeInformation

It wrote the Windows Product ID to the file?

You can see the script that I executed. I did not write it to a file.

There is no reason to use WMIC. It's deprecated and does the same thing that Get-WmiObject does. The difference is that it is a command line program and you would need to parse the output to get the data. It would be better to use Get-WmiObject or Get-CimInstance to query WMI and get the data back in a PS variable.

You commented that you got a "positional parameter" error. So I ran the query that you posted and it worked. See the image. I just displayed the length of the string because I did not want to display the product ID of my pc on this forum.

I suspect that you just had some typo error when you first tested it.

I wanted to demonstrate that Get-WmiObject is able to read the OA3xOriginalProductKey value. Use that instead of WMIC.

See updated answer.

@MotoX80, just a little rewrite of your code without the pipe, the Select-Objects, and the intermediary variables.

FYI, you have the OP's original smart-quotes (in the -Query parameter) in your code.

#Define output file path
$outputFile = "C:\temp\test.csv"    # "\\SERVER\output.csv"

# Get system information
$data = [pscustomobject]@{
    SerialNumber    = (Get-WmiObject win32_bios).SerialNumber
    ProductId       = (Get-WmiObject -query 'select * from SoftwareLicensingService').OA3xOriginalProductKey
    HardwareHash    = (Get-WmiObject -Class "Win32_ComputerSystemProduct").UUID
    Model           = (Get-WmiObject -Class "Win32_ComputerSystem").Model
}

Export-Csv -InputObject $data -Path $outputFile -Append -NoTypeInformation

Thanks. Interesting... That code runs in ISE. I wonder if that was his original problem.

OA3xOriginalProductKey only retrieve MSDM OEM key, to get the installed key regardless type:

Get-WmiObject -query "Select * FROM SoftwareLicensingProduct WHERE ApplicationID='55c92734-d682-4d71-983e-d6ec3f16059f' AND PartialProductKey IS NOT NULL"

then you can filter and select a property (e.g. ID, PartialProductKey, or ProductKeyID)