用户配置文件属性-SPS-PictureTimestamp [英] User Profile Attribute - SPS-PictureTimestamp

问题描述

你好团队

               我正在尝试使用REST API阅读Sharepoint用户个人资料.我的意图是检索最近更改其个人资料图片的所有用户的列表.在仔细研究属性的同时， 我找到了一个名为"SPS-PictureTimestamp"的属性，但不确定它存储的内容是什么，以及如何将该值转换为有效的日期时间.对此表示感谢.

                 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.

推荐答案

"SPS-PictureTimestamp"属性似乎未存储图片更改时间.

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

作为一种解决方法，我们可以查询用户个人资料数据库中的[UserProfileEventLog]表.

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

如果您想在客户端获取数据，我们可以创建一个自定义Web服务来实现它.

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

最好的问候，

丹尼斯

这篇关于用户配置文件属性-SPS-PictureTimestamp的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！