Sharepoint online display externally shared files from all teamsites

%3CLINGO-SUB%20id%3D%22lingo-sub-1112387%22%20slang%3D%22en-US%22%3ESharepoint%20online%20display%20externally%20shared%20files%20from%20all%20teamsites%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1112387%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20way%20to%20display%20all%20externally%20shared%20files%20for%20all%20sharepoint%20online%20(team)sites.%3C%2FP%3E%3CP%3ESo%20for%20one%20site%20I%20know%20you%20how%20to%20achieve%20this%20by%20going%20to%20the%20SharePoint%20site%20-%26gt%3B%20Site%20Usage%20-%26gt%3B%20Site%20Contents.%20Or%26nbsp%3B%3CFONT%3E%3CA%20href%3D%22https%3A%2F%2Ftenantname.sharepoint.com%2Fsites%2FAdministratieControl%2F_layouts%2F15%2Fsiteanalytics.aspx%3Fview%3D19%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ftenantname.sharepoint.com%2Fsites%2FAdministratieControl%2F_layouts%2F15%2Fsiteanalytics.aspx%3Fview%3D19%3C%2FA%3E%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3EBut%20how%20do%20I%20get%20this%20info%20for%20100%2B%20sites%20at%20once%3F%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3ECheers!%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%3ENiels%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1112387%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eshare%20externally%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%20Modern%20Experience%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1112869%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20online%20display%20externally%20shared%20files%20from%20all%20teamsites%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1112869%22%20slang%3D%22en-US%22%3EThere%20is%20not%20a%20global%20feature%20to%20get%20that%20data%20so%20you%20have%20two%20options%20here%3A%3CBR%20%2F%3E(1)%20Look%20for%20a%20third%20party%20tool%20that%20provides%20this%20feature%20(Take%20a%20look%20at%20the%20Governance%20Tools%20provided%20by%20AvePoint%2C%20Sharegate%2C%20SysKit%20and%20others)%3CBR%20%2F%3E(2)%20Build%20it%20yourself%20using%20SPO%20APIs%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1113235%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20online%20display%20externally%20shared%20files%20from%20all%20teamsites%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1113235%22%20slang%3D%22en-US%22%3E%3CP%3EIt's%20fairly%20easy%20to%20do%20this%20via%20the%20Graph%2C%20I%20have%20a%20sample%20script%20that%20does%20it%20across%20all%20ODFB%20site%20collections%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpractical365.com%2Fclients%2Fonedrive%2Freporting-on-onedrive-for-business-shared-files%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpractical365.com%2Fclients%2Fonedrive%2Freporting-on-onedrive-for-business-shared-files%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EJust%20adapt%20it%20to%20run%20against%20SPO%20SCs%20instead.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1116556%22%20slang%3D%22en-US%22%3ERe%3A%20Sharepoint%20online%20display%20externally%20shared%20files%20from%20all%20teamsites%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1116556%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20replying%20both%2C%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58%22%20target%3D%22_blank%22%3E%40Vasil%20Michev%3C%2FA%3E%20I%20will%20give%20it%20a%20try!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi all,

 

I am looking for a way to display all externally shared files for all sharepoint online (team)sites.

So for one site I know you how to achieve this by going to the SharePoint site -> Site Usage -> Site Contents. Or https://tenantname.sharepoint.com/sites/AdministratieControl/_layouts/15/siteanalytics.aspx?view=19

 

But how do I get this info for 100+ sites at once?

 

Cheers!

 

Niels

3 Replies
Highlighted
There is not a global feature to get that data so you have two options here:
(1) Look for a third party tool that provides this feature (Take a look at the Governance Tools provided by AvePoint, Sharegate, SysKit and others)
(2) Build it yourself using SPO APIs
Highlighted

It's fairly easy to do this via the Graph, I have a sample script that does it across all ODFB site collections here: https://practical365.com/clients/onedrive/reporting-on-onedrive-for-business-shared-files/

 

Just adapt it to run against SPO SCs instead.

Highlighted

Thanks for replying both, @Vasil Michev I will give it a try!