Forum Discussion
SharePoint Online > Sites > Deleted Sites - Column defeinitions
Hi David_Covert
I am not sure if this would be helpful, but the source of the data is the list stored on the SP Admin site.
You can retrieve deleted site items using this URL
https://<YOUR TENANT>-admin.sharepoint.com/_api/web/lists/getByTitle('DO_NOT_DELETE_SPLIST_TENANTADMIN_ALL_SITES_AGGREGATED_SITECOLLECTIONS')/items?$filter=TimeDeleted%20ne%20null
As you said, the information stored there should be straightforward. When you delete the site, these fields are filled out. Is there an issue with the entire date, or is it just a problem with the time?
Thanks for the reply.
In answer to your question that dates shown do not appear accurate to me, from the perspective that I deleted a site, and the date and time listed were off by several days. I'll test some more to ensure I'm not bonkers.
But further, I do have retention policies in place that disallow the deletion of sites, so there shouldn't be any listed that I did not create an exception for and delete myself.
As to the URL you sent, it shows a ton of XML text when I customize it for my domain, not sure if that's what it is supposed to present or not but that's what I'm getting. I've attached a screenshot snip of some of the output as an example.
Hi DavidCovert, I hoped that maybe the difference would only be in hours. If it's about the days, then it's a different story. ;/
The XML output is correct; you can parse it using an XML parser to check the data (if I'm not wrong, it should also be possible using MS Excel).
The provided link retrieves data from the source list of deleted sites. I provided it just in case you want to verify if the deletion date in the XML is correct and maybe it is just a problem of rendering it on the Admin Site. In this case, it looks like the problem is different.
