question

sajithgh avatar image
0 Votes"
sajithgh asked AllenXu-MSFT commented

Office 365 Group Team Sites details like Owner, Source of Workload

We can export csv file of Office 365 Group Team Sites details from the admin Center. However the Owner details and Source of Workload (Teams, Outlook etc) by that the site got created are missing

107589-office365groupteamsite.png



Is there any other option to get these information ?

office-sharepoint-online
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AllenXu-MSFT avatar image
0 Votes"
AllenXu-MSFT answered AllenXu-MSFT commented

Hi @sajithgh ,

As per my knowledge, there is no OOB way to export owner details and the source of workload by the SharePoint site. You can get owner details via accessing Microsoft 365 admin center -> Users -> Active users -> Export users. To retrieve associated SharePoint site URL for Microsoft Teams, you can achieve it using Graph/REST API, Powershell and etc. Reference: https://www.syskit.com/blog/retrieve-associated-sharepoint-site-url-for-microsoft-teams/.
Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This URL is not working.

https://{yourTenant}-admin.sharepoint.com/Lists/DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECO/DO_NOT_DELETE_SPLIST_TENANTADMIN_VIEW_ALL_SITES.aspx

Throwing the below error

Sorry, something went wrong
The referenced file '/_layouts/15/online/spo.master' is not allowed on this page.

0 Votes 0 ·

@sajithgh,

Yes, I could repro on my end. This way seems to be outdated. Try other ways in that article.

0 Votes 0 ·
sadomovalex avatar image
0 Votes"
sadomovalex answered

you can also get list of all Sharepoint Online sites with owners using PowerShell: SharePoint Online: Get All Site Collections using PowerShell. Also you may fetch list of SPO sites which are associated with O365 group using technique shown here: Fetch Sharepoint Online sites associated with O365 groups via Sharepoint Search KQL.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.