Forum Discussion
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 ...
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
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
Hi Gianni88 ,
ok it's easy 🙂
You need to use just
Connect-AzureADinstead of
$AzureAdCred = Get-Credential
Connect-AzureAD -Credential $AzureAdCred
the second part of the script it's the same 🙂
Cheers,
Federico
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
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
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
Hi Gianni88 ,
try to run
> $users = Get-AzureADUser -All $true > $usersafter connect 🙂
Are there users in $users?Cheers,
Federico
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.