I am looking into archiving site collections based on use and the web property LastItemUserModifiedDate seems to be perfect. However it seems like the property is not available in search and iterating the 300.000 site collections might be a slow proces. I wonder if the managed property Lastmodifiedtimeforretention is just another alias for LastItemUserModifiedDate, but I can't find any documentation about that property. Any ideas how to locate the site collections without any user updates within the last x days?

enter image description here

I have pulled some data from a production tenant and it looks like Lastmodifiedtimeforretention in most cases is the same as Created date :-( AND it looks like LastItemModified isn't a good indicator either.


Just poking around at my sites it looks like Lastmodifiedtimeforretention<1/1/2019 ContentClass=STS_Site might get you close.

| improve this answer | |
  • Close only counts in horse shoe and hand granates ;-) It seems like Lastmodifiedforretention often is set at creation time so the result set will contain a large number of sites that has been Modified resently. – Kasper Bo Larsen Jul 8 '19 at 14:37
  • Then you need to find another date to use. – Matthew McDermott Jul 9 '19 at 14:45
  • Either that or check web. LastItemUserModifiedDate in a number of parallel processes without getting throttled. I am surprised that LastItemUserModifiedDate is not available through Search but perhaps MS Graph is an option – Kasper Bo Larsen Jul 9 '19 at 16:59

Per my test, to get the site collections without any user updates within the last x days.


Lastmodifiedtime<(special date) AND ContentClass=STS_Site

| improve this answer | |
  • Hi Lisa, so Lastmodifiedtime and LastItemUserModifiedDate are identical in your environment ? – Kasper Bo Larsen Jul 8 '19 at 8:17
  • LastItemModifiedtime and LastItemUserModifiedDate are not identical. The latter property was added later by Microsoft to reflect changes made by user accounts only. The former property was influenced by changes made by the system. You can use PowerShell to list all SharePoint sites in your Office 365 tennant with the LastItemUserModifiedDate: alexholmeset.blog/2017/09/03/sharepoint-lastitemmodifieddate – Lisa Chen MSFT Jul 12 '19 at 11:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.