Get the Details of a Site, Subsite, Lists, Library For Migration Purposes in SharePoint

Introduction

This article explains how to get the details of a site, sub-site, list and library count from a Web application using server-side code in SharePoint.

The following are the prerequisites:

1. SharePopint Server.
2. The EPPlus DLL.

Use the following procedure:

1. Create a console application.
2. Open Visual Studio as an Administrator.
3. Click on "File" -> "New" -> "Project...".
   
   
   
   
   
   
4. Select Console Application and enter the name as “Site Details” and click on "Ok".
   
   
5. Go to Solution Explorer and right-click on References and add the following references.
   
   
   
6. • Microsoft.SharePoint.dll (this will be available in the 14 hive folder/ISAPI).
     
     
   • EPPlus.dll (dowload it from Google) this DLL creats an Excel file.
     
     
     
     
7. Now copy and paste the following code into the Main program.
   

   static void Main(string[] args)
   {
       try
       {
           string siteURL = string.Empty;
           DataTable siteDT = new DataTable();
           siteDT.Columns.Add("SiteUrl");
           siteDT.Columns.Add("ListName");
           siteDT.Columns.Add("ItemCount");
           Console.WriteLine("Please enter the url to extract the details:");
           siteURL = Console.ReadLine();
           Console.WriteLine("The entered site url is: " + siteURL);
           if (!string.IsNullOrEmpty(siteURL))
           {
               using (SPSite site = new SPSite(siteURL))
               {
                   DataRow webRow = siteDT.NewRow();
   llWebs loops through the site as well as the subsites.
                   foreach (SPWeb web in site.AllWebs)
                   {
                       webRow["SiteUrl"] = web.Url;
                       siteDT.Rows.Add(webRow);
                       Console.WriteLine("Web Name: " + web.Name);
                       foreach (SPList list in web.Lists)
                       {
                           DataRow listRow = siteDT.NewRow();
                           listRow["ListName"] = list.Title;
                           listRow["ItemCount"] = list.ItemCount;
                           siteDT.Rows.Add(listRow);
                           Console.WriteLine(list.Title + " count is " + list.ItemCount);
                       }
   
                   }
   
   
               }
               if (siteDT.Rows.Count > 0)
               {
                   string filenamewithpath = "C://SiteDetails.xls";
                   if (File.Exists(filenamewithpath))
                       File.Delete(filenamewithpath);
                   FileInfo newFile = new FileInfo(filenamewithpath);
                   using (ExcelPackage pck = new ExcelPackage(newFile))
                   {
                       ExcelWorksheet ws = pck.Workbook.Worksheets.Add("SiteDetails");
                       ws.Cells["A1"].LoadFromDataTable(siteDT, true);
                       pck.Save();
                   }
               }
   
           }
           Console.WriteLine("Press enter to exit");
           Console.ReadLine();
       }
       catch (Exception ex)
       {
   
           Console.WriteLine("Error occured:" + ex.Message);
           Console.WriteLine(ex.StackTrace);
           Console.ReadLine();
       }
   }

8. To make the solution work in the SharePoint 2010 environment, the following properties must be set.
   
   In the Application tab the Target FrameWork should be “.Net FrameWork 3.5”.
   
   In the Build tab the Platform Target should be set to “Any CPU”.
   
   

Testing

1. Now to run the application click on the "Play" button.
   
   
   
   
2. Enter the web application URL and click on Enter.
   
   Eg: http://servername:8080/
   
   
3. Now you will be able to see the Excel file SiteDetails that will be available in the C drive at C://SiteDetails.xls.

Summary

Thus in this article you saw how to get the details of site, subsite, list and library count from a web application using server-side code in SharePoint.