Obtain a list of users who haven't uploaded a picture in their SharePoint 2010 User Profile

In the event that your HR team would like to "bust" all individuals who haven't uploaded a picture in their user profile, here is a simple SQL query that you can run against the SharePoint 2010 User Profile content database that will provide them with a name and email address of the "offending" users:

SELECT
[UserProfile_Full].PreferredName,
[UserProfile_Full].Email
FROM [User Profile Service Application_ProfileDB].[dbo].[UserProfile_Full]
WHERE PictureUrl IS NULL

NOTE: You may need to modify the database name. If your SharePoint Admin used the default farm setup process, a GUID will be tagged to the database name.