Forum Discussion

Copper Contributor

Nov 20, 2019

Solved

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
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

Copper Contributor

Dec 02, 2019

Hi Federico,

As we use MFA (Multa Factor Authentification), I am not able to get into Powershell. I tried to follow this link (without success) : https://docs.microsoft.com/en-us/powershell/exchange/office-365-scc/connect-to-scc-powershell/mfa-connect-to-scc-powershell?view=exchange-ps

Do you know which command I need to run to connect to Powershell Azure (with MFA) ?

Thanks.

Gianni

FedericoPorceddu82

MVP

Dec 02, 2019

ok it's easy 🙂

You need to use just

Connect-AzureAD

instead of

$AzureAdCred = Get-Credential
Connect-AzureAD -Credential $AzureAdCred

the second part of the script it's the same 🙂

Cheers,

Federico

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
Gianni88
Copper Contributor
Dec 03, 2019
FedericoPorceddu82

Thanks Federico for your help !
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
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
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
Copper Contributor
Dec 03, 2019
Hi Federico,

Thanks, step by step we move forward, I am in now 🙂

When I run the ps1 file, it does not display anything (look at the attachment).

What I am doing wrong ?

Thanks.

Resources