How to retrieve all empty OU in all my AD

Question

How to retrieve all empty OU in all my AD

Mohamed SAKHO 1

Hi all

I would like to know all empty OU existing on my AD.
I found a powershell command line below which retrieve this information:

Get-ADOrganizationalUnit -Filter * | ForEach-Object {
if (-not (Get-ADObject -SearchBase $_ -SearchScope OneLevel -Filter *))
{
$.Name +";;;;;;;;;;;;;;;;;;;;;;;;;"+$.DistinguishedName
}
}

This command works but it's not optimal. for example I would like to export to csv file with "export-csv -path filename.csv" and it doesn't work.
Idon't feel comfortable with powershell..
Does someone can help me to improve this script and export it. Or maybe somebody has something better in what I need?
Thank you by advance.

Mohamed

4 answers

Your answer

Answer 1

SChalakov 10,576 MVP Volunteer Moderator

Hi @SAKHO Mohamed (Externe) ,

This can be easily solved, you have missed a "*" in front of "-Filter" (2x). Please try it like that:

Get-ADOrganizationalUnit -Filter * | Where-Object {-not ( Get-ADObject -Filter * -SearchBase $_.Distinguishedname -SearchScope OneLevel -ResultSetSize 1 )}

This will help you find the empty OUs.

Regards

----------

(If the reply was helpful please don't forget to upvote or accept as answer, thank you)

Answer 2

Klaus Bilger 81

i guess you can try this

Get-ADOrganizationalUnit -Filter * |
Where-Object {-not ( Get-ADObject -Filter * -SearchBase $_.Distinguishedname -SearchScope OneLevel -ResultSetSize 1 )}

Answer 3

Young Yang (Shanghai Wicresoft Co,.Ltd.) 661

Hi, given that this post has been quiet for a while, this is a quick question and answer. Has your question been solved? If so, please mark it as an answer so that users with the same question can find and get help.
:)

Answer 4

SAKHO Mohamed (Externe) 1

Hi,

sorry for the late I was in holidays, that's why I didn't answered.
I tryied the command line but it doesn't work:

Thank you by advance.

LeeM 41 Reputation points

2024-07-30T22:28:33.69+00:00

Obviously this is years old, but the problem was that you didn't have the asterisk after -filter. Get-ADOrganizationalUnit -Filter * is a filter that gets all organisational units.

The OU list then gets piped to the Where-Object clause which only returns OUs where Get-ADObject does not find at least one object - i.e. an empty OU.

Share via

How to retrieve all empty OU in all my AD

4 answers

Your answer