Strange 'lastModifiedDateTime' object when requesting a sharepoint site with microsoft graph api

Question

I am trying to detect sharepoint sites in Office 365 not visited last 180 days. With this purpose I query sharepoint sites using a microsoft graph api query like this: GET https://graph.microsoft.com/v1.0/sites?search= which returns an JSON object where object['value'] is the first portion of site objects and object['@odata.nextLink'] is the link to the next portion of site objects (as I understand from what I see in the output) When I view site objects which look like this:

 'id': 'mytenant.sharepoint.com,29c17bd8-db42-430d-b5ba-b55d15885790,6302ea22-aa16-4e12-bd50-6e7094fc65cd',
 'lastModifiedDateTime': '0001-01-01T08:00:00Z',
 'name': 'TEST_MODIFIED_DATE',
 'webUrl': 'https://mytenant.sharepoint.com/sites/TEST_MODIFIED_DATE',
 'displayName': 'TEST_MODIFIED_DATE',
 'root': {},
 'siteCollection': {'hostname': 'mytenant.sharepoint.com'}}

in a loop I can see 'lastModifiedDateTime' property which may (or may not) be what I am looking for. Some sites and this one in particular have a strange value of 'lastModifiedDateTime': 'lastModifiedDateTime': '0001-01-01T08:00:00Z'

What does this strange datetime value mean?
Does it mean the last time the site was visited at all? It does not correspond with the value I can see in Sharepoint web interface ('last activity' column, which is now empty for this site)?

Please use the 'id' that you have got from the search query and try to use that site id in the following query. graph.microsoft.com/v1.0/sites{siteid} You can get the right lastModifiedDateTime. Please let me know if you have any queries on this. — Shiva Keshav Varma
– Shiva Keshav Varma, Commented Sep 2, 2020 at 10:17
@Shiva-MSFTIdentity, thank you very much! It seems to be what I need. It returns 'lastModifiedDateTime': '2020-09-01T04:44:20Z', which is correct. But I am curious why the PowerShell cmdlet "Get-SPOSite" returns that site and it has the attribute "LastContentModifiedDate: 03.09.2020 22:22:45" which is not correct. Do you know what these attributes precisely mean? — Максим Родин
– Максим Родин, Commented Sep 4, 2020 at 7:04

Shiva Keshav Varma · Accepted Answer · 2020-09-04 07:28:24Z

0

You can try using the 'id' that you have got from the search query and try to use that site id in the following query. https://graph.microsoft.com/v1.0/sites{siteid} You can get the right lastModifiedDateTime as shown below.

Please go through this document.

answered Sep 4, 2020 at 7:28

Shiva Keshav Varma

3,6052 gold badges13 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Strange 'lastModifiedDateTime' object when requesting a sharepoint site with microsoft graph api

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related