using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.WebPartPages;
using System.Collections.Generic;
using System.Text;
using Microsoft.SharePoint.Administration;
using System.Xml;
using System.Data.SqlClient;
using System.Security.Principal;
using System.IO;
using System.Diagnostics;
public partial class ApplicationWiseStatisstics : System.Web.UI.Page
{
public static string ListName, sDocumentLibrary;
protected void Page_Load(object sender, EventArgs e)
{
try
{
WindowsImpersonationContext wic = WindowsIdentity.GetCurrent().Impersonate();
SPSite rootSite = SPContext.Current.Site;
SPWebApplication webApp = rootSite.WebApplication;
//SPWebApplicationCollection webApplicationCol = SPWebService.ContentService.WebApplications;
DataTable tbl = new DataTable();
tbl.Columns.Add("Title", typeof(string));
tbl.Columns.Add("Url", typeof(string));
tbl.Columns.Add("DocumentCount", typeof(string));
tbl.Columns.Add("TotDocItemCnt", typeof(string));
tbl.Columns.Add("Announcements", typeof(string));
tbl.Columns.Add("TotItemAnnouncements", typeof(string));
tbl.Columns.Add("Links", typeof(string));
tbl.Columns.Add("TotItemLinks", typeof(string));
tbl.Columns.Add("Tasks", typeof(string));
tbl.Columns.Add("TotItemTasks", typeof(string));
tbl.Columns.Add("PictureLibrary", typeof(string));
tbl.Columns.Add("TotItemPictureLibrary", typeof(string));
tbl.Columns.Add("Posts", typeof(string));
tbl.Columns.Add("TotItemPosts", typeof(string));
DataRow row;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
//foreach (SPWebApplication webApp in webApplicationCol)
{ //Web application name
for (int i = 0; i < webApp.Sites.Count; i++)
// if (webApp.Sites.Count <= 50)
{
if (webApp.Sites[i].Url != "http://dha02202-mosd05:500/orgs/30018526/30002982")
{
SPSite site = webApp.Sites[i];
// Response.Write(webApp.Sites[i].Url + " webApp.Sites.Names
");
int countDocList = 0;
int totalItemcount = 0;
//int countDocList = 0;
int countAnnouncements = 0;
int countTask = 0;
int countLink = 0;
int countCalender = 0;
int countImg = 0;
int countPost = 0;
int totAnnouncount = 0;
int totTaskcount = 0;
int totLinkcount = 0;
int totCalendercount = 0;
int totPostcount = 0;
int totImgcount = 0;
string lastItemIdOnPage = null; // Page position.
// Response.Write(site.AllWebs.Count + " WEB COUNT
");
for (int j = 0; j < site.AllWebs.Count; j++)
{
SPWeb web = site.AllWebs[j];
SPWebCollection sites = web.Webs;
if (sites.Count > 0)
{
// Response.Write(sites.Count + " sites.Count
");
foreach (SPWeb subSite in sites)
{
try
{
// Response.Write(subSite.Title + "
");
//SPWeb rootWeb = site.RootWeb;
SPListCollection lists = subSite.Lists;
// SPListCollection lists = web.Site.RootWeb.Lists;
if (lists.Count > 0)
{
// Response.Write(lists.Count + " lists.Count
");
foreach (SPList list in lists)
{
//**********DocumentLibrary**********///
//if (List.BaseType == SPBaseType.DocumentLibrary && List.BaseTemplate == SPListTemplateType. .DocumentLibrary)
if (list.BaseTemplate == SPListTemplateType.DocumentLibrary)
{
countDocList += list.ItemCount;
totalItemcount += 1;
}
//**********Announcement**********///
if (list.BaseTemplate == SPListTemplateType.Announcements)
{
countAnnouncements += list.ItemCount;
totAnnouncount += 1;
}
//**********Links **********///
if (list.BaseTemplate == SPListTemplateType.Links)
{
countLink += list.ItemCount;
totLinkcount += 1;
}
//**********Task **********///
if (list.BaseTemplate == SPListTemplateType.Tasks)
{
countTask += list.ItemCount;
totTaskcount += 1;
}
//**********Images PictureLibrary **********///
if (list.BaseTemplate == SPListTemplateType.PictureLibrary)
{
countImg += list.ItemCount;
totImgcount += 1;
}
//*********Events blogs**********///
//119 Wiki Page library
if (list.BaseTemplate == SPListTemplateType.Events)//SPListTemplateType.Posts)
{
countPost += list.ItemCount;
totPostcount += 1;
}
subSite.Dispose();
}
}
//subSite.Dispose();
}//if check
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
site.Dispose();
// web.Dispose();
subSite.Dispose();
}
}
} //if
web.Dispose();
}// for
row = tbl.Rows.Add();
row["Title"] = site.RootWeb.Title;
row["Url"] = site.RootWeb.Url;
row["DocumentCount"] = countDocList;
row["TotDocItemCnt"] = totalItemcount;
row["Announcements"] = countAnnouncements;
row["TotItemAnnouncements"] = totAnnouncount;
row["Links"] = countLink;
row["TotItemLinks"] = totLinkcount;
row["Tasks"] = countTask;
row["TotItemTasks"] = totTaskcount;
row["PictureLibrary"] = countImg;
row["TotItemPictureLibrary"] = totImgcount;
row["Posts"] = countPost;
row["TotItemPosts"] = totPostcount;
site.Dispose();
} //
}
}
});
tbl.AcceptChanges();
gdView.AutoGenerateColumns = false;
gdView.Visible = true;
gdView.DataSource = tbl;
gdView.DataBind();
gdView.PageIndex = 0;
wic.Undo();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}
protected void gdView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gdView.PageIndex = e.NewPageIndex;
gdView.DataBind();
}
}
=======================================================
<%@ Page Language="C#" AutoEventWireup="true" Debug="true" CodeFile="ApplicationWiseStatisstics.aspx.cs" Inherits="ApplicationWiseStatisstics" %>
Application Wise Count
