sharepoint 統計所有網站集合中視頻檔案的總大小 c#

標籤：sharepoint

視頻檔案類型為：.avi .mov .rm .rmvb .wmv .asf .asx .mpg .mpeg .3gp .mp4 .flv .mkv .vob

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;
using System.IO;
using System.Web;
using System.Text.RegularExpressions;
using System.Data;

namespace GetVideoFiles
{
    class Program
    {
        static void Main(string[] args)
        {
            Console.WriteLine("This tool is designed for find video fies in all Site collection.eg: .avi,.mov,.rm,.rmvb,.wmv,.asf,.asx,.mpg,.mpeg,.3gp,.mp4,.flv,.mkv,.vob");
            string pattern = @"(\.avi|\.mov|\.rm|\.rmvb|\.wmv|\.asf|\.asx|\.mpg|\.mpeg|\.3gp|\.mp4|\.flv|\.mkv|\.vob)$";
            Regex regex = new Regex(pattern, RegexOptions.IgnoreCase | RegexOptions.Compiled | RegexOptions.Singleline);

            InitionFile();
            Console.WriteLine("Please input the web url:");
            String weburl = Console.ReadLine();
            Uri webAppUri = new Uri(weburl);
            SPWebApplication webApplication = SPWebApplication.Lookup(webAppUri);

            Console.WriteLine("Name\tSize\tSizeOfVersions\tTotalSize\tWebUrl");
            writer.WriteLine("Name\tSize\tSizeOfVersions\tTotalSize\tWebUrl");

            Int64 allSitesSizes =0;
            Int64 allSitesHistorySizes = 0;
            Int64 allSitesTotalSizes = 0;
            foreach (SPSite site in webApplication.Sites)         
             {
                DataTable oDtRawData = null;
                oDtRawData = site.StorageManagementInformation(SPSite.StorageManagementInformationType.Document, SPSite.StorageManagementSortOrder.Decreasing, SPSite.StorageManagementSortedOn.Size,300000);
                /*  // if you wan to see column names, loop through all the columns and find out the names and grab the needed one.
                foreach (DataColumn oColumn in oDtRawData.Columns)
                        {
                             Console.WriteLine(oColumn.ColumnName);               
                          }
               */
                string siteUrl = site.Url;
                Int64 sizes = 0;
                Int64 historySizes = 0;
                Int64 totalSizes = 0;
                foreach (DataRow oRow in oDtRawData.Rows)
                 {                    
                    //Console.WriteLine("Processing......" + oRow["LeafName"].ToString());                                
                     if (regex.IsMatch(oRow["LeafName"].ToString()))
                     {
                         string size1 = oRow["Size"].ToString();
                         string historySize1 = oRow["SizeOfVersions"].ToString();
                         string totalSize1 = oRow["TotalSize"].ToString();
                         Int64 size = Convert.ToInt64(size1);
                         Int64 historySize = Convert.ToInt64(historySize1);
                         Int64 totalSize = Convert.ToInt64(totalSize1);
                         sizes = sizes + size;
                         historySizes = historySizes + historySize;
                         totalSizes = totalSizes + totalSize;
                        
                        // Console.WriteLine(oRow["LeafName"].ToString() + "\t" + oRow["Size"].ToString() + "\t" + oRow["SizeOfVersions"].ToString() + "\t" + oRow["TotalSize"].ToString() + "\t" + oRow["WebUrl"].ToString());
                         writer.WriteLine(oRow["LeafName"].ToString() + "\t" + oRow["Size"].ToString() + "\t" + oRow["SizeOfVersions"].ToString() + "\t" + oRow["TotalSize"].ToString() + "\t" + oRow["WebUrl"].ToString());
                        
                     }

                    }
                if(totalSizes != 0)
                {
                    Console.WriteLine("#SUM\t{0}MB\t{1}MB\t{2}MB\t{3}", Math.Round(sizes / 1024.0f / 1024.0f, 2), Math.Round(historySizes / 1024.0f / 1024.0f, 2), Math.Round(totalSizes / 1024.0f / 1024.0f, 2), siteUrl);
                    writer.WriteLine("#SUM\t{0}MB\t{1}MB\t{2}MB\t{3}", Math.Round(sizes / 1024.0f / 1024.0f, 2), Math.Round(historySizes / 1024.0f / 1024.0f, 2), Math.Round(totalSizes / 1024.0f / 1024.0f, 2), siteUrl);
               
                }
               allSitesSizes = allSitesSizes+sizes;
               allSitesHistorySizes = allSitesHistorySizes+historySizes;
               allSitesTotalSizes = allSitesTotalSizes+totalSizes;
              
            }
            Console.WriteLine("#AllSitesSUM\t{0}MB\t{1}MB\t{2}MB", Math.Round(allSitesSizes / 1024.0f / 1024.0f,2), Math.Round(allSitesHistorySizes / 1024.0f / 1024.0f,2), Math.Round(allSitesTotalSizes / 1024.0f / 1024.0f,2));
            writer.WriteLine("#AllSitesSUM\t{0}MB\t{1}MB\t{2}MB", Math.Round(allSitesSizes / 1024.0f / 1024.0f, 2), Math.Round(allSitesHistorySizes / 1024.0f / 1024.0f, 2), Math.Round(allSitesTotalSizes / 1024.0f / 1024.0f, 2));

            CloseFile();
           
        }

        static StreamWriter writer;
        static void InitionFile()
        {
            writer = new StreamWriter("videos.txt", false);
        }
        static void CloseFile()
        {
            writer.Flush();
            writer.Close();
        }

        static void WriteLine(string msg)
        {
            writer.WriteLine(msg);
        }
    }
}

本文出自 “博深” 部落格，轉載請與作者聯絡！

sharepoint 統計所有網站集合中視頻檔案的總大小 c#