Forum Discussion

Gianni88's avatar
Gianni88
Copper Contributor
Nov 20, 2019

PowerShell command to export user's manager name

Dear all,   I would like to know what is the powershell command to get this information :    First Name Last Name Email address JobTitle Manager report Name         ...
  • FedericoPorceddu82's avatar
    FedericoPorceddu82
    Dec 03, 2019

    Hi Gianni88 

    it is normal you can't find the Manager field.

    The foreach make the work for you, expanding manager property ğŸ™‚

    Please, debug your scripts in ISE or using output messages 🙂
    Cheers,

    Federico

FedericoPorceddu82's avatar
FedericoPorceddu82
MVP
Dec 03, 2019

Hi Gianni88 

it is normal you can't find the Manager field.

The foreach make the work for you, expanding manager property ğŸ™‚

Please, debug your scripts in ISE or using output messages 🙂
Cheers,

Federico

  • Gianni88's avatar
    Gianni88
    Copper Contributor
    Dec 03, 2019

    FedericoPorceddu82 :

     

    Found this powershell command also, it can help : 

     

    Get-ADUser -Filter * -SearchBase 'OU=xxxx,OU=xxxxxx,DC=xxx' -Properties Manager, Title |
    Select-Object -Property Name, Title, @{label='Manager';expression={$_.manager -replace '^CN=|,.*$'}}

     

    It works perfectly

Resources