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 ,

try to run 

> $users = Get-AzureADUser -All $true
> $users

after connect 🙂
Are there users in $users?

 

Cheers,

Federico

Gianni88's avatar
Gianni88
Copper Contributor
Dec 03, 2019

FedericoPorceddu82 

 

Thanks, Better and better now. However, I do not have the Manager name (see below) :

It is possible to extract into a csv file ? 

 

Thanks.

 

Gianni

 

  • 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

  • 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

Resources