Get-SPOSite how to get all sites on my tenant with a Sensitivity label = Highly Confidential?

Question

The Powershell command Get-SPOSite gets all sites on my Office 365 tenant. How could I filter all site with a sensitivy label?

vasilmichev · Answer

Use a filter against the&nbsp;SensitivityLabel property? It has to be a client-side filter though, via where-object, as the -Filter parameter doesn't seem to support the SensitivityLabel property.

fhunth · Answer

I get this column with blank values. Get-SPOSite | select Url, SensitivityLabel
Url SensitivityLabel
--- ----------------
https://mycompany.sharepoint.com/sites/Test4531
https://mycompany.sharepoint.com/sites/TestSensi
https://mycompany.sharepoint.com/sites/Test41

vasilmichev · Answer

Try using the -Detailed switch.

fhunth · Answer

Same result. New WarningPS C:\WINDOWS\system32&gt; Get-SPOSite&nbsp;-Detailed | select Url, SensitivityLabel&nbsp;WARNING: The -Detailed parameter will be deprecated for bulk enumeration.

martin rublik · Answer

fhunth&nbsp;for what it's worth it seems that SensitivityLabel property is filled only if you use the&nbsp;-Identity $siteUrl filter. So you would need to iterate through all the sites and get the sites again :(.&nbsp;So basically you need to iterate&nbsp;$sites=Get-SPOSite -Limit ALL$sites | ForEach-Object {$site=Get-SPOSite -Identity $siteUrlif ($site.SensitivityLabel -eq 'ID-HighlyCOnfidential'){return $site}}

Forum Discussion

Get-SPOSite how to get all sites on my tenant with a Sensitivity label = Highly Confidential?

5 Replies