SOLVED
Home

Generate Audit Report of Site Collections for Size and Date Last Accessed

%3CLINGO-SUB%20id%3D%22lingo-sub-698649%22%20slang%3D%22en-US%22%3EGenerate%20Audit%20Report%20of%20Site%20Collections%20for%20Size%20and%20Date%20Last%20Accessed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-698649%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20admin%20center%2C%20I%20can%20see%20that%20we%20have%20a%20ton%20of%20sites%20that%20are%20empty%20and%2For%20have%20not%20been%20accessed%20for%20eons.%20I%20would%20like%20to%20generate%20an%20Excel%20or%20CSV%20of%20the%20following%20(using%20SPO%20Powershell%20is%20fine%2C%20too)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E-%20Site%20name%3C%2FP%3E%3CP%3E-%20Site%20or%20site%20collection%3C%2FP%3E%3CP%3E-%20Modern%20or%20Classic%3C%2FP%3E%3CP%3E-%20Created%20by%3C%2FP%3E%3CP%3E-%20Created%20date%3C%2FP%3E%3CP%3E-%20Date%20last%20accessed%3C%2FP%3E%3CP%3E-%20Accessed%20by%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20no%20idea%20where%20to%20start%2C%20though.%20I%20found%20a%20couple%20of%20Office%20365%20admin%20scripts%20that%20run%20reports%2C%20but%20none%20of%20them%20offered%20a%20report%20like%20the%20one%20I'm%20asking%20for.%20I'm%20sure%20if%20I%20could%20even%20just%20find%20a%20generic%20audit%20of%20sites%20and%20size%20and%20last%20accessed%2C%20it%20would%20help.%20Also%2C%20if%20I'm%20going%20about%20this%20the%20wrong%20way%2C%20please%20let%20me%20know%20.%20.%20.%20is%20there%20another%20way%20that%20admins%20seek%20out%20reports%20for%20useless%20%2F%20unused%20sites%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-698649%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUsage%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-699372%22%20slang%3D%22en-US%22%3ERe%3A%20Generate%20Audit%20Report%20of%20Site%20Collections%20for%20Size%20and%20Date%20Last%20Accessed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699372%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F194188%22%20target%3D%22_blank%22%3E%40Charisma%20Riley%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20view%20this%20information%20in%20the%20modern%20SharePoint%20Admin%20Centre%2C%20there%20is%20the%20option%20to%20customize%20columns%20for%20more%20information%20-%20this%20has%20majority%20of%20the%20information%20you%20listed.%20There%20is%20also%20an%20export%20button%20to%20CSV%20which%20you%20can%20then%20process%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-699823%22%20slang%3D%22en-US%22%3ERe%3A%20Generate%20Audit%20Report%20of%20Site%20Collections%20for%20Size%20and%20Date%20Last%20Accessed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-699823%22%20slang%3D%22en-US%22%3EToally%20agree%20with%20this%20recommendation%20here%20and%20of%20course%2C%20you%20can%20always%20build%20your%20own%20PS%20script%20to%20get%20the%20information%20you%20need%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-708231%22%20slang%3D%22en-US%22%3ERe%3A%20Generate%20Audit%20Report%20of%20Site%20Collections%20for%20Size%20and%20Date%20Last%20Accessed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708231%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5563%22%20target%3D%22_blank%22%3E%40Paul%20Bullock%3C%2FA%3E%26nbsp%3B%20and%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B%3A%20Thanks%2C%20you%20guys!%20I'll%20go%20try%20it%20out%3B%20I%20guess%20I%20missed%20the%20CSV%20export%20bit.%20Appreciate%20it!%20%3AD%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Charisma Riley
Occasional Contributor

In the admin center, I can see that we have a ton of sites that are empty and/or have not been accessed for eons. I would like to generate an Excel or CSV of the following (using SPO Powershell is fine, too):

 

- Site name

- Site or site collection

- Modern or Classic

- Created by

- Created date

- Date last accessed

- Accessed by

 

I have no idea where to start, though. I found a couple of Office 365 admin scripts that run reports, but none of them offered a report like the one I'm asking for. I'm sure if I could even just find a generic audit of sites and size and last accessed, it would help. Also, if I'm going about this the wrong way, please let me know . . . is there another way that admins seek out reports for useless / unused sites?

 

Thanks, everyone!

 

 

3 Replies
Solution

Hi @Charisma Riley 

 

You can view this information in the modern SharePoint Admin Centre, there is the option to customize columns for more information - this has majority of the information you listed. There is also an export button to CSV which you can then process in Excel.

 

Paul

Toally agree with this recommendation here and of course, you can always build your own PS script to get the information you need

@Paul Bullock  and @Juan Carlos González Martín : Thanks, you guys! I'll go try it out; I guess I missed the CSV export bit. Appreciate it! :D

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies