This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Hello,
I want to get data for just 3 sites using "Get-PnPTenantSite" PowerShell command. I dont want to get all data and then filter for just 3 sites or using Where-Object for filtering, because its like getting all data will take a lot of time. Is there a way we can pass a filter and get data filtered from SPO server only?
"Filter" is there for "Get-PnPTenantSite" command but dont know how to use "in". Able to use "like" or "eq", "like" may match with other sites as well which I dont want and "eq" will work with only single site url. Is there any "OR" we can use so we can have "eq" site 1 OR "eq" site 2 OR "eq" site 3 ?
Thanks in advance!
![](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(57.599999999999994, 33%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXX%3C/text%3E%3C/svg%3E)
Thank you for your question.
We are currently looking into this issue and will give you an update as soon as possible.
Thank you for your understanding and support.
Hi @Yuvraj Patil ,
Using the following powershell code:
#Parameters
$AdminCenterURL = "https://yourdomain-admin.sharepoint.com"
#Connect to Admin Center
Connect-PnPOnline -Url $AdminCenterURL -Interactive
#Get the Site's detailed info
Get-PnPTenantSite | where {$_.Url -eq "https://yourdomain.sharepoint.com/sites/xyza1" -or $_.Url -eq "https://yourdomain.sharepoint.com/sites/xyzax" -or $_.Url -eq "https://yourdomain.sharepoint.com/sites/0718"}
Result:
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.
@Xyza Xue_MSFT
Thanks for replying. But I think its not solving the issue fully.
Get-PnPTenantSite | where {$.Url -eq "https://yourdomain.sharepoint.com/sites/xyza1" -or $.Url -eq "https://yourdomain.sharepoint.com/sites/xyzax" -or $_.Url -eq "https://yourdomain.sharepoint.com/sites/0718"}
For above command, "Get-PnPTenantSite" will pull/get all sites details so it will take a lot of time and then "| where" will filter from all sites result. Even after using filter its taking lot of time (because its loading all sites) .
If you see below example both queries are taking same time, which I dont want. Filtering should happen on server so that it should take small amount of time.
#get all sites
$timer = [Diagnostics.Stopwatch]::StartNew()
$allSharePointSites = Get-PnPTenantSite
$timer.stop()
$timer.Elapsed
$allSharePointSites.Count
Write-host "------------------"
#get some sites
$timer = [Diagnostics.Stopwatch]::StartNew()
$tmp=Get-PnPTenantSite | where {$.Url -eq "https://<tenantname>.sharepoint.com/sites/wiki" -or $.Url -eq "https://<tenantname>.sharepoint.com/sites/WikiSite02"}
$timer.stop()
$timer.Elapsed
$tmp.Count
Output:
Days : 0
Hours : 0
Minutes : 0
Seconds : 2
Milliseconds : 850
Ticks : 28507492
TotalDays : 3.29947824074074E-05
TotalHours : 0.000791874777777778
TotalMinutes : 0.0475124866666667
TotalSeconds : 2.8507492
TotalMilliseconds : 2850.7492
1229
Days : 0
Hours : 0
Minutes : 0
Seconds : 2
Milliseconds : 726
Ticks : 27268859
TotalDays : 3.15611793981481E-05
TotalHours : 0.000757468305555556
TotalMinutes : 0.0454480983333333
TotalSeconds : 2.7268859
TotalMilliseconds : 2726.8859
2
Hi Yuvraj Patil,
I understand what you are saying, you want to get data filtered from SPO server. But this is not possible and the above is the only way to do it. If the data filtered from the SPO server will burden the server, this may cause more damage. So it is designed to require local culling of data, which I can understand your regret.
Can we use below filter option to have multiple site collections in it? I think this filters on server side.
$tmp=Get-PnPTenantSite -Filter "Url -eq 'https://vx2.sharepoint.com/sites/wiki'"
Can we use below filter option to have multiple site collections in it? I think this filters on server side and takes small amount of tile to get data.
$tmp=Get-PnPTenantSite -Filter "Url -eq 'https://vx2.sharepoint.com/sites/wiki'"
Hi, I tried this at the beginning and this filter option cannot contain multiple sites.
Hi @Yuvraj Patil,
How's going today? Do you have further concerns regarding this issue? Please feel free to talk with us if you have other questions. If the above info is helpful to this question, you can click "Accept Answer". Have a nice day!