Is it possible to run a query to find which user profiles are missing a picture?

[Mercy Shitemi]

I believe the way to do this would be using CSOM, but I have not been able to figure out how. We user sharepoint online and our tenant has about 1300 user profiles. We build our organisational chart off this pool and we would like to make sure each user has a picture.

I hope someone here has some ideas.

Thank you,

Mercy

[#2]

You could use Get-PnPUserProfileProperty

Are you looking for PowerShell or code?

PowerShell:

https://github.com/SharePoint/PnP-PowerShell/blob/master/Documentation/GetPnPUserProfileProperty.md

[#3]

"Are you looking for PowerShell or code?" Which ever one would work.

The result I am looking for is a list of all users missing the profile picture property. The comand you gave me would require I look at the user profiles one at a time?

Mercy

[#4]

Ok, here you go the full Powershell script to get this done:

https://veenstra.me.uk/2016/11/25/office-365-get-all-users-without-a-user-profile-photo-using-pnp-po...