This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 86%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Need help with a powershell to list all the SPO sites where the offline client availability is set to true.
Hi,
I saw a similar question and answer in the following thread. Please have a look
Script to get all site collections and subsites from entire farm
I think, get-spsite -filter switch will help you to list all the SPO sites with the certain character in URL
Yes but my requirement is mainly on "offline client availability is set to true." Let me know if you have seen similar requirement.
Get-SPOSite -Filter { url -like "https://tenant.sharepoint.com/sites/888*"} -Detailed | Export-CSV -LiteralPath C:\Script\SitesInventory.csv -NoTypeInformation
The above command helps me with the filter but the "offline client availability is set to true " is where am struck
I think, you can run the below script to set offline client availability to 'true' in the list you prepared
$site =
foreach ($web in $site.AllWebs)
{ write-host "Site: $web"
foreach($list in $web.lists){ $list.ExcludeFromOfflineClient = true
$list.update();
}
}
$site.dispose()
I dont want to update the list/library , I want the list of sites where the ExcludeFromOfflineClient is set to true
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 51%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EED%3C/text%3E%3C/svg%3E)
When running PowerShell command Get-SPOSite -Identity https://tenant.sharepoint.com/sites/emilytest -detailed |fl, we could get following paraments of a site collection.
According to above results, there is no parament about offline client availability. So, run PowerShell script to list all SPO sites with the certain character in URL where the offline client availability is set to true is not available.
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.