SharePoint My Site Analysis Report – A Practical Business Scenario

using System;
using System.IO;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;
using Microsoft.Office.Server;
using Microsoft.Office.Server.Administration;
using Microsoft.Office.Server.UserProfiles;
using System.Web;

namespace SharePoint.AdminReports
{
    class MySiteAnalysis
    {
        static void Main(string[] args)
        {

            //Get the My Site web application URL
            string site;
            string WorkEmail;
            if (args.Length == 0)
            {
                Console.WriteLine("Enter the My site URL:");
                site = Console.ReadLine();
            }
            else
            {
                site = args[0];
            }

            //objects for the CSV file generation
            StreamWriter SW;
            SW = File.AppendText("c:\\SiteOwnersReport.csv");
            //Write the CSV Header
            SW.WriteLine("Site URL, Owner Name, E-Mail, Department");

            try
            {
                SPSite tmpRoot = new SPSite(site);
                SPSiteCollection tmpRootColl = tmpRoot.WebApplication.Sites;

                //Enumerate through each site collection
                foreach (SPSite tmpSite in tmpRootColl)
                {
                    try
                    {
                        WorkEmail = tmpSite.Owner.Email;
                    }
                    catch (NullReferenceException ex1)
                    {
                        WorkEmail = string.Empty;
                    }

                    SW.WriteLine(tmpSite.Url + "," + tmpSite.Owner.LoginName + "," + WorkEmail + "," + GetDepartment(site, tmpSite.Owner.LoginName));
                }
                //Dispose the objects
                SW.Close();
                SW.Dispose();
                tmpRoot.Dispose();

            }
            catch (Exception ex)
            {
                System.Diagnostics.EventLog.WriteEntry("Site Owner Report", ex.Message);
            } 
            }


        //Method to Get the department of the Site owner
        private static string GetDepartment(string siteURL, string loginName)
        {
            string Department;
            try
            {
                
                using (SPSite site = new SPSite(siteURL))
                {
                    // if the Profile not found in Profile store, SharePoint will throw: UserNotFoundException exception
                    try
                    {
                        ServerContext context = ServerContext.GetContext(site);
                        UserProfileManager profileManager = new UserProfileManager(context);
                        UserProfile profile = profileManager.GetUserProfile(loginName);

                        //Department may or May not be associated.
                        try
                        {
                            Department = profile["Department"].Value.ToString();
                        }
                        catch (NullReferenceException ex2)
                        {
                            Department = string.Empty;
                        }
                    }
                    catch (UserNotFoundException ex3)
                    {
                        Department = "** User not Found **";
                    }
                }
            }
            catch (Exception ex4)
            {
                Department = string.Empty;
            }
            return Department;
        }
    }
}