locked
User Profiles Missing picture RRS feed

  • Question

  • Is there a SQL query or Powershell one-liner that will show all SharePoint user profiles that do not have a picture?
    Friday, July 22, 2011 7:45 PM

Answers

  • Try running this query against the SSP database

    SELECT * FROM USERPROFILE_FULL

    WHERE PICTUREURL IS NOT NULL 

    --Valid user accounts will have an email id

    AND EMAILID IS NOT NULL

    OR PICTUREURL <> ''

     

    Thanks

    Prasad

    • Marked as answer by Emir Liu Friday, July 29, 2011 10:45 AM
    Saturday, July 23, 2011 2:30 PM