SharePoint 2013 Hosting – HostForLIFE.eu :: Get Site Collection From Web Application

We can get the subsites under the site using CSOM easily but if we need to get all the site collections under a specific web application from a SharePoint farm, then we can’t get it directly. For that, we have to use SharePoint search. By using SharePoint Search, we set the “KeywordQuery” to filter and get the site collections. Before using the code block, we should ensure that the SharePoint Search Service Application is running and active.

The code block for this is mentioned below.

    using System;  
    using System.Collections.Generic;  
    using System.Linq;  
    using System.Net;  
    using System.Text;  
    using System.Threading.Tasks;  
    using Microsoft.SharePoint.Client;  
    using Microsoft.SharePoint.Client.Search.Query;  
    namespace GetSitecollFromWebApplication {  
        class GetSitecollByUsingSearch {  
            static void Main(string[] args) {  
                string webAppUrl = string.Empty;  
                string username = string.Empty;  
                string password = string.Empty;  
                NetworkCredential credentials = null;  
                webAppUrl = "webAppUrl"; //Please provide the Web Application URL  
                username = "userName";  
                password = "******";  
                ClientContext ctx = new ClientContext(webAppUrl); //creating ClientContext from given SharePoint Site  
                credentials = new NetworkCredential(username, password); //creating creadential object for SharePoint site.  
                ctx.Credentials = credentials;  
                // Before executing the below code please ensure Search Service Application is running  
                KeywordQuery keyQuery = new KeywordQuery(ctx);  
                keyQuery.QueryText = "contentclass:\"STS_Site\"";  
                keyQuery.RowLimit = 500; // the maximum row limit is 500 for KeywordQuery  
                keyQuery.EnableStemming = true;  
                keyQuery.TrimDuplicates = false;  
                SearchExecutor searchExe = new SearchExecutor(ctx);  
                ClientResult < ResultTableCollection > resultTabColl = searchExe.ExecuteQuery(keyQuery);  
                ctx.ExecuteQuery();  
                var siteCollection = resultTabColl.Value.SelectMany(rs => rs.ResultRows.Select(r => r["Path"])).ToList();  
                if (siteCollection != null && siteCollection.Count > 0) {  
                    foreach(var site in siteCollection) {  
                        Console.WriteLine(site);  
                    }  
                    Console.ReadLine();  
                } else {  
                    Console.WriteLine("Sorry, there were no Site Collections for the Web Application.");  
                    Console.ReadLine();  
                }  
            }  
        }  
    }

using System;

using System.Collections.Generic;

using System.Linq;

using System.Net;

using System.Text;

using System.Threading.Tasks;

using Microsoft.SharePoint.Client;

using Microsoft.SharePoint.Client.Search.Query;

namespace GetSitecollFromWebApplication {

class GetSitecollByUsingSearch {

static void Main(string[] args) {

string webAppUrl = string.Empty;

string username = string.Empty;

string password = string.Empty;

NetworkCredential credentials = null;

webAppUrl = "webAppUrl"; //Please provide the Web Application URL

username = "userName";

password = "******";

ClientContext ctx = new ClientContext(webAppUrl); //creating ClientContext from given SharePoint Site

credentials = new NetworkCredential(username, password); //creating creadential object for SharePoint site.

ctx.Credentials = credentials;

// Before executing the below code please ensure Search Service Application is running

KeywordQuery keyQuery = new KeywordQuery(ctx);

keyQuery.QueryText = "contentclass:\"STS_Site\"";

keyQuery.RowLimit = 500; // the maximum row limit is 500 for KeywordQuery

keyQuery.EnableStemming = true;

keyQuery.TrimDuplicates = false;

SearchExecutor searchExe = new SearchExecutor(ctx);

ClientResult < ResultTableCollection > resultTabColl = searchExe.ExecuteQuery(keyQuery);

ctx.ExecuteQuery();

var siteCollection = resultTabColl.Value.SelectMany(rs => rs.ResultRows.Select(r => r["Path"])).ToList();

if (siteCollection != null && siteCollection.Count > 0) {

foreach(var site in siteCollection) {

Console.WriteLine(site);

}

Console.ReadLine();

} else {

Console.WriteLine("Sorry, there were no Site Collections for the Web Application.");

Console.ReadLine();

}

In this blog, I have explained how you can get all the site Collections under a SharePoint web application. I hope this blog will help you out in a few scenarios.

Print article

This entry was posted by Peter on April 25, 2019 at 7:04 am, and is filed under European SharePoint 2013 Hosting. Follow any responses to this post through RSS 2.0. You can leave a response or trackback from your own site.

SharePoint 2013 Hosting – HostForLIFE.eu :: Get Site Collection From Web Application

BLOGROLL

Featured On

SharePoint 2013 Hosting – HostForLIFE.eu :: Get Site Collection From Web Application

BLOGROLL

Featured On

Tags