How to count number of rows in a powershell variable

Question

I have the following powershell query :

$sql = "select name, lastName, City, Address from Persons"

$TotalPeople = Invoke-Sqlcmd -ServerInstance $ResultsInstance -Database $ResultsDatabase -Query $sql

Write-Output "Total number of people run is $TotalPeople  "

I want to be able to count the number of rows in the $TotalPeople variable. Is there a way to do this in powershell?

$TotalPeople.count ? :)

Sage Pourpre
– Sage Pourpre

2017-09-07 15:32:21 +00:00
Commented Sep 7, 2017 at 15:32 — Sage Pourpre
– Sage Pourpre, Commented Sep 7, 2017 at 15:32

Sage Pourpre · Accepted Answer · 2021-08-23 06:32:42Z

9

Invoke-sqlCmd returns an array.

You can therefore simply use the Count property.

$sql = "select name, lastName, City, Address from Persons"
$TotalPeople = Invoke-Sqlcmd -ServerInstance $ResultsInstance -Database $ResultsDatabase -Query $sql
Write-Output "Total number of people run is $($TotalPeople.count)"

edited Aug 23, 2021 at 6:32

answered Sep 7, 2017 at 15:35

Sage Pourpre

10.4k3 gold badges30 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to count number of rows in a powershell variable

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related