Forum Discussion
SharePoint Online > Sites > Deleted Sites - Column defeinitions
Hello all,
I am looking at the SharePoint Admin Center > Sites > Deleted Sites page
And there are multiple columns available, including Site name, URL, Storage used (GB) just to name a few.
But I am confused by the Date Created and Time Deleted columns, they do not appear to coordinate with what I know as the dates and times these sites were created and/or deleted. I know these columns are likely deemed self-explanatory, but again, I know that the dates and times shown are not accurate.
I've been searching the web for a couple days and all I'm finding are instructions on how to restore a deleted site, perhaps my Google-Fu is failing terribly, but is there any documentation concerning this page that includes the column definitions and how their data is derived?
Thanks in advance,
-David Covert
3 Replies
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.
