Export Domain Computers with Powershell

If you want to export all domain computers to a csv file , it’s very humble with powershell.

Let’s see step by step.

$strFilter = "(&(objectCategory=Computer))"

First of all, you will attach computer filter for $strFilter variable.

$objDomain = New-Object System.DirectoryServices.DirectoryEntry
$objSearcher = New-Object System.DirectoryServices.DirectorySearcher

Connect to Active Directory Searcher.

$objSearcher.SearchRoot = $objDomain
$objSearcher.PageSize = 1000
$objSearcher.Filter = $strFilter
$objSearcher.SearchScope = "Subtree"

Just export 1000 line and specify the SearchScope property.

Searchroot property tells DirectorySearcher where to begin.If you want to search entire domain we set the reference $objDomain .

$colProplist = "name"
foreach ($i in $colPropList){[void]$objSearcher.PropertiesToLoad.Add($i)}

Property lists need to be constructed as arrays.In powershell you can create an array by assigning multiple values.Very simple.

$colResults = $objSearcher.FindAll()

We call FindAll() method to to search active directory.

$colResults | %{ $a = New-Object PSObject ; $a | Add-Member -MemberType NoteProperty -Name Name -Value $_.Properties.Item("Name")[0] ; $a } | Export-Csv -NoTypeInformation "C:serverExportComputers.csv"

At least, for each item we must store the item properties in a variable.Objcomputer.name give us an output, take that and export as an csv file.


One thought on “Export Domain Computers with Powershell

  1. Thank you for the auspicious writeup. It
    in fact was a amusement account it. Look advanced to
    far added agreeable from you! However, how could we communicate?

Leave a Reply

Your email address will not be published. Required fields are marked *

+ 66 = 69