CODEWITHSUNDEEP
powershellwql
deutschZuid
deutschZuid

Reputation: 1058

How do I count the total number of rows returned from a WQL query?

I am trying to find the total number of CPUs on a computer via get-wmiobject. The query: select * from win32_processor returns more than 1 row if there is more than 1 processor on the computer. WQL doesn't have the count keyword like in TSQL. So I am just wondering whether there is another way to find the total number of rows returned?

Upvotes: 3

Views: 6759

Answers (2)

Shay Levy
Shay Levy

Reputation: 126762

You can also try the Win32_OperatingSystem class:

Get-WmiObject -Class Win32_OperatingSystem -ComputerName localhost | `
   Select-Object NumberOfProcessors,NumberOfLogicalProcessors

Upvotes: 4

manojlds
manojlds

Reputation: 301167

You can just force it into an array and use the Count property:

@(gwmi win32_processor).count

For the specific case, if you are just looking for number of processors, you can do:

$env:NUMBER_OF_PROCESSORS

Upvotes: 8

Related Questions