This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 84%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
So I haven't used PowerShell in a while wondering the best way to Export specific OU's users that do not have profile pictures tied to their account via Powershell.
https://learn.microsoft.com/en-us/answers/questions/31510/how-can-i-get-the-list-of-users-with-profile-pictu.html followed something similar to this but nothing returns the information I need.
Not urgent but any help would be appreciated.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 68%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELT%3C/text%3E%3C/svg%3E)
Hello there,
Following are the requirements before we get started. Make sure you set up your environment with these:
-Azure AD Administrator
-Exchange Online Administrator
-AzureAD PowerShell Module
-Exchange Online PowerShell Module (only if MFA is in use)
First and foremost, we need to fetch the Office365 credentials and then connect to Azure Active Directory and Exchange Online.
$cred = get-Credential
Connect-AzureAD -Credential $cred
$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $cred -Authentication Basic -AllowRedirection
Import-PSSession $Session
$Users = Get-AzureADUser | Where {$.UserType -eq 'Member' -and $.AssignedLicenses -ne $null}
$NoPicUsers = @()
foreach ($user in $Users)
{
$Picture = Get-UserPhoto -Identity $user.UserPrincipalName -ErrorAction SilentlyContinue
if ($Picture -eq $null)
{
$NoPicUsers += $user
}
}
------------------------------------------------------------------------------------------------------------------------------------------------
--If the reply is helpful, please Upvote and Accept it as an answer–
Thank you for this, Is it possible to export the information of those who don't have a PFP to excel? I just realised I missed this from my original question.
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 88%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
If anything, you would need to have:
$Users = Get-AzureADUser | Where {$_.UserType -eq 'Member' -and $_.AssignedLicenses -ne $null}
But that is terrible (slow & inefficient)
Use code from here:
https://o365info.com/manage-user-photos-microsoft-graph-powershell/
and
https://www.alitajran.com/get-mguser/
and get working script:
# Set CSV file path to save the results
$CSVPath = "C:\temp\PhotosStatus.csv"
# Connect with privileges
Connect-MgGraph -Scopes "User.ReadWrite.All"
# $users = Get-MgUser -All
$users = Get-MgUser -All -Filter "OnPremisesSyncEnabled eq true and UserType eq 'Member'" -ConsistencyLevel eventual -CountVariable CountVar
$results = foreach ($user in $users) {
$photo = Get-MgUserPhoto -UserId $user.Id -ErrorAction SilentlyContinue
$photoSet = ![string]::IsNullOrEmpty($photo)
$height = if ($photoSet) { $photo.Height } else { $null }
$width = if ($photoSet) { $photo.Width } else { $null }
[PSCustomObject]@{
UserPrincipalName = $user.UserPrincipalName
PhotoSet = $photoSet
Height = $height
Width = $width
}
}
$results | Sort-Object UserPrincipalName | Out-GridView -Title "Photos Status"
$results | Sort-Object UserPrincipalName | Export-Csv -Path "$CSVPath" -NoTypeInformation -Encoding UTF8
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(153.6, 72%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKD%3C/text%3E%3C/svg%3E)
I am trying to add the Manager property to this script and it's not providing any information. I know it's an expanded property, but thought I'd correctly added this to the script.
I've added the below:
# Connect with privileges
Connect-MgGraph -Scopes "User.ReadWrite.All"
# $users = Get-MgUser -All
$users = Get-MgUser -All -Filter "OnPremisesSyncEnabled eq true and UserType eq 'Member'" -ConsistencyLevel eventual -CountVariable CountVar
$results = foreach ($user in $users) {
$photo = Get-MgUserPhoto -UserId $user.Id -ErrorAction SilentlyContinue
$photoSet = ![string]::IsNullOrEmpty($photo)
$height = if ($photoSet) { $photo.Height } else { $null }
$width = if ($photoSet) { $photo.Width } else { $null }
$manager = Get-MgUser -UserId $user.Id -ExpandProperty Manager
[PSCustomObject]@{
UserPrincipalName = $user.UserPrincipalName
PhotoSet = $photoSet
Height = $height
Width = $width
Manager = $user.Manager.AdditionalProperties.mail
}
}
$results | Sort-Object UserPrincipalName | Out-GridView -Title "Photos Status"
$results | Sort-Object UserPrincipalName | Export-Csv -Path "C:\temp\PhotosStatus1.csv" -NoTypeInformation -Encoding UTF8
Thank you.