Count the number of rows in Powershell Array

Question

The I wrote the below script to return the name of all the Organisational Units in the domain that are empty.

I would like the script to also tell me the total number of empty OU's at the end, by counting the lines returned. I've tried assigning an $array to the New-Object, and adding various versions of $array.count or | Measure-Object at the end of the script, but all return 0.

Get-ADOrganizationalUnit -Filter * |
foreach {
    $o = Get-ADObject -filter * -searchbase $_.distinguishedname -searchscope 1
    $total = ($o | Measure-Object).Count 
    New-Object psobject -Property @{
        Name=$_.distinguishedname
        } |
        where-object {$total -le "0"}
    }

Shay Levy · Accepted Answer · 2013-07-03 12:27:21Z

4

$ou = Get-ADOrganizationalUnit -Filter * | 
Where-Object { -not (Get-ADObject -SearchBase $_.DistinguishedName -Filter * -SearchScope OneLevel) }


# get the count
$ou|measure

$list OUs
$ou

answered Jul 3, 2013 at 12:27

Shay Levy

128k34 gold badges193 silver badges210 bronze badges

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

2 Comments

idarryl Over a year ago

As always, you do the job in half the code, and your answer is right on the money, so I'll be accepting this as the answer. However, I didn't expect it to be so good. See I wanted to keep some flexibility in the script, in case my colleagues wanted to look for OU's that only had a couple of objects in an OU. Is there a way to keep the -le "0", or similar in the script so the so the number of objects searched for can be changed?

Shay Levy Over a year ago

Thanks, I geuss you can do: where{ @(Get-ADObject -SearchBase $_.DistinguishedName -Filter * -SearchScope OneLevel).Count -le $number}

Collectives™ on Stack Overflow

Count the number of rows in Powershell Array

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related