Powershell – How to get the “description” attribute of an OU in ActiveDirectory

active-directorypowershellwindows-server-2008-r2

I'm working on a set of script that will be used to migrate the users and structure from one active directory to another. For this, I'm using the Get-ADOrganizationalUnit commandlet to export the OUs like this:

Get-ADOrganizationalUnit -SearchBase $filterbase -filter * | export-csv $outcsv

As it turns out, we have useful information stored in the "description" attribute of the source OUs. Unfortunately, it doesn't seem that this information is part of the data exported by the Get-ADOrganizationalUnit commandlet.

So, could anyone suggest a way in which I could get the same information from the source AD but including the Description ?

In truth, I can work very well if the only attributes I get back are DistinguishedName, name and description so if you have another way to list all OUs under a specific OU in AD that includes these attributes, (and can be piped to export-csv), it'll work as well.

Best Answer

Get-ADOrganizationalUnit -SearchBase $filterbase -filter * -Properties Description| export-csv $outcsv

Should be what you're looking for. In almost all cases, if you want additional properties returned, then -Properties followed by a comma separated list of the additional properties is what you're looking for.

If you only want the three attributes that you mention in your question, then do something like:

Get-ADOrganizationalUnit -filter * -Properties Description | select-object name,distinguishedname,description | export-csv $outcsv

Related Solutions

Powershell – Decoding a base64 encoded field in a csv with powershell

Save this as import.ps1 and use as follows: .\import.ps1 C:\test.csv. It will output a CSV in the current directory called Output.csv.

You'll also need to change the Port columns so one is SourcePort and one is DestPort - you can't have 2 columns with the same name when using Import-Csv.

$csv = Import-Csv $args[0]

$csv | ForEach-Object { $_.PacketData = [text.encoding]::utf8.getstring([convert]::FromBase64String($_.PacketData)) }

$csv | Export-Csv "Output.csv" -NoTypeInformation

Sql-server – Using powershell to gather disk used into a sql table

$servers = Invoke-Sqlcmd -Query "SELECT SERVERHardwareName FROM SERVERLIST_Hardware WHERE EXCLUDE = 0 and activenode = 1 or activenode is null;" -ServerInstance "sqlserver" -Database "dba_rep" | foreach {$_.SERVERHardwareName}
$ExportPath = 'c:\temp\psout\Server-DiskSpace.csv'  
Get-WmiObject -ComputerName $servers -Query 'SELECT * from Win32_LogicalDisk WHERE DriveType=3' ` 
| select SystemName,DeviceId,DriveType, VolumeName,Description, @{Label="FreeSpace(GB)";Expression={"{0:N2}" -f ($_.FreeSpace/1GB)}},`
  @{Label="Size(GB)";Expression={"{0:N2}" -f ($_.Size/1GB)}} | Export-Csv -NoTypeInformation -Path $exportpath

You can simplify quite a bit by loading your lists of servers into an array and passing the array to get-wmiobject. If you look at get-help get-wmiobject you'll notice the computername parameter is string[], whenever you see string[] this means it take an array.

Best Answer

Related Solutions

Powershell – Decoding a base64 encoded field in a csv with powershell

Sql-server – Using powershell to gather disk used into a sql table

Related Topic