How to retrieve all empty OU in all my AD

Question

question

MohamedSAKHO-2817 asked Aug 5, '20 StoyanChalakov edited Aug 20, '20

How to retrieve all empty OU in all my AD

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

windows-server-powershell windows-active-directory

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 1 · 2020-08-05T14:17:26.1Z

KlausBilger-5062 answered Aug 5, '20

i guess you can try this

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

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 2 · 2020-08-20T01:47:31.573Z

YoungYang-MSFT answered Aug 20, '20

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.
:)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 3 · 2020-08-20T09:36:54.163Z

SAKHOMohamedExterne-1703 answered Aug 20, '20

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.

image.png (103.3 KiB)

2020-08-20-11-35.png (85.1 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Answer 4 · 2020-08-20T11:59:55.82Z

StoyanChalakov answered Aug 20, '20 StoyanChalakov edited Aug 20, '20

Hi @SAKHOMohamedExterne-1703,

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)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question