User Profile Attribute - SPS-PictureTimestamp RRS feed

  • Question

  • Hello Team,

                     I am trying to read Sharepoint user profile using REST API. My intention is to retrieve the list of all users who have changed their profile picture recently. While goring though the attributes, I have found one attribute named 'SPS-PictureTimestamp' but not sure what exactly it stores and how can I convert this value into a valid datetime. Appreciate any input on this.

    Tuesday, March 14, 2017 1:10 PM

All replies

  • Hi,

    The 'SPS-PictureTimestamp' property seems not store the picture change time.

    As a workaround, we can query the [UserProfileEventLog] table in user profile database.

    select * from [UserProfileEventLog]
    where cast(NewValueData as varchar(255)) like '%_MThumb.jpg'
    order by EventTime desc

    If you want to get the data in client side, we can create a custom web service to achieve it.

    Best Regards,


    Please remember to mark the replies as answers if they help.
    If you have feedback for TechNet Subscriber Support, contact

    Wednesday, March 15, 2017 9:45 AM
  • So what exactly does this sps-picturetimestamp show? We are trying to do something similar but using sharepoint online.
    Tuesday, May 2, 2017 3:40 PM