How to get all site collections in a web application

Question

I want to list all site collections in my web application; the goal is to list all mysites created by users.

Like:

/members/sites/sqladmin
/members/sites/sqluser
/members/sites/sqluser1
/members/sites/sqluser2
/members/sites/user1

Answer 1

To access all site collections within this web application, there is, of course, the SPWebApplication.Sites property . To access a specific web application, you can use this code:

SPWebApplication webApp = SPWebApplication.Lookup(new Uri("http://my-web-app-url:80/"));

(see MSDN here ).

Answer 2

Use a property for this SPWebApplication.Sites.

Answer 3

On the Central Administration home page, click Application Management.

On the Application Management page, in the Site Collections section, click View All Site Collections.

The site collection list page lists all site collections in the web application.

Answer 4

Use the code below to programmatically retrieve all site application site collections. url parametter = URL of the web application.

        public DataTable GetAllSiteCollections(string url)
        {
            DataTable dt = new DataTable();
            dt.Columns.Add("URL");
            dt.Columns.Add("Name");
            SPSecurity.RunWithElevatedPrivileges(delegate()
            {
                SPWebApplication webApplication = SPWebApplication.Lookup(new Uri(url));
                foreach (SPSite site in webApplication.Sites)
                {
                    dt.Rows.Add(new object[] { site.Url, site.Url });

                }

            });

            return dt;
        }