Elencare tutte le site collection dello SharePoint Online con PowerShell
Per poter elencare tutte le site collection create sullo SharePoint Online tramite PowerShell, è necessario avere installato l'ultima versione di SharePoint Online Management Shell che mette a disposizione una serie di comandi del tipo Verbo-SPOOggetto.
Prima di tutto bisogna connettersi al tenant con il comando Connect-SPOService:
poi con il comando Get-SPOSite è possibile elencare tutte le site collection
Per vedere tutti i comandi SPO disponibili:
Se è già installata una versione precedente potrebbe essere necessario rimuoverla prima di procedere con l'installazione.
Prima di tutto bisogna connettersi al tenant con il comando Connect-SPOService:
PowerShell
$adminUPN="email es: nome@orhName.onmicrosoft.com"
$orgName="nomeOrganizzazione"
$userCredential = Get-Credential -UserName $adminUPN -Message "Password:"
Connect-SPOService -Url https://$orgName-admin.sharepoint.com -Credential $userCredential
poi con il comando Get-SPOSite è possibile elencare tutte le site collection
PowerShell
Get-SPOSite | select url, template
DOS / Batch file
Url Owner Storage Quota
--- ----- -------------
https://xxx.sharepoint.com/sites/AppCatalog alberto@xxx.onmicrosoft.com 26214400
https://xxx.sharepoint.com/ 26214400
https://xxx.sharepoint.com/sites/godigitalA alberto@xxx.onmicrosoft.com 26214400
https://xxx.sharepoint.com/sites/grptestaddon 26214400
https://xxx.sharepoint.com/search 26214400
https://xxx-my.sharepoint.com/ 26214400
https://xxx.sharepoint.com/portals/Community 26214400
https://xxx.sharepoint.com/portals/hub 26214400
https://xxx.sharepoint.com/sites/HD 26214400
PowerShell
Get-SPOSite
Text
Url Template
--- --------
https://xxx.sharepoint.com/sites/AppCatalog APPCATALOG#0
https://xxx.sharepoint.com/ SitePagePublishing#0
https://xxx.sharepoint.com/sites/godigitalA STS#0
https://xxx.sharepoint.com/sites/grptestaddon GROUP#0
https://xxx.sharepoint.com/search SRCHCEN#0
https://xxx-my.sharepoint.com/ SPSMSITEHOST#0
https://xxx.sharepoint.com/portals/Community POINTPUBLISHINGTOPIC#0
https://xxx.sharepoint.com/portals/hub POINTPUBLISHINGHUB#0
https://xxx.sharepoint.com/sites/HD BLANKINTERNET#0
PowerShell
Get-SPOSite https://xxx.sharepoint.com | Format-List
Text
astContentModifiedDate : 14/04/2020 21:55:01
Status : Active
ResourceUsageCurrent : 0
ResourceUsageAverage : 0
StorageUsageCurrent : 13
LockIssue :
WebsCount : 2
CompatibilityLevel : 15
DisableSharingForNonOwnersStatus :
HubSiteId : 00000000-0000-0000-0000-000000000000
IsHubSite : False
RelatedGroupId : 00000000-0000-0000-0000-000000000000
GroupId : 00000000-0000-0000-0000-000000000000
Url : https://xxx.sharepoint.com/
LocaleId : 1040
LockState : Unlock
Owner : 4ebd8943-a7630-4039-921d-5a7994a9f0af
StorageQuota : 26214400
StorageQuotaWarningLevel : 25574400
ResourceQuota : 300
ResourceQuotaWarningLevel : 255
Template : SITEPAGEPUBLISHING#0
Title : Communication site
AllowSelfServiceUpgrade : True
DenyAddAndCustomizePages : Enabled
PWAEnabled : Unknown
SharingCapability : ExternalUserAndGuestSharing
SiteDefinedSharingCapability : ExternalUserAndGuestSharing
SandboxedCodeActivationCapability : Disabled
DisableCompanyWideSharingLinks : NotDisabled
DisableAppViews : NotDisabled
DisableFlows : NotDisabled
ProtectionLevelName :
StorageQuotaType :
RestrictedToGeo : Unknown
ShowPeoplePickerSuggestionsForGuestUsers : False
SharingDomainRestrictionMode : None
SharingAllowedDomainList :
SharingBlockedDomainList :
ConditionalAccessPolicy : AllowFullAccess
AllowDownloadingNonWebViewableFiles : False
LimitedAccessFileType : WebPreviewableFiles
AllowEditing : True
SensitivityLabel :
CommentsOnSitePagesDisabled : False
SocialBarOnSitePagesDisabled : False
DefaultSharingLinkType : None
DefaultLinkPermission : None
DefaultLinkToExistingAccess : False
AnonymousLinkExpirationInDays : 0
OverrideTenantAnonymousLinkExpirationPolicy : False
ExternalUserExpirationInDays : 0
OverrideTenantExternalUserExpirationPolicy : False
InformationSegment : {}
BlockDownloadLinksFileType : WebPreviewableFiles
Per vedere tutti i comandi SPO disponibili:
PowerShell
Get-Command *-spo*