I have a PowerShell script that gavers AD attibutes Sammaccount,givenname, manager, office

Question

I have a powershell script which retrieves the Attribute information from Active Directory and then creates the CSV file.

The Attributes all come through however the manager attribute brings with it the OU paths

this is script and the CSV it create all is working but dont want the OU path that come with the manager atribute

$OU = "OU=User Accounts,OU=Accounts,OU=Common,OU=GB,OU=Users,OU=test,OU=OMEGA,DC=corp,DC=domainname-group,DC=com"

$CSVname = "C:\Users\user\Documents\outputresult.csv"

Get-ADUser -SearchBase $OU -Filter * -Properties SamAccountName,GivenName,Surname,EmailAddress,Department,Manager,Office| Select SamAccountName,GivenName,Surname,EmailAddress,Department,Manager,Office| Export-Csv $csvname

Answer 1

Try this:

$OU = "OU=User Accounts,OU=Accounts,OU=Common,OU=GB,OU=Users,OU=test,OU=OMEGA,DC=corp,DC=domainname-group,DC=com"

$CSVname = "C:\Users\user\Documents\outputresult.csv"

Get-ADUser -SearchBase $OU -Filter * -Properties SamAccountName,GivenName,Surname,EmailAddress,Department,Manager,Office |
    Select-Object SamAccountName,GivenName,Surname,EmailAddress,Department,@{n='Manager';e={(Get-ADUser $_.Manager).saMAccount}},Office | 
        Export-Csv $csvname