Sharepoint Personal Site

Hi @Handian Sudianto ,

Currently, you cannot directly view personal sites, that is, OneDrive URLs, in the SharePoint admin center. The sites you see in the Active sites section are all non-personal sites. There are two ways to get a list of OneDrive URLs:

1. Use the OneDrive usage report to view the list of OneDrive users and URLs

• Go to the OneDrive usage report in the Microsoft 365 admin center and sign in as a SharePoint Administrator, or reports reader.
• Scroll to the table below the charts.

1. Use PowerShell to create a list of all the OneDrive URLs in your organization

• Download the latest SharePoint Online Management Shell.
• Save the following text to a PowerShell file. For example, you could save it to a file named OneDriveSites.ps1.

$TenantUrl = Read-Host "Enter the SharePoint admin center URL"
$LogFile = [Environment]::GetFolderPath("Desktop") + "\OneDriveSites.log"
Connect-SPOService -Url $TenantUrl
Get-SPOSite -IncludePersonalSite $true -Limit all -Filter "Url -like '-my.sharepoint.com/personal/'" | Select -ExpandProperty Url | Out-File $LogFile -Force
Write-Host "Done! File saved as $($LogFile)."

• Open the SharePoint Online Management Shell. Navigate to the directory where the script was saved and run:

PS C:\>.\OneDriveSites.ps1

• The script prompts you for the SharePoint admin center URL. For example, https://contoso-admin.sharepoint.com is the Contoso SharePoint admin center URL.
• When prompted, sign in with your SharePoint Administrator account credentials.

For more details, please refer to:

https://learn.microsoft.com/en-us/sharepoint/list-onedrive-urls

https://www.sharepointdiary.com/2019/01/sharepoint-online-powershell-get-onedrive-url-of-user.html

Non-official, just for reference.

Good day!

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Hi @Handian Sudianto ,

Welcome to Q&A forum!

The difference between personal and non-personal SharePoint sites refers to the type and purpose of the sites:

1. Personal SharePoint Sites:
   • Often referred to as OneDrive for Business.
   • These are personal storage spaces for individual users.
   • Each user in your organization has their own personal site.
   • These sites are used primarily to store personal documents and files that are not meant for wider collaboration.
   • The site owner is usually the individual user.
2. Non-Personal SharePoint Sites:
   • Also referred to as SharePoint Online Sites.
   • These can be team sites, communication sites, or other types of collaborative workspaces.
   • They are used for team collaboration, department resources, projects, and organizational information sharing.
   • The ownership of these sites can vary, often managed by teams or departments rather than individuals.

When selecting what to back up, you should consider whether you need to back up individual users' personal files (OneDrive for Business) or the collaborative and organizational data stored in team and other non-personal SharePoint sites. Good day! :-)

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.